Ben Forta
This title is out of print. The latest edition is Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes (Second Edition) .

Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes

ISBN
0672328674
Pages
320
Publisher
Sams — August 2007

SQL Server is one of the most popular and important database management systems in the world. From small development projects to some of the best known and most prestigious sites on the Web, SQL Server has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data storage needs.

This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes. That book has become one of the most used SQL tutorials in the world, with an emphasis on teaching what you really need to know, methodically, systematically, and simply. But as popular and as successful as that book it, it does have some limitations:

And that is where this book comes in. Sams Teach Yourself SQL Server T-SQL In Ten Minutes builds on the proven tutorials and structure of Sams Teach Yourself SQL in Ten Minutes, without getting bogged down with anything but Transact SQL. Starting with simple data retrieval and working on to more complex topics including the use of joins, subqueries, regular expression and full text based searches, stored procedures, cursors, triggers, table constraints, XML support, and much more. You’ll learn what you need to know methodically, systematically, and simply – in 30 highly focused lessons designed to make you immediately and effortlessly productive.

Is this book right for you? This is a beginner-intermediate book, and is not intended for SQL or Transact SQL experts. This book is for you if:

If you want to invest minimal time (and cost) for a crash course on one of the most important DBMSs out there, then this book is indeed for you.

Note: This title covers SQL Server 2000 and 2005, and several chapters are only applicable to SQL Server 2005 (and are noted as such in the text).

Chapter listing

Introduction
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
Appendix A: Getting Started With SQL Server
Appendix B: The Example Tables
Appendix C: T-SQL Statement Syntax
Appendix D: T-SQL Datatypes
Appendix E: T-SQL Reserved Words

Supporting resources

Appendix B: The Example Tables

Errata

This title has 14 corrections available.

Other editions of this title

← Back to books View all books