SQL Roadmaps¶

Premium SQL course launch¶

We just launched a new Premium SQL Course covering:

Core SQL keywords (SELECT, INSERT, UPDATE, DELETE)
Statements such as SUM, COUNT, AVG, MIN, MAX, GROUP BY, HAVING
Scalar, column, row, table, nested and correlated subqueries
String functions: CONCAT, LENGTH, SUBSTRING, REPLACE, UPPER, LOWER
Date/time functions: DATE_TIME, TIMESTAMP, DATEPART, DATEADD
Stored procedures & functions
Aggregate queries
Performance optimization techniques: query analysis, using indexes, optimizing joins, reducing subqueries, selective projection
Advanced SQL patterns

What are relational databases? Learn the basics and understand RDBMS benefits/limitations.
SQL vs. NoSQL: compare approaches, when to use each.
Basic SQL syntax
Data Definition Language (DDL): CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE
Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE
Clauses: FROM, WHERE, ORDER BY, GROUP BY, HAVING
Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK

JOIN types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN, CROSS JOIN
Subqueries (including correlated subqueries)
Conditional logic: CASE, NULLIF, COALESCE
Views: creating, modifying, dropping
Managing indexes, query optimization strategies