Teach Yourself SQL in 24 Hours, 7th Edition

Thank you for your interest in Teach Yourself SQL in 24 Hours, 7th edition.  This book has been on the shelf since 1998, which indicates the importance of SQL in today's data-driven world.  This edition has been improved by adjusting the logical progression of learning, and provides an updated and interesting sample database that allow you to easily explore and understand all of the features that SQL has to offer, making data management easy.
Book Overview
tysqlbook.jpg

Teach Yourself SQL in 24 Hours, 7th Edition provides a step-by-step guide for learning the SQL language.  Although Oracle SQL is primarily used for exercises and examples, the focus is the SQL standard.  Therefore, the SQL education you acquire can be applied to any vendor relational database implementation that adheres to the design guidelines in the SQL standard.  This book takes you on a journey through understanding relational database fundamentals, basic database design and normalization, creation of database objects, manipulation of data, management of transactions, database queries, SQL functions, and advanced query options including subqueries and views.

Sample Database and SQL Scripts
Code on Laptop Computer
  • Entity relationship diagram for the BIRDS database

  • Scripts - create tables and insert data for the BIRDS database

  • Setup instructions

Current Readers
Digital Reading

If you already have a copy of Teach Yourself SQL in 24 Hours, 7th Edition, you can find the included sample database, scripts, and exercises on this site.  The intent of this site is to make it easier to enjoy the book while providing supplemental information and resources to the reader and the SQL community.

Get a copy of the book:

Amazon.com

Pearson Education

SQL Exercises
Socializing Online

Bonus data and exercises can be found here to practice using SQL and continue to expand upon your knowledge through a hands-on approach.