Learn MySQL

Learn the fundamentals of retrieving data from MySQL tables using SELECT, choosing columns, and aliasing results.

Master the WHERE clause to filter rows using comparison operators, LIKE, IN, BETWEEN, and NULL checks.

Sort query results and control the number of rows returned with ORDER BY, LIMIT, and OFFSET.

Learn how to add new rows to tables using INSERT INTO, multi-row inserts, and INSERT ... SELECT.

Modify existing data with UPDATE and remove rows with DELETE, including safe practices and common pitfalls.

Define table structures with CREATE TABLE, choose data types, set constraints, and configure primary keys.

Combine data from multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN.

Aggregate data into groups with GROUP BY and filter aggregated results using HAVING.

Use nested queries in SELECT, FROM, and WHERE clauses to solve complex data retrieval problems.

Manipulate text data with CONCAT, SUBSTRING, REPLACE, TRIM, UPPER, LOWER, and more string functions.

Handle date and time values with NOW(), DATE_FORMAT(), DATEDIFF(), DATE_ADD(), and temporal arithmetic.

Speed up queries with indexes, understand B-tree vs. full-text indexes, and learn when to index.

Simplify complex queries by creating reusable virtual tables with CREATE VIEW and managing them.

Write reusable server-side logic with stored procedures, parameters, variables, and control flow.

Automate actions on INSERT, UPDATE, and DELETE events with BEFORE and AFTER triggers.

Perform advanced analytics with ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, and aggregate window functions.

Write cleaner queries with WITH clauses, recursive CTEs, and hierarchical data traversal.

Store and query JSON data using JSON_EXTRACT, JSON_SET, JSON_ARRAY, and virtual generated columns.

Analyze query performance with EXPLAIN, optimize slow queries, and understand the MySQL query planner.

Manage large tables with RANGE, LIST, HASH, and KEY partitioning strategies for better performance.