SQL Queries for Mere Mortals 2nd Edition  (English, Paperback, Hernandez Michael J.)

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users.

The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

Salient Features

The best book available to help new users learn the foundations of SQL Queries, the building block of all modern database systems

• One of the few books that focuses on generic SQL, and not one particular vendor's version of SQL
• Updated with hundreds of new examples compliant with the latest databases, including MySQL
• Written in a clear, jargon-free, easy-to-understand style
• Contains a foreword from Keith Hare, the Convenor of the International SQL Standards Committee

Table of Contents

Part I: Relational Databases and SQL 1. What Is Relational? 2. Ensuring Your Database Structure Is Sound 3. A Concise History of SQL Part II: SQL Basics 4. Creating a Simple Query 5. Getting More Than Simple Columns 6. Filtering Your Data Part III: Working with Multiple Tables 7. Thinking in Sets 8. INNER JOINs 9. OUTER JOINs 10. UNIONs 11. Subqueries Part IV: Summarizing and Grouping Data 12. Simple Totals 13. Grouping Data 14. Filtering Grouped Data Part V: Modifying Sets of Data 15. Updating Sets of Data 16. Inserting Sets of Data 17. Deleting Sets of Data In Closing APPENDICES Appendix A: SQL Standard Diagrams Appendix B: Schema for the Sample Databases Appendix C: Date and Time Functions Appendix D: Suggested Reading