The Language of SQL, 2nd Edition
Published by Addison-Wesley in August 2016, paperback and eBook, 224 pages.
Translations are available in Chinese, Korean and Polish.
An understanding of SQL is necessary for both the Information Systems professionals and other business analysts who need to create reports against data in relational databases. Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax. This approach is counterproductive, since this information is readily available in online references published by the major database vendors. For the beginning user or student, it’s more important to focus on general concepts and to offer clear explanations and examples of what the various statements can accomplish. THE LANGUAGE OF SQL allows users to learn SQL as they would learn a foreign language. SQL keywords are presented in a logical progression, from simple to more complex, allowing the reader to gain a sense of accomplishment as they learn new words. There is also an emphasis on statements and strategies pertaining to data retrieval. Readers are led through a sequence of chapters covering SQL syntax, from basic data retrieval to Boolean logic to table joins and subqueries. Final chapters discuss data updates, database design, and strategies for displaying data. Scripts will run in each of the 3 databases covered in the book: Microsoft SQL Server, MySQL, and Oracle. The book provides instructions on how to obtain and install free versions of those databases for testing.
Table of Contents
1. Relational Databases and SQL
2. Basic Data Retrieval
3. Calculated Fields and Aliases
4. Using Functions
5. Sorting Data
6. Selection Criteria
7. Boolean Logic
8. Conditional Logic
9. Summarizing Data
10. Subtotals and Crosstabs
11. Inner Joins
12. Outer Joins
13. Self Joins and Views
15. Set Logic
16. Stored Procedures and Parameters
17. Modifying Data
18. Maintaining Tables
19. Principles of Database Design
20. Strategies for Displaying Data
Appendix A: Getting Started with Microsoft SQL Server
Appendix B: Getting Started with MySQL
Appendix C: Getting Started with Oracle
Purchasing the Book
Print editions of the book can be purchased from these online bookstores in the US:
These sites offer digital editions of the book:
The book can also be purchased from these sites outside of the US:
Book Depository (UK)
Kinokuniya (United Arab Emirates)
The Chinese edition is available in paperback from:
The Korean edition is available in paperback from:
The Polish edition is available in paperback from:
The Polish edition is available as an eBook from:
The Language of SQL, 1st Edition
Published by Cengage Learning in June 2010, paperback and eBook, 239 pages.
Translations are available in Chinese and Polish.
This book is out of print. Used copies may be obtained from sites shown below.
Purchasing the Book
Used copies can be purchased from these online bookstores in the US:
Used copies can be purchased from these sites outside of the US:
Used copies of the Chinese edition can be purchased from:
Used copies of the Polish edition can be purchased from: