Sams Teach Yourself SQL in 10 Minutes

Front Cover
Sams Publishing, 2004 - Computers - 242 pages
24 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. Fortas 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
5
4 stars
14
3 stars
3
2 stars
1
1 star
1

Overall, this is a very good intro to SQL concepts. - Goodreads
Weak - even for a broad overview. - Goodreads
It is a great reference. - Goodreads

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  - Phillip Thurlby - Goodreads

First of all, it's ten minutes per chapter/lesson, not for the whole book. Unlike others that claim you can be an expert in no time, this book has carefully calculated itself to deliver bitesize ... Read full review

Selected pages

Contents

Understanding SQL
5
Retrieving Data
13
Sorting Retrieved Data
19
Filtering Data
26
Advanced Data Filtering
33
Using Wildcard Filtering
40
Creating Calculated Fields
48
Using Data Manipulation Functions
57
Creating Advanced Joins
101
Combining Queries
111
Inserting Data
118
Updating and Deleting Data
127
Creating and Manipulating Tables
133
Using Views
143
Working with Stored Procedures
153
Managing Transaction Processing
161

Summarizing Data
66
Grouping Data
75
Working with Subqueries
84
Joining Tables
91
Using Cursors
168
Understanding Advanced SQL Features
174
Copyright

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 ben@forta.com, and invites you to visit his Web site at http://www.forta.com.

Bibliographic information