Sams teach yourself SQL in 10 minutes

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...

Full description

Bibliographic Details
Main Author: Forta, Ben
Format: eBook
Language:English
Published: Indianapolis, Ind. Sams 2004
Edition:3rd ed
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
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
  • A. Sample table scripts
  • B. Working with popular applications
  • C. SQL Statement Syntax
  • D. Using SQL Datatypes
  • E. SQL Reserved Words