Introduction to SQL for Simple Data Analysis

Behind every software application, web or mobile, is a database in which all the data needed for facilitating the operations of the application are stored and processed. To understand modern days software application development, the database is a must. The two major kinds of database are SQL and no-SQL databases. Here we focus on SQL as they represent the majority of databases used. For instance, MySQL and PostgreSQL.

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