Skip to content
Contact →

MySQL Basics

Updated
17 Sept 2026
1 min read
2 sections
Page 2 of 22
Data Engineering

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

  • Create Databases and Tables — /blog/data-engineering/my-sql-basics/1-create-databases-and-tables
  • School Database Practice — /blog/data-engineering/my-sql-basics/2-school-database-practice
  • UPDATE, DELETE, NULL, and ALTER TABLE — /blog/data-engineering/my-sql-basics/3-update-delete-null-and-alter-table
  • DML Practice with customer_info — /blog/data-engineering/my-sql-basics/4-dml-practice-customer-info
  • Customers Table Assignment — /blog/data-engineering/my-sql-basics/5-dml-assignment-customers-table
  • MySQL Constraints — /blog/data-engineering/my-sql-basics/6-mysql-constraints
  • SELECT Querying Deep Dive — /blog/data-engineering/my-sql-basics/7-select-querying-deep-dive
  • Aggregate Functions — /blog/data-engineering/my-sql-basics/8-aggregate-functions
  • GROUP BY and HAVING — /blog/data-engineering/my-sql-basics/9-group-by-and-having
  • Joins — /blog/data-engineering/my-sql-basics/10-joins
  • Subqueries and CTEs — /blog/data-engineering/my-sql-basics/11-subqueries-and-ctes
  • Set Operations — /blog/data-engineering/my-sql-basics/12-set-operations
  • MySQL Functions — /blog/data-engineering/my-sql-basics/13-mysql-functions
  • Data Types Deep Dive — /blog/data-engineering/my-sql-basics/14-data-types-deep-dive
  • Transactions — /blog/data-engineering/my-sql-basics/15-transactions
  • 1Normalization and Schema Design — /blog/data-engineering/my-sql-basics/16-normalization-and-schema-design
  • 1Views — /blog/data-engineering/my-sql-basics/17-views
  • 1Import and Export Basics — /blog/data-engineering/my-sql-basics/18-import-export-basics
  • 1Query Performance Basics — /blog/data-engineering/my-sql-basics/19-query-performance-basics
  • 2Users and Permissions — /blog/data-engineering/my-sql-basics/20-users-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.

In this section

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