MySQL Foundations

A clear path through the material

Build your understanding one focused lesson at a time, from core ideas to practical programming.

Enroll free to unlock the lessons.

1. 01
   MySQL Foundations and Queries0/47 topics · 0%

   • 1MySQL Tutorial
   • 2MySQL HOME
   • 3MySQL Intro
   • 4MySQL RDBMS
   • 5MySQL SQL
   • 6MySQL SELECT
   • 7MySQL SELECT DISTINCT
   • 8MySQL WHERE
   • 9MySQL ORDER BY
   • 10MySQL AND
   • 11MySQL OR
   • 12MySQL NOT

   Show all 47 topics (+35)
2. 02
   MySQL Database Design0/23 topics · 0%

   • 48MySQL Create DB
   • 49MySQL Drop DB
   • 50MySQL Create Table
   • 51MySQL Drop Table
   • 52MySQL Alter Table
   • 53MySQL Constraints
   • 54MySQL Not Null
   • 55MySQL Unique
   • 56MySQL Primary Key
   • 57MySQL Foreign Key
   • 58MySQL Check
   • 59MySQL Default

   Show all 23 topics (+11)
3. 03
   MySQL Advanced Queries and Operations0/18 topics · 0%

   • 71MySQL Common Table Expressions
   • 72MySQL Recursive CTEs
   • 73MySQL Window Functions
   • 74MySQL ROW_NUMBER()
   • 75MySQL RANK()
   • 76MySQL JSON Data
   • 77MySQL JSON Functions
   • 78MySQL Composite Indexes
   • 79MySQL EXPLAIN Plans
   • 80MySQL Query Optimization
   • 81MySQL Transaction Isolation
   • 82MySQL Locks

   Show all 18 topics (+6)
4. 04
   MySQL Projects and Practice0/9 topics · 0%

   • 89MySQL Certificate
   • 90MySQL Examples
   • 91MySQL Editor
   • 92MySQL Quiz
   • 93MySQL Exercises
   • 94MySQL Syllabus
   • 95MySQL Study Plan
   • 96MySQL CRUD Project
   • 97MySQL Reporting Project
5. 05
   MySQL References0/7 topics · 0%

   • 98MySQL Data Types
   • 99MySQL Functions
   • 100MySQL String Functions
   • 101MySQL Date Functions
   • 102MySQL Numeric Functions
   • 103MySQL Keywords
   • 104MySQL Quick Reference