MySQL Basics
Introduction to Databases and SQL
Last Updated: December 2, 2025This chapter establishes the core terminology and concepts required to understand how MySQL works as a Relational Database Management System...
Defining Database Structure (DDL)
Last Updated: December 2, 2025Data Definition Language (DDL) is the subset of SQL commands used to define and manage the structure (schema) of the...
Modifying Structure (DDL)
Last Updated: December 2, 2025The ALTER TABLE command is used to add, modify, or remove columns and constraints from an existing table. This is...
Data Insertion and Retrieval
Last Updated: December 2, 2025Data Manipulation Language (DML) commands are the most frequently used set of SQL statements. They are responsible for managing the...
Filtering Data (The WHERE Clause)
Last Updated: December 2, 2025The WHERE clause is used in SQL to filter the records returned by a SELECT statement, or those affected by...
Updating and Deleting Data
Last Updated: December 2, 2025The UPDATE and DELETE statements are responsible for maintaining the accuracy and current status of the data within the database....
Sorting and Limiting Results
Last Updated: December 2, 2025While the WHERE clause filters which rows are retrieved, the ORDER BY and LIMIT clauses determine how those retrieved rows...