Loading Depth Study
Preparing your workspace
MySQL is a relational database management system that stores structured data in tables and uses SQL to work with that data.
MySQL stores information in tables made of rows and columns. A row represents one record and a column represents a specific property of that record. Relational databases are useful when data has clear relationships, such as users, courses, enrollments, and payments. MySQL uses SQL, or Structured Query Language, to create, read, update, and delete data.
A learning platform can have users, courses, lessons, and enrollments stored in separate related tables.
CREATE DATABASE learning_portal; USE learning_portal; CREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(100), email VARCHAR(150) );
A learning_portal database is created with a students table containing an ID, name, and email.