Basic SELECT Statements
Learn how to retrieve data from a database using the SELECT statement, including the use of FROM, WHERE, and DISTINCT.
Restricting and Sorting Data
Apply conditions with WHERE, sort results using ORDER BY, and limit output with precision for cleaner datasets.
Single-Row Functions
Use SQL’s built-in functions—UPPER, LOWER, ROUND, SYSDATE, TO_CHAR, and others—to manipulate individual data rows.
Joins
Combine data from multiple tables using various types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and self-joins.
Group Functions
Perform advanced data analysis with aggregation functions like SUM, AVG, COUNT, MIN, and MAX, along with GROUP BY and HAVING.
Subqueries
Write nested queries to handle complex data retrieval using scalar, correlated, and multi-row subqueries.
Manipulating Data
Learn how to modify database content using INSERT, UPDATE, DELETE, and control transactions with COMMIT, ROLLBACK, and SAVEPOINT.