The SQL Guide: From Fundamentals to Advanced - Softcover

Hovi, Ari

Softcover

ISBN 10: 1634626702 ISBN 13: 9781634626705

Publisher: Technics Publications, 2025

Synopsis

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!

Edition details

• Publisher: Technics Publications
• Publication date: 2025
• Language: English
• ISBN 10: 1634626702
• ISBN 13: 9781634626705
• Binding: Paperback
• Number of pages: 324