EasyEnv
Engineering/Courses/Catalog/MySQL/Creating Databases and Tables
MySQL
IntermediateLesson 3 of 1330 min · hands-on

Creating Databases and Tables

Part of the MySQL course

Everything you did last lesson was look. You connected, browsed the system databases, and peeked inside a table that MySQL had already built for you. That is a fine way to get comfortable with the client, but it is not the same as having a place to put your own data.

Two ideas do all the work here. A database is a named container that groups related tables together, the way a folder groups related files. A table is the actual grid of rows and columns where data lives, one table per kind of thing you want to track: products, customers, orders. ...

Want to learn MySQL Creating Databases and Tables in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through Creating Databases and Tables hands-on with an AI tutor that knows your code.

Start this lessonCreating Databases and Tables

What you'll learn

  • CREATE DATABASE
  • Character sets and collation
  • CREATE TABLE
  • PRIMARY KEY
  • AUTO_INCREMENT
  • NOT NULL
  • DEFAULT
  • DROP TABLE
  • SHOW CREATE TABLE

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

Creating Databases and Tables - MySQL (English) | Engineering Courses