Learn MySQL

MySQL Topics

Click on a topic to expand and learn in detail.

• 1. Introduction to MySQL

-- MySQL is a relational database management system (RDBMS)
CREATE DATABASE SchoolDB;
USE SchoolDB;
      

• 2. Creating Tables

CREATE TABLE Students(
    ID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(50),
    Age INT
);
      

• 3. Data Manipulation

INSERT INTO Students(Name, Age) VALUES('Alice', 25);
UPDATE Students SET Age=26 WHERE Name='Alice';
DELETE FROM Students WHERE Age < 18;
SELECT * FROM Students;
      

• 4. Advanced MySQL
• JOINs (INNER, LEFT, RIGHT, FULL)
• Stored Procedures & Functions
• Triggers & Views
• Indexes & Constraints
• User Management & Privileges