MySQL
MySQL is a relational database. Instead of storing information in scattered files, it stores it in organized tables made of rows and columns, similar to a very powerful spreadsheet that many people and programs can use at the same time. You do not need to memorize every command on day one. This course teaches one small idea at a time: what a database is, how to build tables, how to insert and retrieve data, how to filter and sort it, how tables connect to each other, and eventually how real applications are built on top of a database. The goal is not to type commands from memory. The goal is to understand what a query is actually asking the database to do, so you can read and write SQL with real understanding, not guesswork.
Topics
Start learning
Introduction to MySQL
Lesson 01
Installing MySQL
Lesson 02
MySQL Workbench & CLI
Lesson 03
Databases
Lesson 04
Tables
Lesson 05
Data Types
Lesson 06
CREATE DATABASE
Lesson 07
CREATE TABLE
Lesson 08
INSERT
Lesson 09
SELECT
Lesson 10
WHERE
Lesson 11
ORDER BY
Lesson 12
LIMIT
Lesson 13
DISTINCT
Lesson 14
Comparison Operators
Lesson 15
Logical Operators
Lesson 16
NULL & IS NULL
Lesson 17
UPDATE
Lesson 18
DELETE
Lesson 19
