T-SQL Tutorials - TSQLTutorials.com

 Location:  Home » TSQL Books » Beginning T-SQL 2008 (Books for Professionals by Professionals)  

Beginning T-SQL 2008 (Books for Professionals by Professionals)

Beginning T-SQL 2008 (Books for Professionals by Professionals)Author: Kathi Kellenberger
Publisher: Apress
Category: Book

List Price: $39.99
Buy New: $14.69
as of 9/5/2010 20:21 EDT details
You Save: $25.30 (63%)



New (26) Used (9) from $14.69

Seller: BOOKS__UNLIMITED
Rating: 5.0 out of 5 stars reviews
Sales Rank: 121027

Media: Paperback
Edition: 1
Pages: 439
Number Of Items: 1
Shipping Weight (lbs): 1.4
Dimensions (in): 9.2 x 7.5 x 1.1

ISBN: 1430224614
Dewey Decimal Number: 005.756
EAN: 9781430224617
ASIN: 1430224614

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

Also Available In:

  • Kindle Edition - Beginning T-SQL 2008

Similar Items:


Editorial Reviews:

Product 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 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:
5 out of 5 stars An Excellent Book   September 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.



5 out of 5 stars A must-have for beginner/intermediate T-SQL admins and a great value   May 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.



4 out of 5 stars A good way to start learning T-SQL   April 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


5 out of 5 stars Great introduction to T-SQL   November 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.



5 out of 5 stars A Book for both Beginners and the Intermediate T-SQL Programmers   November 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.


AddThis Social Bookmark Button
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.
TSQL Tutorials

Copyright 2010 - TSQLTutorials.com