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!
Click on a subject to see other books listed with the same
subject or to drill down into components of the subject -- such as
geographical locations, dates and so on.
We query many merchants so that you can instantly
compare prices and
availability. You can even check historic prices and subscribe
for notifications. For a manual check, clicking on a link will open a
new window with a search for this book on the merchant's site of your
choice.
