The Language of SQL

 

The Language of SQL, 2nd Edition

Published by Addison-Wesley in August 2016, paperback and eBook, 224 pages. ISBN 978-0-13-465825-4.

Click here to purchase the book on Amazon in the US

Click here to purchase the book on other US and non-US sites

Click here to view the publisher’s description of the book

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
14. Subqueries
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 Second Edition

“The Language of SQL” can be purchased from these online bookstores in the US:

Amazon
Barnes & Noble
Books-A-Million
IndieBound
InformIT
Target
Walmart

These sites offer digital editions of the book:

Amazon (Kindle)
Barnes and Noble (Nook Book)
Books-A-Million (ePub)
Google Play
InformIT (ePub, Mobi and PDF)
Safari Books Online (ePub)

The book can also be purchased from these sites outside of the US:

Amazon Canada
Amazon France
Amazon Germany
Amazon India
Amazon Italy
Amazon Japan
Amazon Spain
Amazon UK
Book Depository (UK)
Booktopia (Australia)
Bookworld (Australia)
Indigo (Canada)
Kinokuniya (United Arab Emirates)

The second edition has been translated into Chinese. The Chinese edition is available in paperback from:

Amazon China
JD.com

The second edition has also been translated into Korean. The Korean edition is available in paperback from:

Gmarket

The second edition has also been translated into Polish. The Polish edition is available in paperback from:

Amazon
The Polish Bookstore (Poland, ships to US)

Information on the First Edition

The first edition of “The Language of SQL” was published by Cengage Learning in June 2010. Aside from a few international sites and translations in Polish and Chinese, this edition is now out of print.

Click here to view supplemental materials for the first edition of book

The first edition has been translated into Chinese. The Chinese edition is available in paperback from:

Amazon
Amazon China

The first edition also been translated into Polish. The Polish edition is available in paperback and as an eBook from:

Amazon
Amazon Italy
Amazon Spain
Amazon UK
Apple iTunes Store
The Polish Bookstore (Poland, ships to US)

Print copies of the first edition are still available on these international sites:

Amazon China
Amazon India

Advertisements
Comments Off on The Language of SQL
%d bloggers like this: