Book description
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.
Table of contents
- Title Page
- Copyright Page
- Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Lesson 1. Understanding SQL
- Lesson 2. Retrieving Data
- Lesson 3. Sorting Retrieved Data
- Lesson 4. Filtering Data
- Lesson 5. Advanced Data Filtering
- Lesson 6. Using Wildcard Filtering
- Lesson 7. Creating Calculated Fields
- Lesson 8. Using Data Manipulation Functions
- Lesson 9. Summarizing Data
- Lesson 10. Grouping Data
- Lesson 11. Working with Subqueries
- Lesson 12. Joining Tables
- Lesson 13. Creating Advanced Joins
- Lesson 14. Combining Queries
- Lesson 15. Inserting Data
- Lesson 16. Updating and Deleting Data
- Lesson 17. Creating and Manipulating Tables
- Lesson 18. Using Views
- Lesson 19. Working with Stored Procedures
- Lesson 20. Managing Transaction Processing
- Lesson 21. Using Cursors
- Lesson 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
- Index
Product information
- Title: Sams Teach Yourself SQL™ in 10 Minutes, Third Edition
- Author(s):
- Release date: March 2004
- Publisher(s): Sams
- ISBN: None
You might also like
book
Business Intelligence Guidebook
Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors’ tools lies …
audiobook
Technically Wrong
Buying groceries, tracking our health, finding a date: whatever we want to do, odds are that …
audiobook
Fall in Love with the Problem, Not the Solution
Unicorns-companies that reach a valuation of more than $1 billion-are rare. Uri Levine has built two. …
book
Foreign Exchange: A Practical Guide to the FX Markets
Praise for Foreign Exchange "Tim Weithers starts by telling the reader that foreign exchange is not …
