Skip to main content
Database Management Beginner

MySQL Basics

A COMPLETE beginner-to-advanced curriculum covering relational database fundamentals, SQL queries, database design, CRUD operations, joins, indexing, and optimization.

30 chapters 2h 56m 4.7 (133)
Start Learning

What you'll learn

  • Introduction to Databases and MySQL
  • Installing MySQL and phpMyAdmin
  • Understanding Relational Databases
  • Creating Databases and Tables
  • MySQL Data Types Explained
  • INSERT, UPDATE, and DELETE Queries
  • SELECT Queries and Filtering Data
  • Sorting, Limiting, and Searching Data

Course content

30 chapters Β· 2h 56m
  1. 1 Introduction to Databases and MySQL 6 min
  2. 2 Installing MySQL and phpMyAdmin 6 min
  3. 3 Understanding Relational Databases 6 min
  4. 4 Creating Databases and Tables 6 min
  5. 5 MySQL Data Types Explained 7 min
  6. 6 INSERT, UPDATE, and DELETE Queries 6 min
  7. 7 SELECT Queries and Filtering Data 5 min
  8. 8 Sorting, Limiting, and Searching Data 6 min
  9. 9 SQL Operators and Conditions 5 min
  10. 10 Aggregate Functions in MySQL 6 min
  11. 11 GROUP BY and HAVING Clauses 6 min
  12. 12 Primary Keys and Auto Increment 6 min
  13. 13 Foreign Keys and Relationships 6 min
  14. 14 INNER JOIN, LEFT JOIN, and RIGHT JOIN 5 min
  15. 15 Advanced JOIN Queries 6 min
  16. 16 Subqueries and Nested Queries 6 min
  17. 17 Views in MySQL 7 min
  18. 18 Indexing and Query Optimization 6 min
  19. 19 Constraints and Data Integrity 5 min
  20. 20 Transactions and ACID Properties 6 min
  21. 21 Stored Procedures and Functions 6 min
  22. 22 Triggers in MySQL 6 min
  23. 23 Importing and Exporting Databases 5 min
  24. 24 Database Backup and Recovery 6 min
  25. 25 MySQL Security Best Practices 6 min
  26. 26 Connecting MySQL with PHP 6 min
  27. 27 CRUD Application with PHP and MySQL 5 min
  28. 28 NoSQL vs SQL Databases 6 min
  29. 29 Database Design Project (E-Commerce) 7 min
  30. 30 Course Summary and Next Steps 5 min