The SQL Guide

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

Become adept at SQL by starting with the basics and progressing through advanced SQL topics, such as finding and eliminating duplicates, comparing tables, updating from another table, creating crosstab queries, and much more!

Over 300 examples allow you to practice and apply to your own projects. A training database accompanies this book, along with instructions on completing the exercises in an easy-to-build online environment.

Many database courses used the previous version of this book. This book has been refined with these teaching experiences to have an even broader appeal for use in academia.

The book covers seven popular databases: SQL Server, Oracle, PostgreSQL, MySQL, DB2, Snowflake, and Hive. Examples cover SQL dialect variations. We also provide hints for Databricks, MariaDB, Netezza, SQL database in Microsoft Fabric, and Amazon Redshift.

The best book for beginners, yet also the best book for SQL practitioners looking to skill up on advanced techniques and build superfast queries. The book contains a lot of useful suggestions and pointers to avoid costly mistakes and save time!