sql-useful-resources

SQL - Useful Resources

The following resources contain additional, high-quality information on SQL. Use them to deepen your knowledge and practice your skills.

The official documentation is always the most accurate source of truth for any database system.

PostgreSQL Documentation: Comprehensive and highly regarded for its clarity.
MySQL Reference Manual: The definitive guide for MySQL features and syntax.
Microsoft SQL Server Docs: Extensive documentation covering T-SQL, performance tuning, and administration.
SQLite Documentation: Excellent resource for the world’s most widely deployed database engine.

Hands-on practice is the best way to learn.

DB Fiddle: An online tool that lets you run queries against various database systems (PostgreSQL, MySQL, SQLite).
SQL Fiddle: Another popular online SQL playground for testing and sharing queries.
SQLBolt: A series of interactive lessons and exercises to learn SQL basics.
LeetCode / HackerRank: Platforms with a large collection of SQL problems to challenge your skills, ranging from easy to very difficult.

The Art of SQL by Stephane Faroult: A classic book on writing elegant and high-performance SQL.
SQL Antipatterns by Bill Karwin: An essential read that teaches you how to recognize and avoid common database design mistakes.
Use The Index, Luke!: A free online book dedicated to explaining SQL indexing and performance.
Postgres Weekly / DB Weekly: Newsletters to stay up-to-date with the latest developments and articles in the database world.

SQL is a foundational skill for many tech roles. Depending on your interests, you can specialize in areas like:

Backend Development: Using SQL to power applications and APIs.
Data Analysis: Writing complex queries to extract insights from data.
Data Engineering: Building and maintaining data pipelines and warehouses.
Database Administration (DBA): Focusing on performance, reliability, and security of database systems.