What to Learn Next & Final Checklist

Where to go after this course, and a checklist to confirm you have mastered every topic.

What to Learn Next

After completing this course, deepen your skills in the direction that matches your career:

Topics to learn next Backend / software engineering ORMs (JPA/Hibernate, Entity Framework, SQLAlchemy, Prisma) and their generated SQL; connection pooling; database migrations (Flyway, Liquibase, Alembic); caching (Redis); API pagination patterns; testing with containers (Testcontainers) Data engineering

Data warehousing (star/snowflake schemas, Kimball), cloud warehouses (Snowflake, BigQuery, Redshift, Databricks SQL), dbt, ELT pipelines, orchestration (Airflow), CDC (Debezium), partitioning and columnar storage (Parquet), Spark SQL Data analysis / BI

Advanced analytics SQL (cohorts, funnels, attribution), statistics functions, BI tools (Power BI, Tableau, Looker, Metabase), semantic layers Database administration

Installation and configuration, replication and high availability, backup automation, monitoring, vacuum/statistics maintenance, partitioning, upgrades, security hardening, cloud managed databases (RDS, Azure SQL, Cloud SQL) Performance engineering

Deep execution plan analysis, statistics internals, index internals, query hints and plan guides, workload analysis (pg_stat_statements, Query Store, AWR) Distributed & NewSQL

Sharding, CockroachDB, YugabyteDB, Google Spanner, TiDB, distributed transactions, consistency models NoSQL & specialized databases

MongoDB, Redis, Cassandra, Neo4j (graph, Cypher, SQL/PGQ), time-series databases (TimescaleDB, InfluxDB) — especially relevant for vehicle telemetry and CAN logs Automotive / embedded data

SQLite in embedded and infotainment systems, time-series storage of CAN/LIN/Ethernet logs, ASAM MDF/ODS data, diagnostic data (ODX), test management databases, traceability between requirements, software versions, and test results

Vendor certifications (Oracle Database SQL, Microsoft Azure Data/SQL, PostgreSQL associate/professional programs, Snowflake SnowPro)

Recommended habits: read the official documentation of your primary DBMS (the PostgreSQL manual is excellent), follow its release notes, and keep solving problems on practice platforms.

Final SQL Course Checklist

Tick each item only when you can do it without looking at notes.

[ ] Explain database, DBMS, RDBMS, and the relational model [ ] Define super, candidate, primary, alternate, composite, foreign, natural, and surrogate keys

[ ] Explain what NULL means and how three-valued logic works

[ ] Name SQL command categories (DDL, DML, DQL, DCL, TCL) with examples [ ] Explain DELETE vs TRUNCATE vs DROP

[ ] Identify dialect differences between MySQL, PostgreSQL, SQL Server, Oracle, and SQLite Schema and Data

[ ] Create databases and tables with appropriate data types [ ] Choose DECIMAL for money, proper date/time types, and correct string types

[ ] Add, modify, rename, and drop columns and constraints [ ] Use PRIMARY KEY, FOREIGN KEY (with ON DELETE actions), UNIQUE, NOT NULL, CHECK, DEFAULT

[ ] Insert single rows, multiple rows, and INSERT ... SELECT

[ ] Update and delete safely inside transactions [ ] Write an upsert in your DBMS

[ ] Write SELECT with aliases, expressions, DISTINCT, and literals

[ ] Explain the logical order of query processing [ ] Filter with comparison, logical, BETWEEN, IN, LIKE, IS NULL operators

[ ] Sort with multiple keys, control NULL ordering, and paginate (LIMIT/TOP/FETCH, keyset)

[ ] Use string, numeric, date, NULL functions, and CASE [ ] Use aggregates and explain COUNT(*) vs COUNT(col) vs COUNT(DISTINCT col)

[ ] Group with GROUP BY, filter with HAVING, and explain WHERE vs HAVING

[ ] Use conditional aggregation and ROLLUP [ ] Write and predict INNER, LEFT, RIGHT, FULL, CROSS, and SELF joins

[ ] Place outer-join filters correctly (ON vs WHERE) [ ] Detect and fix join fan-out

[ ] Write scalar, multi-row, multi-column, correlated, and nested subqueries

[ ] Explain EXISTS vs IN and the NOT IN NULL trap [ ] Use UNION, UNION ALL, INTERSECT, EXCEPT/MINUS

[ ] Write multi-step CTEs and recursive CTEs for hierarchies and series

[ ] Use ROW_NUMBER, RANK, DENSE_RANK, NTILE [ ] Use LAG, LEAD, FIRST_VALUE, LAST_VALUE (with correct frames)

[ ] Compute running totals, moving averages, and percent of total

[ ] Solve Top-N per group, latest record per group, and deduplication

[ ] Build monthly/weekly/yearly reports and MoM growth [ ] Pivot and unpivot data

[ ] Solve gaps-and-islands and sessionization problems [ ] Handle dates, intervals, aging, and time zones correctly Database Objects and Programming

[ ] Create, replace, and drop views; explain materialized views

[ ] Write stored procedures with parameters, variables, conditions, loops, and error handling

[ ] Write scalar and table-valued functions; compare procedures and functions

[ ] Write BEFORE/AFTER triggers, including an audit log; explain trigger drawbacks

[ ] Use temporary tables and compare them with CTEs [ ] Use sequences, identity columns, and UUIDs; explain ID gaps [ ] Explain how B-tree indexes work

[ ] Create single, composite, unique, covering, partial, and expression indexes

[ ] Explain clustered vs non-clustered indexes, selectivity, and cardinality

[ ] Read an execution plan (EXPLAIN / EXPLAIN ANALYZE) [ ] Identify scans, seeks, and join algorithms

[ ] Rewrite non-sargable predicates and follow a slow-query troubleshooting process Transactions and Concurrency [ ] Explain ACID with a banking example

[ ] Use BEGIN, COMMIT, ROLLBACK, SAVEPOINT [ ] Explain the four isolation levels and dirty/non-repeatable/phantom reads, lost updates, write skew

[ ] Explain MVCC and your DBMS's default isolation level [ ] Prevent lost updates and deadlocks

[ ] Normalize a table to 1NF, 2NF, 3NF, and BCNF; explain 4NF and 5NF

[ ] Explain update, insert, and delete anomalies and when to denormalize

[ ] Implement one-to-one, one-to-many, and many-to-many relationships

[ ] Draw ER diagrams with cardinality and optionality; identify weak and associative entities

[ ] Apply naming conventions and integrity rules to a new schema Security and Operations

[ ] Create users and roles; GRANT and REVOKE privileges following least privilege

[ ] Explain SQL injection and write parameterized queries in at least one language

[ ] Explain full, incremental, differential, and log backups; PITR; RPO and RTO

[ ] Debug common SQL errors systematically Practice and Portfolio

[ ] Solved all 51 practice problems in Module 43 with matching outputs

[ ] Completed the automotive examples in Module 36 [ ] Built at least two projects from Module 44 with schema, seed data, queries, and README

[ ] Scored 80% or higher on the final assessment (Module 50)

[ ] Can answer the beginner, intermediate, and advanced interview questions in Module 42 aloud

When every box is ticked, you have completed the SQL — Complete Course.