Sams Teach Yourself SQL in 10 Minutes

Front Cover
Sams Publishing, 2004 - Computers - 242 pages
22 Reviews

Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.


What people are saying - Write a review

User ratings

5 stars
4 stars
3 stars
2 stars
1 star

Review: Sams Teach Yourself SQL™ in 10 Minutes

User Review  - Aaron - Goodreads

This is the only book I've read dedicated exclusively to SQL, rather than general database concepts, using Access, etc. My goals reading this were: 1) to expand my understanding of relational ... Read full review

Review: Sams Teach Yourself SQL™ in 10 Minutes

User Review  - Carole Hayes - Goodreads

Excellent book for beginners or people who need to brush up on the SQL skills. Had hands on exercises included, so it works well for visual and kinetic learners. Read full review

Selected pages


Understanding SQL
Retrieving Data
Sorting Retrieved Data
Filtering Data
Advanced Data Filtering
Using Wildcard Filtering
Creating Calculated Fields
Using Data Manipulation Functions
Creating Advanced Joins
Combining Queries
Inserting Data
Updating and Deleting Data
Creating and Manipulating Tables
Using Views
Working with Stored Procedures
Managing Transaction Processing

Summarizing Data
Grouping Data
Working with Subqueries
Joining Tables
Using Cursors
Understanding Advanced SQL Features

Common terms and phrases

Popular passages

Page x - As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we're doing right, what we could do better, what areas you'd like to see us publish in, and any other words of wisdom you're willing to pass our way.
Page x - I welcome your comments. You can email or write me directly to let me know what you did or didn't like about this book — as well as what we can do to make our books better. Please note that I cannot help you with technical problems related to the topic of this book. We do have a User Services group, however, where I will forward specific technical questions related to the book. When you...

References to this book

About the author (2004)

Ben Forta is Macromedia's Senior Technical Evangelist and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling ColdFusion Web Application Construction Kit and Advanced ColdFusion Development (both published by Que), Sams Teach Yourself Regular Expressions in 10 Minutes (in this same series), and also books on Flash, Java, WAP, Windows 2000, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs, and is a frequent lecturer and columnist on Internet and database technologies. Born in London, England, and educated in London, New York, and Los Angeles, Ben now lives in Oak Park, Michigan, with his wife Marcy and their seven children. Ben welcomes your email at, and invites you to visit his Web site at

Bibliographic information