Learn how to write SQL Queries | SMALL DATABASE
You can take advantage of this video to start learning how to write effective SQL queries. This video uses many examples.
Access the databases, the queries and the notes from this GitHub repository: https://github.com/royjafari/learn_SQL
Chapters
0:00 Introduction
1:26 Installing and using SQLite
2:30 Get to Know the Database
5:15 The Four Major of SQL: SELECT, UPDATE, INSERT, DELETE
10:29 DISTINCT
12:00 WHERE
14:08 ORDER BY
16:00 Example 1
17:05 Example 2
19:22 Aggregate Functions MIN, MAX, SUM, COUNT, AVG
20:20 JOIN
23:29 Example 3
25:55 Example 4
