Content
Introduction
Installation guide
A glance at the Workbench
Data Normalization
SQL and RDBMS
Normalization and SQL
DDL = Data Definition Language
DDL review, CREATE / DROP DATABASE
CREATE DATABASE statement
CREATE / DROP TABLE intro
CREATE / DROP TABLE quiz
Integers
Floating-point numbers, exact precision and BIT
Numbers quiz
UTF8MB4 Character Set, Collation Explained
VARCHAR, TEXT, CHAR
BLOB, ENUM, SET
String quiz
Date and Time
DEFAULT values
Data Types
Indexes, Keys, ALTER
Binary Search, B-trees and Keys
Primary and Unique keys. NOT NULL
Keys quiz
Foreign keys
Foreign Key Quiz
ALTER statement
How to construct any DDL statement?
DDL Quiz
Workbench and EER (Enhanced Entity-Relationship) diagrams
EER diagram with workbench
Export DDL from EER
Import and Backup
Workbench and EER quiz
Equator
DML = Data Manipulation Language
Intro to DML
Insert
Upload employees test_db
DML intro
SELECT + WHERE
Comparison Functions and Operators
LIKE and String Comparison
SELECT and friends
ORDER BY, LIMIT, Subqueries
SELECT and ORDER BY
UPDATE
DELETE
INSERT, UPDATE, DELETE
Mighty Select
Aggregate Functions (COUNT, MAX, AVG and etc)
GROUP BY and HAVING
GROUP BY and Aggregate Functions
UNION
Check your knowledge of UNION
What is the beast: JOIN Clause?
JOIN types explained with diagrams (not Venn!)
The Power of JOIN
JOIN quiz
Data relations
Greatest N per group
Final test
enrol now
enroll now