Publication Date:October 15, 2009 Availability:Usually ships in 1-2 business days
Features:
•
ISBN13: 9781430224617
•
Condition: New
•
Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed
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 is this book for?
This book is for developers who will be writing database applications against SQL Server databases.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
Customer Reviews: An Excellent BookSeptember 1, 2010 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.
A must-have for beginner/intermediate T-SQL admins and a great valueMay 8, 2010 T. Lee(Colorado, USA) 2 out of 2 found this review helpful
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.
A good way to start learning T-SQLApril 9, 2010 Pedro Araujo Coutinho(Portugal) 1 out of 1 found this review helpful
A well maid and thought book for the begginers. It goes deep enough for starters without compromising the goal. It gives good examples and explanations of what can be done. By completing the exercises you certanly get a good knowledge and understanding of T-SQL. A very good investment for people that don't know SQL or know it but want to work with T-SQL
Great introduction to T-SQLNovember 9, 2009 Reese Watt(St. Louis, MO) 5 out of 5 found this review helpful
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.
A Book for both Beginners and the Intermediate T-SQL ProgrammersNovember 6, 2009 Live and Learn(SL) 4 out of 4 found this review helpful
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.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
