EthicsComputerCourses
Join training
  1. Tutorials
  2. SQL & MySQL Tutorial

SQL & MySQL Tutorial

Query, design and manage databases with SQL, using MySQL 8.4 and 9.7 LTS.

41 free lessons Beginner to Intermediate Covers MySQL 8.4 & 9.7 LTS (examples also run on SQLite in the browser)

Start the first lesson

Getting Started

  1. 1SQL Introduction
  2. 2Install MySQL & Run Queries
  3. 3The Practice Database

Querying Data

  1. 4SELECT
  2. 5SELECT DISTINCT
  3. 6WHERE
  4. 7AND, OR & NOT
  5. 8ORDER BY
  6. 9LIMIT & OFFSET
  7. 10NULL Values
  8. 11LIKE & Wildcards
  9. 12IN & BETWEEN
  10. 13Aliases

Summarising Data

  1. 14Aggregate Functions
  2. 15GROUP BY
  3. 16HAVING
  4. 17CASE Expressions

Joins & Subqueries

  1. 18INNER JOIN
  2. 19LEFT & RIGHT JOIN
  3. 20Self & Cross Joins
  4. 21UNION
  5. 22Subqueries
  6. 23EXISTS, ANY & ALL

Changing Data

  1. 24INSERT
  2. 25UPDATE
  3. 26DELETE
  4. 27Transactions

Database Design

  1. 28CREATE DATABASE & TABLE
  2. 29MySQL Data Types
  3. 30Constraints & Keys
  4. 31ALTER, DROP & TRUNCATE
  5. 32Indexes & EXPLAIN
  6. 33Views
  7. 34Normalisation & Table Design

Advanced SQL

  1. 35String, Number & Date Functions
  2. 36Window Functions
  3. 37Common Table Expressions (WITH)
  4. 38JSON in MySQL
  5. 39Stored Procedures & Triggers (coming soon)
  6. 40Users, Privileges & Backups
  7. 41What's New in MySQL 8.4 & 9.7 LTS
  8. 42Project: Sales Report Queries

Learn SQL with a mentor

Free lessons get you started. Our PHP & MySQL Development training adds real projects and code reviews from working developers.

  • Project-based learning
  • Mentor code reviews
  • Free counselling call
Get course details +91 90532 10052