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.

Start course →

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