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: 0672325675
You might also like
book
Just Java™ 2
The #1 introduction to J2SE 1.5 and enterprise/server-side development! An international bestseller for eight years, is …
book
FileMaker Pro 8: The Missing Manual
Used by millions worldwide, FileMaker Pro is an award-winning database program for managing people, projects, images, …
book
Special Edition Using TCP/IP, Second Edition
Special Edition Using TCP/IP, 2E is the practical guide to applications of TCP/IP, including utilities for …
book
MySQL® Crash Course
MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses …