{"product_id":"9780735658141","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":"Microsoft Press","offers":[{"title":"Default Title","offer_id":47015241908464,"sku":"9780735658141","price":49.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780735658141_p0.jpg?v=1763622448","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780735658141","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}