Book description
Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.
Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.
Imparts best practices for writing T-SQL
Helps you avoid common errors
Shows how to write scalable code for good performance
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- Foreword
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: Getting Started
- Chapter 2: Writing Simple SELECT Queries
- Chapter 3: Using Functions and Expressions
- Chapter 4: Querying Multiple Tables
- Chapter 5: Grouping and Summarizing Data
- Chapter 6: Manipulating Data
- Chapter 7: Understanding T-SQL Programming Logic
- Chapter 8: Working with XML
- Chapter 9: Moving Logic to the Database
- Chapter 10: Working with Data Types
- Chapter 11: Writing Advanced Queries
- Chapter 12: Where to Go Next?
- Index
Product information
- Title: Beginning T-SQL 2012
- Author(s):
- Release date: July 2012
- Publisher(s): Apress
- ISBN: 9781430237044
You might also like
book
Microsoft® SQL Server® 2012 T-SQL Fundamentals
Gain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your …
book
SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at …
book
Beginning SQL Server 2012 for Developers
Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server …
book
Inside Microsoft® SQL Server™ 2005: T-SQL Querying
This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of …