{"product_id":"9781430237051","title":"Beginning T-SQL 2012","description":"\u003cp\u003e    \u003cem\u003eBeginning T-SQL 2012\u003c\/em\u003e 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. \u003cem\u003eBeginning T-SQL 2012\u003c\/em\u003e starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003cem\u003eBeginning T-SQL 2012 \u003c\/em\u003ebegins 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.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cul\u003e   \u003cli\u003eImparts best practices for writing T-SQL \u003c\/li\u003e   \u003cli\u003eHelps you avoid common errors \u003c\/li\u003e   \u003cli\u003eShows how to write scalable code for good performance \u003c\/li\u003e  \u003c\/ul\u003e           What you’ll learn\u003cul\u003e   \u003cli\u003eThe fundamentals of relational theory, upon which Transact-SQL is based \u003c\/li\u003e   \u003cli\u003eHow to write accurate queries that are scalable and perform well \u003c\/li\u003e   \u003cli\u003eHow to combine set-based and procedural processing, obtaining the best from both worlds \u003c\/li\u003e   \u003cli\u003eHow to embed business logic in your database through stored procedures and functions \u003c\/li\u003e   \u003cli\u003eHow to simplify your work with new and advanced features, such as common table expressions and virtual tables \u003c\/li\u003e   \u003cli\u003eHow to enhance performance by knowing when to apply features such table value parameters, and when not to \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eBeginning T-SQL 2012\u003c\/em\u003e is for developers and database administrators who will be writing database applications against SQL Server databases.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eGetting Started \u003c\/li\u003e   \u003cli\u003eWriting Simple SELECT Queries \u003c\/li\u003e   \u003cli\u003eUsing Functions and Expressions \u003c\/li\u003e   \u003cli\u003eQuerying Multiple Tables \u003c\/li\u003e   \u003cli\u003eGrouping and Summarizing Data \u003c\/li\u003e   \u003cli\u003eManipulating Data \u003c\/li\u003e   \u003cli\u003eUnderstanding T-SQL Programming Logic \u003c\/li\u003e   \u003cli\u003eWorking with XML \u003c\/li\u003e   \u003cli\u003eMoving Logic to the Database \u003c\/li\u003e   \u003cli\u003eWorking with Data Types \u003c\/li\u003e   \u003cli\u003eWriting Advanced Queries \u003c\/li\u003e   \u003cli\u003eWhere to Go Next? \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47141783798000,"sku":"9781430237051","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430237051_p0.jpg?v=1763750302","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430237051","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}