{"product_id":"9780672337925","title":"Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself","description":"\u003cp\u003e \u003ci\u003eSams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes \u003c\/i\u003eoffers straightforward, practical answers when you need fast results. By working through the book’s 30 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Microsoft SQL Server’s T-SQL language.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, \u003c\/p\u003e\u003cp\u003eXML, JSON, and much more.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eLearn how to…\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Use T-SQL in the Microsoft SQL Server environment \u003c\/li\u003e \u003cli\u003e Construct complex T-SQL statements using multiple clauses and operators \u003c\/li\u003e \u003cli\u003e Filter data so you get the information you need quickly \u003c\/li\u003e \u003cli\u003e Retrieve, sort, and format database contents \u003c\/li\u003e \u003cli\u003e Join two or more related tables \u003c\/li\u003e \u003cli\u003e Make SQL Server work for you with globalization and localization \u003c\/li\u003e \u003cli\u003e Create subqueries to pinpoint your data \u003c\/li\u003e \u003cli\u003e Automate your workload with triggers \u003c\/li\u003e \u003cli\u003e Create and alter database tables \u003c\/li\u003e \u003cli\u003e Work with views, stored procedures, and more \u003c\/li\u003e \u003c\/ul\u003e \u003cb\u003eContents at a Glance\u003c\/b\u003e \u003cp\u003e1 Understanding SQL \u003cbr\u003e2 Introducing SQL Server \u003cbr\u003e3 Working with SQL Server \u003cbr\u003e4 Retrieving Data \u003cbr\u003e5 Sorting Retrieved Data \u003cbr\u003e6 Filtering Data \u003cbr\u003e7 Advanced Data Filtering \u003cbr\u003e8 Using Wildcard Filtering \u003cbr\u003e9 Creating Calculated Fields \u003cbr\u003e10 Using Data Manipulation Functions \u003cbr\u003e11 Summarizing Data \u003cbr\u003e12 Grouping Data \u003cbr\u003e13 Working with Subqueries \u003cbr\u003e14 Joining Tables \u003cbr\u003e15 Creating Advanced Joins \u003cbr\u003e16 Combining Queries \u003cbr\u003e17 Full-Text Searching \u003cbr\u003e18 Inserting Data \u003cbr\u003e19 Updating and Deleting Data \u003cbr\u003e20 Creating and Manipulating Tables \u003cbr\u003e21 Using Views \u003cbr\u003e22 Programming with T-SQL \u003cbr\u003e23 Working with Stored Procedures \u003cbr\u003e24 Using Cursors \u003cbr\u003e25 Using Triggers \u003cbr\u003e26 Managing Transaction Processing \u003cbr\u003e27 Working with XML and JSON \u003cbr\u003e28 Globalization and Localization \u003cbr\u003e29 Managing Security \u003cbr\u003e30 Improving Performance \u003cbr\u003eA The Example Tables \u003cbr\u003eB T-SQL Statement Syntax \u003cbr\u003eC T-SQL Datatypes \u003cbr\u003eD T-SQL Reserved Words \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":47015011090672,"sku":"9780672337925","price":29.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780672337925_p0.jpg?v=1763611987","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780672337925","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}