{"product_id":"9781484200612","title":"SQL Server T-SQL Recipes","description":"\u003cp\u003e\u003cem\u003eSQL Server T-SQL Recipes\u003c\/em\u003e is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem\/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. \u003c\/p\u003e\u003cp\u003eSolutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFocused on solutions: Look up what you need to do. Learn how to do it. Do it.\u003c\/li\u003e\n\u003cli\u003eCurrent: Lightly updated for SQL Server 2014\u003c\/li\u003e\n\u003cli\u003eComprehensive: Covers all common T-SQL problem domains\u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e\n\u003cli\u003eCreate databases, tables, and indexes\u003c\/li\u003e\n\u003cli\u003eQuery and manipulate data\u003c\/li\u003e\n\u003cli\u003eMove business logic into the database\u003c\/li\u003e\n\u003cli\u003eBuild reports that matter to your business.\u003c\/li\u003e\n\u003cli\u003ePerform common backup and recovery tasks\u003c\/li\u003e\n\u003cli\u003eTake advantage of window functions in your SQL\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003eSQL Server T-SQL Recipes\u003c\/em\u003e is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use SQL Server as their back–end database platform, and the database administrators who create, manage, and secure those databases.      \u003c\/p\u003e     Table of Contents\u003cp\u003e1. Getting Started with SELECT\u003c\/p\u003e\u003cp\u003e2. Elementary Programming\u003c\/p\u003e\u003cp\u003e3. Working with NULLS\u003c\/p\u003e\u003cp\u003e4. Combining Data from Multiple Tables\u003c\/p\u003e\u003cp\u003e5. Aggregations and Grouping\u003c\/p\u003e\u003cp\u003e6. Advanced SELECT Techniques\u003c\/p\u003e\u003cp\u003e7. Windowing\u003c\/p\u003e\u003cp\u003e8. Inserting, Updating, Deleting\u003c\/p\u003e\u003cp\u003e9. Working with Strings\u003c\/p\u003e\u003cp\u003e10. Working with Dates\u003c\/p\u003e\u003cp\u003e11. Working with Numbers\u003c\/p\u003e\u003cp\u003e12. Transactions, Locking, Blocking, Deadlockin\u003c\/p\u003e\u003cp\u003e13. Managing Tables\u003c\/p\u003e\u003cp\u003e14. Managing Views\u003c\/p\u003e\u003cp\u003e15. Managing Indexes\u003c\/p\u003e\u003cp\u003e16. Managing Large Tables\u003c\/p\u003e\u003cp\u003e17. Stored Procedures\u003c\/p\u003e\u003cp\u003e18. User-Defined Functions\u003c\/p\u003e\u003cp\u003e19. In-Memory T-SQL\u003c\/p\u003e\u003cp\u003e20. Triggers\u003c\/p\u003e\u003cp\u003e21. Error Handling\u003c\/p\u003e\u003cp\u003e22. Query Performance\u003c\/p\u003e\u003cp\u003e23. Hints\u003c\/p\u003e\u003cp\u003e24. Index Tuning and Statistics\u003c\/p\u003e\u003cp\u003e25. XML\u003c\/p\u003e\u003cp\u003e26. Files, Filegroups, and Integrity\u003c\/p\u003e\u003cp\u003e27. Backup\u003c\/p\u003e\u003cp\u003e28. Recovery\u003c\/p\u003e\u003cp\u003e29. Principals and Users\u003c\/p\u003e\u003cp\u003e30. Securables and Permissions\u003c\/p\u003e\u003cp\u003e31. Objects and Dependencies\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47126758916336,"sku":"9781484200612","price":41.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781484200612_p0.jpg?v=1763631876","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781484200612","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}