This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF The popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
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:
1. Understanding SQL
2. Introducing SQL Server
3. Working with SQL Server
4. Retrieving Data
5. Sorting Retrieved Data
6. Filtering Data
7. Advanced Data Filtering
8. Using Wildcard Filtering
9. Creating Calculated Fields
10. Using Data Manipulation Functions
11. Summarizing Data
12. Grouping Data
13. Working with Subqueries
14. Joining Tables
15. Creating Advanced Joins
16. Combining Queries
17. Full Text Searching
18. Inserting Data
19. Updating and Deleting Data
20. Creating and Manipulating Tables
21. Using Views
22. Programming With T-SQL
23. Working with Stored Procedures
24. Using Cursors
25. Using Triggers
26. Managing Transaction Processing
27. Working with Internet Formats
28. Globalization and Localization
29. Managing Security
30. Improving Performance
A. Getting Started With SQL Server
B. The Example Tables
C. T-SQL Statement Syntax
D. T-SQL Datatypes
E. T-SQL Reserved Words