SQL has concise syntax, flexible usage method and powerful function. It has become the most popular database language (almost any important DBMS supports SQL) and an indispensable, basic skill for any programmers.

Sams Teach Yourself SQL in 10 Minutes is a classic bestseller about SQL beloved by readers around the world. Again, it is used as reference/teaching material in Massachusetts Institute of Technology, University of Illinois System and many other universities. Unlike other similar books, it skips the basic theory part of database technology, directly starts from practice. Instead, it focuses on the most commonly used and essential SQL knowledge in actual work environment, by means of a large number of concise instances.

Except serving as teaching material, the unique arranging mode also makes Sams Teach Yourself SQL in 10 Minutes become a convenient, fast reference manual with extremely strong practicability, which is suitable for beginners to learn SQL and for the majority of software developers or managers to reference.

Table Of Contents

  • 1: Understanding SQL
  • 2: Retrieving Data
  • 3: Sorting Retrieved Data
  • 4: Filtering Data
  • 5: Advanced Data Filtering
  • 6: Using Wildcard Filtering
  • 7: Creating Calculated Fields
  • 8: Using Data Manipulation Functions
  • 9: Summarizing Data
  • 10: Grouping Data
  • 11: Working with Subqueries
  • 12: Joining Tables
  • 13: Creating Advanced Joins
  • 14: Combining Queries
  • 15: Inserting Data
  • 16: Updating and Deleting Data
  • 17: Creating and Manipulating Tables
  • 18: Using Views
  • 19: Working with Stored Procedures
  • 20: Managing Transaction Processing
  • 21: Using Cursors
  • 22: Understanding Advanced SQL Features
  • Appendix A: Sample Table Scripts
  • Appendix B: Working in Popular Applications
  • Appendix C: SQL Statement Syntax
  • Appendix D: Using SQL Datatypes
  • Appendix E: SQL Reserved Words

Book Example Codes

Database tables or creation scripts download:

Download URLs

Edition Download Size
Fifth Edition 4.51 MB
Fourth Edition 2.17 MB
First Edition 1.61 MB
(Homepage)