SQL Books

 

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.

Click here to purchase the book on Amazon in the US

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 Book

Print editions of the book 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 Chinese edition is available in paperback from:

Amazon China
JD.com

The Korean edition is available in paperback from:

Gmarket

The Polish edition is available in paperback from:

Amazon
The Polish Bookstore (Poland, ships to US)

The Polish edition is available as an eBook from:

Apple iTunes Store (iBook)

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.

Click here to view supplemental materials for the book

Purchasing the Book

Used copies can be purchased from these online bookstores in the US:

Amazon
Barnes & Noble

Used copies can be purchased from these sites outside of the US:

Amazon China
Amazon Canada

Used copies of the Chinese edition can be purchased from:

Amazon
Amazon China

Used copies of the Polish edition can be purchased from:

Amazon
Amazon Italy
Amazon Spain
Amazon UK

Comments Off on SQL Books
%d bloggers like this: