Beginning T-SQL 2012, 2nd Edition

eBook Details:

• Paperback: 456 pages
• Publisher: WOW! eBook; 2nd edition (July 4, 2012)
• Language: English
• ISBN-10: 143023704X
• ISBN-13: 978-1430237044

eBook Description:

Beginning T-SQL 2012, 2nd Edition

Beginning T-SQL 2012, 2nd Edition 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, 2nd Edition starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012, 2nd Edition 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. Beginning T-SQL 2012, 2nd Edition is for developers and database administrators who will be writing database applications against SQL Server databases.

Beginning T-SQL 2012, 2nd Edition 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, 2nd Edition starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012, 2nd Edition 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, 2nd Edition is for developers and database administrators who will be writing database applications against SQL Server databases.

Beginning T-SQL 2012, 2nd Edition 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, 2nd Edition starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012, 2nd Edition 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.

[download id=”1314″]