SQL Tutorials

Learn how to use conversational analytics, BigQuery Studio's newest Gemini-powered feature, to build intelligent data agents with natural language queries.

Learn how to use the SQL RANK() function to assign rankings to rows, handle ties, and compare it with DENSE_RANK() and ROW_NUMBER().

Spin up a no-cost BigQuery environment, practice real-world SQL on public and private data, and build dashboards while staying within generous free-tier limits.

Learn how correlated subqueries do row-by-row comparisons in SQL. Discover use cases and how they differ from JOINs, window functions, or non-correlated queries.

A practical guide to relational algebra covering fundamental operators, join types, and derived operations - with SQL comparisons and examples that show how database engines process queries internally.

Master SQL data types in MySQL, PostgreSQL & SQL Server. Learn to choose the right numeric, text, and date formats to optimize performance and data integrity.

Understand how SQL ON DELETE RESTRICT protects data integrity. Learn how it blocks unsafe deletes and when to choose it over CASCADE or SET NULL rules.

Understand how SQL ON DELETE CASCADE automates dependent deletes in SQL, keeps tables consistent, and helps prevent accidental data loss.

Understand how to use SQL DELETE to remove records in a table. Learn the key syntax, safety workflows, and optimization techniques for handling large datasets.

Find out how foreign keys tie tables together, stop invalid data from slipping in, and help your database stay consistent.

Understand how CREATE TABLE shapes your database. Learn the key syntax, data types, constraints, and optimization techniques for building scalable schemas.

Learn how to group data by multiple columns in SQL to perform advanced aggregations. Explore use cases, performance tips, and practical examples.