Introduction to SQL for Simple Data Analysis

1. What is a relational database?
2. Primary and foreign keys in relational database.
3. Learn SQL using SQLite.
4. Filter, sort, and group data using SQL commands
5. One-to-one, one-to-many, and many-to-many relationships in SQL.

Self-study Videos

1. Tutorial 1. What is a database? (1:46 min) Required
2. Tutorial 2. Table Columns and Data Types (3:09 min) Required
3. Tutorial 3. References (6:03 min) Required
4. Tutorial 4. How to start creating a database model (1:59 min) Required
5. Primary & Foreign Keys (8:24 min) Required
6. Create and Read SQLite Databases using DB Browser (11:18 min) Required
7. SQL Tutorial for Beginners: Database, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIKE, IN, BETWEEN (35:46 min) Required
8. SQL JOIN tutorial 2021: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, join more than 2 tables (20:10 min) Required