0%

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

  1. Title Page
  2. Copyright Page
  3. Contents
  4. About the Author
  5. Acknowledgments
  6. We Want to Hear from You!
  7. Introduction
  8. Lesson 1. Understanding SQL
  9. Lesson 2. Retrieving Data
  10. Lesson 3. Sorting Retrieved Data
  11. Lesson 4. Filtering Data
  12. Lesson 5. Advanced Data Filtering
  13. Lesson 6. Using Wildcard Filtering
  14. Lesson 7. Creating Calculated Fields
  15. Lesson 8. Using Data Manipulation Functions
  16. Lesson 9. Summarizing Data
  17. Lesson 10. Grouping Data
  18. Lesson 11. Working with Subqueries
  19. Lesson 12. Joining Tables
  20. Lesson 13. Creating Advanced Joins
  21. Lesson 14. Combining Queries
  22. Lesson 15. Inserting Data
  23. Lesson 16. Updating and Deleting Data
  24. Lesson 17. Creating and Manipulating Tables
  25. Lesson 18. Using Views
  26. Lesson 19. Working with Stored Procedures
  27. Lesson 20. Managing Transaction Processing
  28. Lesson 21. Using Cursors
  29. Lesson 22. Understanding Advanced SQL Features
  30. Appendix A. Sample Table Scripts
  31. Appendix B. Working in Popular Applications
  32. Appendix C. SQL Statement Syntax
  33. Appendix D. Using SQL Datatypes
  34. Appendix E. SQL Reserved Words
  35. Index
18.118.163.250