What is a Relational Database?

Data Types & Constraints

Schema Design & Table Relationships

Indexes & Query Performance

Transactions & ACID Properties

Take a MySQL-specific query using LIMIT, ||, and AUTO_INCREMENT — rewrite it to run on SQL Server

Write a query that uses window functions and verify it handles the MySQL 5.7 case

Create a users table schema that works unmodified on PostgreSQL, MySQL, and SQL Server

Write an upsert for a product catalog that works on both PostgreSQL and MySQL

Find and fix the NULL comparison bugs in a provided query set

What is the SQL standard and what version is the practical portability baseline?

Name three SQL features that look the same across databases but behave differently

How would you design a data access layer supporting PostgreSQL and MySQL?

What is the difference between REPLACE INTO and a true upsert in MySQL?

ISO/IEC 9075:2023 SQL Standard (official specification)

PostgreSQL Documentation: SQL Compatibility

MySQL 8.0 vs 5.7 Feature Comparison

SQL Server T-SQL vs ANSI SQL Differences

Use The Index, Luke — SQL Performance Explained