IntermediateLesson 1 of 1320 min 路 hands-on
What is MySQL
Part of the MySQL course
Welcome. If you have never used a database before, you are in the right place. This lesson has no queries to write. We just want to know what MySQL is, where it came from, and when to reach for it. Take your time.
MySQL is one of the most widely deployed relational databases on the planet. A database is a program whose job is to store, find, and update information for you. "Relational" means the data is stored in tables that look a lot like spreadsheets (rows and columns), and tables can refer to each other by ID. We will explore that shape in lesson 03. ...
Want to learn MySQL What is MySQL in a real environment?
Click below, get a fresh Linux box with MySQL ready to go, and work through What is MySQL hands-on with an AI tutor that knows your code.
Start this lessonWhat is MySQLWhat you'll learn
- Relational database
- History and Oracle ownership
- MariaDB fork
- MySQL vs Postgres trade-offs
- InnoDB default engine
Read this lesson in your language
All lessons in this course
13 lessons- 1What is MySQL20 min
- 2The mysql CLI and First Commands25 min
- 3Creating Databases and Tables30 min
- 4Data Types30 min
- 5SELECT and WHERE30 min
- 6Joins35 min
- 7Aggregates and Grouping30 min
- 8Indexes30 min
- 9Transactions and Storage Engines35 min
- 10Stored Procedures and Triggers35 min
- 11EXPLAIN and Query Tuning35 min
- 12mysqldump and Restore25 min
- 13Capstone: Design an Ecommerce Schema50 min
Explore other courses
Python
19 lessons 路 9.3h
Go
20 lessons 路 12.3h
React
17 lessons 路 10.2h
Linux
17 lessons 路 8.5h
Docker
13 lessons 路 6.6h
Git
13 lessons 路 5.9h
Kubernetes
14 lessons 路 8h
Ansible
12 lessons 路 6.1h
Bash
12 lessons 路 5.7h
Helm
10 lessons 路 5.4h
GitLab CI
11 lessons 路 5.8h
Jenkins
11 lessons 路 5.3h
PostgreSQL
14 lessons 路 7.6h
Web
14 lessons 路 5.9h
TypeScript
18 lessons 路 7.7h
Vibe Coding
12 lessons 路 5.8h
Prompt Engineering
11 lessons 路 6.2h
Vibe Coding: Fundamentals
12 lessons 路 4.5h
Vibe Coding: Prototype to Production
12 lessons 路 5.5h
Vibe Coding: Multi-Agent Engineering
12 lessons 路 5.3h
Vibe Coding: Advanced Engineering
12 lessons 路 7.3h