SQL Run
Database Programming
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):
- 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
Contact
chris@sqlrun.com
About the Author
Chris Fehily (fehily.com) is a statistician and author living in Carmel, California.