MySQL Fundamentals: SQL, Joins and Transactions

Learn MySQL and SQL from tables and queries to joins, indexes and transactions. For beginners and developers who need to work with relational data.

Learn MySQL free, in English or Hindi, with lessons, shorts and interview questions.

Start course → · Interview questions

30 lessons · 12 modules · Free · Updated 1 Oct 2026

What you'll learn

  • Create databases and tables with suitable data types and keys.
  • Read and change data with SELECT, INSERT, UPDATE and DELETE.
  • Combine and summarize data with joins, GROUP BY, subqueries and window functions.
  • Protect integrity with constraints, transactions and least-privilege users.
  • Improve performance with indexes and EXPLAIN, and back up with mysqldump.

Syllabus

Module 1: Getting Started

  1. What is a Relational Database?
  2. Install & Connect
  3. Databases vs Tables

Module 2: Creating Structure

  1. Data Types
  2. CREATE TABLE
  3. Primary & Foreign Keys

Module 3: Basic Queries

  1. INSERT
  2. SELECT & WHERE
  3. ORDER BY & LIMIT

Module 4: Modifying Data

  1. UPDATE
  2. DELETE

Module 5: Joins

  1. INNER JOIN
  2. LEFT & RIGHT JOIN
  3. Self Joins & Joining 3+ Tables

Module 6: Aggregation

  1. Aggregate Functions
  2. GROUP BY
  3. HAVING vs WHERE

Module 7: Advanced Queries

  1. Subqueries
  2. UNION
  3. CASE Expressions
  4. Window Functions & CTEs (MySQL 8)

Module 8: Constraints & Integrity

  1. Constraints

Module 9: Performance

  1. Indexes
  2. EXPLAIN at a Glance

Module 10: Transactions

  1. Transactions

Module 11: Schema Design

  1. Normalization at a Glance
  2. Views

Module 12: Beyond Basics

  1. Stored Procedures at a Glance
  2. Backup & Restore
  3. Users, Privileges & Security

Related courses