++++

Data Engineering

May 2026×20 lessons

A beginner-friendly MySQL series covering database creation, querying, aggregation, joins, functions, transactions, schema design, performance, and permissions.

MySQL Basics

Driptanil DattaSoftware Developer

MySQL Basics

This module turns the bootcamp SQL scripts into a guided MySQL walkthrough. Each lesson keeps the original exercises, but the examples are cleaned up so they are easier to read, rerun, and reason about.

Lessons

1. Create Databases and Tables 2. School Database Practice 3. UPDATE, DELETE, NULL, and ALTER TABLE 4. DML Practice with customer_info 5. Customers Table Assignment 6. MySQL Constraints 7. SELECT Querying Deep Dive 8. Aggregate Functions 9. GROUP BY and HAVING 10. Joins 11. Subqueries and CTEs 12. Set Operations 13. MySQL Functions 14. Data Types Deep Dive 15. Transactions 16. 1Normalization and Schema Design 17. 1Views 18. 1Import and Export Basics 19. 1Query Performance Basics 20. 2Users and Permissions

Learning path

Start by creating databases and tables without constraints. Then practice DML operations like INSERT, UPDATE, and DELETE, add constraints, and move into querying patterns such as filters, aggregates, joins, subqueries, functions, transactions, schema design, performance, and permissions.

Data Engineering 1. Create Databases and Tables