Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, Second Edition is the only compact, hands-on introduction to T-SQL, this guide is now fully updated through SQL Server 2016 and the newest version of SQL Server Express. Building on his global best-seller Sams Teach Yourself SQL in 10 Minutes, Ben Forta covers all you need to know to successfully use T-SQL in any database development or DBA role -- including everything that makes T-SQL different from standard SQL. Through carefully-structured, highly-focused lessons, Forta guides you from simple data retrieval through complex topics, helping you become productive quickly and painlessly. Coverage includes: Working with T-SQL in modern SQL Server environments Retrieving data, and then sorting and filtering it Performing wildcard filtering and using advanced data filtering techniques Creating calculated fields Using data manipulation functions Summarizing and grouping data Building subqueries, joining tables, and combining queries Inserting, updating, and deleting data Creating and manipulating tables Using views Programming with T-SQL Working with stored procedures, cursors, and triggers Managing transaction processing Working with Internet formats Globalizing and localizing T-SQL code Optimizing security and performance
Author: Ben Forta