EasyEnv
MySQL
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 MySQL

What 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
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

What is MySQL - MySQL (English) | Engineering Courses