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!
By:
Ari Hovi Imprint: Technics Publications Dimensions:
Height: 235mm,
Width: 191mm,
Spine: 17mm
Weight: 562g ISBN:9781634626705 ISBN 10: 1634626702 Pages: 326 Publication Date:07 April 2025 Audience:
General/trade
,
ELT Advanced
Format:Paperback Publisher's Status: Active