Skip to main content

MySQL course

Learn MySQL step by step: 243 lessons in 48 modules with worked examples, quizzes and interview questions. Free on JavaSchoolLab.

MySQL Topics

Database Fundamentals

MySQL Installation & Environment

SQL Basics

Data Types

Constraints

CRUD Operations

SELECT Queries

Operators

MySQL Functions

Aggregate Functions

Joins

Subqueries

Set Operations

Relationships & Database Design

Normalization

Keys

Indexes

Query Optimization

Transactions

Transaction Isolation Levels

Locks & Concurrency

Views

Stored Procedures

Stored Functions

Triggers

Cursors

Common Table Expressions

Window Functions

JSON in MySQL

Full-Text Search

Temporary Tables

User Management & Security

SQL Injection

Backup & Restore

Binary Logs

Replication

High Availability

Partitioning

InnoDB Internals

MVCC

MySQL Performance Tuning

MySQL Architecture

MySQL with Backend Applications

ORM & MySQL

Database Design for Real Projects

Advanced SQL Interview Problems

Production-Level MySQL