SQL

Compare RDBMS and NoSQL by data models, schemas, scalability, and transactions, then learn when each database is the right fit.

Explore MySQL and Oracle regular expressions, CUBE and GROUPING SETS, advanced window frames, and pivoting and unpivoting.

A practical guide to CTEs, recursive queries, subqueries, ROLLUP, and string aggregation in MySQL and Oracle, with SQL examples and notes.

A practical guide to advanced SQL for coding tests, covering string functions, JOINs, UNION, window functions, and date/time functions in MySQL and Oracle.

Solve the Programmers SQL exercise by comparing each E. coli colony's size with the maximum for its year.

A practical reference to SELECT, filtering, joins, aggregation, subqueries, and other SQL query syntax used in coding tests.