 |
Microsoft SQL Server 2008 T-SQL Fundamentals | Itzik Ben-Gan
Microsoft Press, Paperback, Published October 2008, 688 pages, ISBN 0735626014 | List Price: $49.99
Our Price: $27.25
You Save: $22.74 (45% Off)
| | | Availability: In-Stock |
Read an Excerpt:
Chapter 3: Joins
Excerpt provided courtesy
of Microsoft Press. |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Programming Microsoft SQL Server 2008; Leonard Lobel, et al, $33.95, 43% Off!
- Microsoft SQL Server 2008 Step by Step; Mike Hotek, $27.25, 45% Off!
- Microsoft SQL Server 2008 Administrator's Pocket Consultant; William R. Stanek, $18.95, 46% Off!
- Professional Microsoft SQL Server 2008 Administration; Brian Knight, et al, $30.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
This book walks you through your first steps in T-SQL (also known as Transact-SQL),
which is Microsoft SQL Server's dialect of the standard ANSI-SQL language. You'll
learn the theory behind T-SQL querying and programming, how to develop T-SQL
code to query and modify data, and get an overview of programmable objects.
Although this book is intended for beginners, it is not merely a step-by-step
book. It goes beyond the syntactical elements of T-SQL and explains the logic
behind the language and its elements.
Many aspects of SQL are unique to the language, and are very different from
other programming languages. This book helps you adopt the right state of mind
and gain a true understanding of the language elements. You learn how to think
in terms of sets and follow good SQL programming practices.
The book is not version-specific; it does, however, cover language elements
that were introduced in recent versions of SQL Server, including SQL Server
2008.
To complement the learning experience, the book provides exercises that enable
you to practice what you've learned.
The book starts with a theoretical background to T-SQL querying and programming
(Chapter 1) laying the foundations for the rest of the book, and also coverage
of creating tables and defining data integrity. The book moves on to various
aspects of querying and modifying data (Chapters 2 through 8), then to a discussion
of concurrency and transactions (Chapter 9), and finally provides an overview
of programmable objects (Chapter 10).
This book features a companion Web site that makes available to you all the
code used in the book, the errata, additional resources, and more.
About the Authors
Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server
Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous
training events around the world focused on T-SQL Querying, Query Tuning and
Programming. Itzik is the author of several books about T-SQL. He has written
many articles for SQL Server Magazine as well as articles and whitepapers for
MSDN. Itzik's speaking activities include Tech Ed, DevWeek, PASS, SQL Server
Magazine Connections, various user groups around the world, and Solid Quality
Mentors' events to name a few.
|
|
