{"product_id":"9780735673953","title":"Microsoft SQL Server 2012 T-SQL Fundamentals","description":"\u003cp\u003e \u003cb\u003eGain a solid understanding of T-SQL—and write better queries\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eMaster the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator. \u003c\/p\u003e\u003cp\u003eDiscover how to: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eWork with programming practices unique to T-SQL  \u003c\/li\u003e\n\u003cli\u003eCreate database tables and define data integrity \u003c\/li\u003e\n\u003cli\u003eQuery multiple tables using joins and subqueries \u003c\/li\u003e\n\u003cli\u003eSimplify code and improve maintainability with table expressions \u003c\/li\u003e\n\u003cli\u003eImplement insert, update, delete, and merge data modification strategies  \u003c\/li\u003e\n\u003cli\u003eTackle advanced techniques such as window functions, pivoting and grouping sets \u003c\/li\u003e\n\u003cli\u003eControl data consistency using isolation levels, and mitigate deadlocks and blocking  \u003c\/li\u003e\n\u003cli\u003eTake T-SQL to the next level with programmable objects \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47106493972720,"sku":"9780735673953","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780735673953_p0.jpg?v=1763793111","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780735673953","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}