| | |  | Software Engineering | Home » » » Beginning T-SQL 2008 (Books for Professionals by Professionals) | | | | | | | Product Promotions: | | | | | Description: | | Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible. You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code. This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code. - Imparts best practices for writing T-SQL
- Helps readers avoid common errors
- Shows how to write scalable code that yields good performance
What you’ll learn - Understand the fundamentals of relational theory, upon which Transact-SQL is based
- Write accurate queries that are scalable and perform well
- Combine set-based and procedural processing, obtaining the best from both worlds
- Embed business logic in your database through stored procedures and functions
- Simplify your work through new and advanced features such as common-table expressions and virtual tables
- Enhance performance by knowing when to apply features such table value parameters
Who this book is for This book is for developers who will be writing database applications against SQL Server databases. Table of Contents - Getting Started
- Writing Simple SELECT Queries
- Using Functions and Expressions
- Querying Multiple Tables
- Grouping and Summarizing Data
- Manipulating Data
- Understanding T-SQL Programming Logic
- Moving Logic to the Database
- Working with New Data Types
- Writing Advanced Queries
- Where to Go Next?
| | | Features: | |
• ISBN13: 9781430224617
• Condition: New
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
| | | Product Details: | | | Author:
| Kathi Kellenberger | | Paperback:
| 439 pages | | Publisher:
| Apress | | Publication Date:
| October 15, 2009 | | Language:
| English | | ISBN:
| 1430224614 | | Product Length:
| 9.1 inches | | Product Width:
| 7.5 inches | | Product Height:
| 1.1 inches | | Product Weight:
| 1.4 pounds | | Package Length:
| 9.2 inches | | Package Width:
| 7.5 inches | | Package Height:
| 1.1 inches | | Package Weight:
| 1.4 pounds | | Average Customer Rating:
|  based on 9 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 9 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
7 of 7 found the following review helpful:
 Great introduction to T-SQLNov 09, 2009
By Reese Watt
This book is a great introduction to T-SQL.
Each topic is explained clearly, with multiple examples. Rather than use just one example to illustrate a point, the author typically uses at least three. This gives the reader multiple perspectives on the topic and clarifies the issue.
The book starts with the basics and builds from there. Even though I have much experience with T-SQL, I learned several points in areas that I thought I already knew.
This isn't an in-depth treatment of how to build complex SQL queries, but it doesn't claim to be. It does a good job of doing what it claims to do: quickly moving a T-SQL user beyond beginner status.
5 of 5 found the following review helpful:
A must-have for beginner/intermediate T-SQL admins and a great valueMay 08, 2010
By T. Lee
"Picky and Pleased"
After purchasing another "Foundational" T-SQL book and discovering that the author's communication level was beyond my understanding, I searched Amazon for several alternatives to help me quickly grow my skills while avoiding filler and wasted time. I purchased two new introductory books and found this one took me from an insecure novice to a comfortable T-SQL administrator. I also looked in bookstores and couldn't find another that came close to ease of use and speed of adapting the material into useable queries.
If you are new to T-SQL this is the book for you. If you're a seasoned T-SQL admin, this book is sure to help you speed up complex query creation. This is by far the best value of all the T-SQL books I've seen to date.
5 of 5 found the following review helpful:
A Book for both Beginners and the Intermediate T-SQL ProgrammersNov 06, 2009
By Live and Learn
"BF"
I didn't know what to expect from this book, even though the author states the book is for beginners as well as those with a bit of T-sql experience. I fall in the latter category, I have some T-sql experience writing the basic select statements, joins, and performing updates. However, there are some other areas such as error-handling, user-defined functions, and string manipulation that I'm not as familiar with. I've been looking for a book that explains these features in a simple manner with clear-cut examples. This book breaks down user-defined functions, error-handling, and strings in a way that is very clear, and the author also provides useful step-by-step examples along with an explanation as to why or when a certain query should be performed. After reading the section and following the syntax on user-defined functions, I clearly understand why you would want to use them and was actually able to create a UDF that extracts data from a comma delimited field.
For the beginner, this book starts at a basic level that allows them to easily follow while those at an intermediate level can go to the sections they want to learn and start at a pace that's not too advanced. I recommend this book for both the beginner and the intermediate t-sql programmer.
3 of 3 found the following review helpful:
A must have book for every beginner for SQL Server - Each Chapter New BeginningNov 19, 2010
By pinaldave
Beginning T-SQL 2008 is one of the best books on the market if you are just beginning to work with Microsoft SQL, or have a little bit of experience and need to learn more quickly.
Each chapter of the book introduces a new subject, and builds upon topics covered in previous chapters. The author of the book, Kathi Kellenberger understands that you need to form a solid foundation of knowledge before moving on to new topics, and sets up each subject nicely. Because the chapters move in an orderly progression, you continue to use skills you learned earlier.
One of the best features of Beginning T-SQL 2008 is that each chapter has multiple examples and exercises. Many books introduce a topic and then never go back to it. This book gives enough examples that you will be familiar with the subject when you come across it in real life. The exercises at the end of the chapter mean that you will be using the skills you learned - and there is no better way to cement a subject in your brain.
The book also includes discussions of the common errors that programmers will come across, how to avoid them, and how to fix them if they happen. Ms. Kellenberger understands that not only do mistakes happen, but they are bound to happen if you aren't trained properly. Mistakes are part of the learning process!
The book begins by discussions relational theory, so that programmers will understand the way T-SQL works from the ground up. It also walks readers through writing accurate queries, combining set-based and procedural processing, embedding logic in stored functions, and so much more.
Overall, the main goal of Beginning T-SQL 2008 is to introduce novices to SQL programming, and quickly familiarize them with the basics of running the program. The book is written with the idea that readers will not know any of the technical terms or vocabulary. However, if you are a little more familiar with SQL and looking to become better, you will still find this book very helpful.
Summary: I must recommend Beginning T-SQL 2008 highly enough. If you are going to buy any beginners guide to Transect-SQL, this is the one you should spend your money on. You can save yourself a lot of time and effort later by using this very affordable manual to learn the basics, which will allow you to become an expert much faster.
2 of 2 found the following review helpful:
An Excellent BookSep 01, 2010
By QA
The book is excellent. I needed to have a basic understanding of T-SQL,
specially coming from SQL Plus background.This kind of book I was looking.
I finished it in a week.
See all 9 customer reviews on Amazon.com
| | |
|
