SELECT Queries
Basic and advanced SELECT.
SQL Joins
INNER, LEFT, RIGHT, FULL joins.
Subqueries
Nested and correlated subqueries.
Aggregation
GROUP BY, HAVING, window functions.
Indexes
B-tree, composite, and covering indexes.
SQL Transactions
ACID, isolation levels.
Database Normalization
1NF through 3NF and BCNF.
EXPLAIN Plans
Query execution analysis.
Stored Procedures
Procedures and functions in SQL.
PostgreSQL with Java
PostgreSQL-specific features.
MySQL with Java
MySQL driver and features.