Rockoff Larry. The Language of SQL

2nd Edition. — Addison-Wesley, 2017. — 242 p. — ISBN 978-0-13-465825-4.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.Relational Databases and SQL
Basic Data Retrieval
Calculated Fields and Aliases
Using Functions
Sorting Data
Selection Criteria
Boolean Logic
Conditional Logic
Summarizing Data
Subtotals and Crosstabs
Inner Joins
Outer Joins
Self Joins and Views
Subqueries
Set Logic
Stored Procedures and Parameters
Modifying Data
Maintaining Tables
Principles of Database Design
Strategies for Displaying Data
Appendix A: Getting Started with Microsoft SQL Server
Appendix B: Getting Started with MySQL
Appendix C: Getting Started with Oracle