Beginning T-SQL 2012 (Paperback, 2nd ed.)

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 What you'll learn * The fundamentals of relational theory, upon which Transact-SQL is based * How to write accurate queries that are scalable and perform well * How to combine set-based and procedural processing, obtaining the best from both worlds * How to embed business logic in your database through stored procedures and functions * How to simplify your work with new and advanced features, such as common table expressions and virtual tables * How to enhance performance by knowing when to apply features such table value parameters, and when not to Who this book is for Beginning T-SQL 2012 is for developers and database administrators who will be writing database applications against SQL Server databases.

General

Imprint:	Apress
Country of origin:	Germany
Release date:	July 2012
First published:	2012
Authors:	Kathi Kellenberger • Scott Shaw
Dimensions:	236 x 191 x 23mm (L x W x T)
Format:	Paperback - Trade
Pages:	433
Edition:	2nd ed.
ISBN-13:	978-1-4302-3704-4
Categories:	Books > Computing & IT > Computer programming > General Books > Computing & IT > Applications of computing > Databases > General
LSN:	1-4302-3704-X
Barcode:	9781430237044

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!