Curriculum
Course:
SQL for Developers, Data Analysts and BI...
Login
Curriculum
SQL for Developers, Data Analysts and BI. MySQL for everyone
Section 1: Introduction
0/4
Installation guide
10min
Preview
A glance at the Workbench
14min
Data Normalization
18min
SQL and RDBMS
7 min
Section 2: DDL = Data Definition Language
0/9
DDL review, CREATE / DROP DATABASE
17min
CREATE / DROP TABLE intro
15min
VARCHAR, TEXT, CHAR
11min
Integers
10min
Floating-point numbers, exact precision and BIT
17min
UTF8MB4 Character Set, Collation Explained
11min
BLOB, ENUM, SET
11min
Date and Time
6min
DEFAULT values
6min
Section 3: Indexes, Keys, ALTER
0/5
Binary Search, B-trees and Keys
11min
Primary and Unique keys. NOT NULL
11min
Foreign keys
7 min
ALTER statement
7 min
How to construct any DDL statement?
9min
Section 4: Workbench and EER (Enhanced Entity-Relationship) diagrams
0/3
EER diagram with workbench
11min
Export DDL from EER
5min
Import and Backup
5min
Section 5: DML = Data Manipulation Language
0/9
Intro to DML
5min
Insert
4min
Upload employees test_db
5min
SELECT + WHERE
11min
Comparison Functions and Operators
13min
LIKE and String Comparison
8min
ORDER BY, LIMIT, Subqueries
7 min
UPDATE
11min
DELETE
6min
Section 6: Mighty Select
0/8
Aggregate Functions (COUNT, MAX, AVG and etc)
15min
GROUP BY and HAVING
9min
UNION
9min
What is the beast: JOIN Clause?
12min
JOIN types explained with diagrams (not Venn!)
11min
The Power of JOIN
11min
Data relations
10min
Greatest N per group
10min
Video lesson
Installation guide
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in