SQL Run
by Chris Fehily

Read This Book for Free

Start with the Introduction or Table of Contents.

About the Book

466 pages. This book teaches newcomers SQL, the language of databases, and includes examples and syntax for the most widely used database systems. In all its editions, this book has sold more than 150,000 copies and is popular with end users, students, data scientists, statisticians, epidemiologists, analysts, app developers, webmasters, and hobbyists. Thorough cross-referencing makes it a useful desktop reference for experienced SQL programmers. In SQL Run, the author has consolidated and updated his earlier SQL titles in a single book.

Covers Oracle Database, Microsoft SQL Server, IBM Db2 Database, MySQL, PostgreSQL, Microsoft Access, and Standard SQL (ISO/IEC)
Hundreds of examples of varied difficulty encourage you to experiment and explore
Download the sample database and SQL source code to follow along with the examples
Get a bonus chapter on advanced SQL when you buy the print or ebook edition
Organize your database in terms of the relational model
Master tables, columns, rows, and keys
Retrieve, filter, sort, and format data
Use functions and operators to transform and summarize data
Answer hard questions by using joins, subqueries, constraints, conditional logic, and metadata
Create, alter, and drop tables, indexes, and views
Insert, update, delete, and merge data
Execute transactions to maintain the integrity of your data
Avoid common pitfalls involving nulls
Troubleshoot and optimize queries

Buy the Book

Print Edition

Bonus chapter on advanced SQL (not online)
Buy from Amazon ($30 USD):
- amazon.com (USD)
- amazon.ca (CAD)
- amazon.co.uk (GBP)
- amazon.com.au (AUD)
- amazon.de (EUR)
- amazon.fr (EUR)
- amazon.es (EUR)
- amazon.it (EUR)
- amazon.nl (EUR)
- amazon.co.jp (JPY)
- amazon.in (INR)
- amazon.com.br (BRL)
- amazon.com.mx (MXN)
ISBN-13: 978-1937842499

Ebook Edition

Bonus chapter on advanced SQL (not online)
Direct download from Payhip.com ($20 USD via PayPal or credit card)
Includes EPUB and MOBI files

You can read EPUB books on most non-Amazon ebook readers and apps, including Apple Books, Google Play Books, Barnes & Noble Nook, Kobo, and Calibre; you can read MOBI books on Amazon Kindle e-readers and Fire tablets
No copy protection or other DRM (digital rights management) restrictions
Also available from Amazon.com, Apple Books, and Google Play (DRM imposed by vendor)
ISBN-13: 978-1937842482

Note: If you own the preceding edition of this book, SQL Database Programming (Fifth Edition), then it’s unnecessary to buy SQL Run, which contains only minor updates and corrections.

Contact

Email chris@sqlrun.com

About the Author