Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

 

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you'll learn everything you need to know to take advantage of Microsoft SQL Server's T-SQL language.

 

Table of Contents

 

   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 XML

  28. Globalization and Localization

  29. Managing Security

  30. Improving Performance

 

Salient Features

 

Expert author Ben Forta distills the essentials of T-SQL into a set of self-paced lessons in which the reader completes practice exercises designed to illustrate the most important aspects of setting up, using, and administering T-SQL .

Long passages of text are replaced in this unique offering with succinct step-by-step instructions, carefully-crafted examples, and tightly-organized page layouts.

 

 

Publisher	SAMS
Author	Ben Forta
Pages	360
Price	INR Rs. 199.00