SQL A Step-by-step Introduction for Data Science

Files Included :

1 Introduction video.mp4 (28.43 MB)
MP4
2 What is SQL.mp4 (38.43 MB)
MP4
1 IS NULL IS NOT NULL.mp4 (9.26 MB)
MP4
3 Coding Exercise Solution.mp4 (5.11 MB)
MP4
5 Coding Exercise Solution.mp4 (3.97 MB)
MP4
1 Using LIKE for pattern matching.mp4 (15.8 MB)
MP4
4 Coding Exercise Solution.mp4 (10.5 MB)
MP4
1 Aggregate functions.mp4 (15.44 MB)
MP4
10 Coding Exercise Solution.mp4 (3.11 MB)
MP4
13 Coding Exercise Solution.mp4 (4.5 MB)
MP4
3 Coding Exercise Solution.mp4 (11.55 MB)
MP4
6 Coding Exercise Solution.mp4 (3.93 MB)
MP4
8 Coding Exercise Solution.mp4 (2.51 MB)
MP4
1 Aggregation with GROUP BY.mp4 (11.42 MB)
MP4
3 Coding Exercise Solution.mp4 (8.23 MB)
MP4
6 Coding Exercise Solution.mp4 (5.97 MB)
MP4
8 Coding Exercise Solution.mp4 (4.28 MB)
MP4
1 HAVING.mp4 (11.62 MB)
MP4
4 Coding Exercise Solution.mp4 (6.9 MB)
MP4
7 Coding Exercise Solution.mp4 (8.62 MB)
MP4
12 Coding Exercise Solution.mp4 (7.04 MB)
MP4
2 INNER JOIN.mp4 (35.91 MB)
MP4
6 Coding Exercise Solution.mp4 (10.96 MB)
MP4
9 Coding Exercise Solution.mp4 (9.51 MB)
MP4
1 LEFT JOIN.mp4 (19.65 MB)
MP4
5 Coding Exercise Solution.mp4 (12.95 MB)
MP4
6 Full outer join.mp4 (10.53 MB)
MP4
1 Window Functions.mp4 (20.66 MB)
MP4
5 Coding Exercise Solution.mp4 (9.85 MB)
MP4
8 Coding Exercise Solution.mp4 (16.37 MB)
MP4
2 Window functions with ORDER BY - RANK().mp4 (10.04 MB)
MP4
5 Coding Exercise Solution.mp4 (10.56 MB)
MP4
1 LAG and LEAD.mp4 (19.96 MB)
MP4
5 Coding Exercise Solution.mp4 (11.62 MB)
MP4
1 SELECT FROM table;.mp4 (21.05 MB)
MP4
10 Coding Exercise Solution.mp4 (13.17 MB)
MP4
3 Coding exercise preview.mp4 (16.84 MB)
MP4
6 Coding Exercise Solution.mp4 (7.35 MB)
MP4
7 PRAGMA table info().mp4 (9.49 MB)
MP4
1 PARTITION BY.mp4 (11.31 MB)
MP4
6 Coding Exercise Solution.mp4 (10.31 MB)
MP4
1 LIMIT.mp4 (8.98 MB)
MP4
4 Coding exercise solution.mp4 (9.6 MB)
MP4
5 SELECT columns FROM table;.mp4 (7.38 MB)
MP4
7 Coding Exercise Solution.mp4 (7.98 MB)
MP4
1 ORDER BY.mp4 (8.16 MB)
MP4
10 Coding Exercise Solution.mp4 (9.03 MB)
MP4
3 Coding exercise solution.mp4 (12.73 MB)
MP4
4 ORDER BY DESC.mp4 (6.64 MB)
MP4
7 Coding Exercise Solution.mp4 (7.24 MB)
MP4
8 ORDER BY column1, column2.mp4 (4.28 MB)
MP4
1 SELECT DISTINCT.mp4 (5.94 MB)
MP4
3 Coding Exercise Solution.mp4 (4.46 MB)
MP4
4 SELECT DISTINCT, multiple columns.mp4 (8.76 MB)
MP4
6 Coding Exercise Solution.mp4 (5.21 MB)
MP4
1 AS (aliasing).mp4 (11.13 MB)
MP4
4 Coding Exercise Solution.mp4 (6.62 MB)
MP4
5 ALIAS with math operations - creating a new column.mp4 (3.58 MB)
MP4
7 Coding Exercise Solution.mp4 (4.28 MB)
MP4
1 UNION and UNION ALL - 3 min.mp4 (16.71 MB)
MP4
4 Coding Exercise Solution.mp4 (8.73 MB)
MP4
1 WHERE.mp4 (5.02 MB)
MP4
12 Coding Exercise Solution.mp4 (6.08 MB)
MP4
4 Coding Exercise Solution.mp4 (4.11 MB)
MP4
5 Comparison operators (, , =, =, etc).mp4 (6.61 MB)
MP4
7 Coding Exercise Solution.mp4 (5.24 MB)
MP4
8 Logical operators (AND, OR, NOT).mp4 (10.43 MB)
MP4
1 Using BETWEEN for range filtering.mp4 (6.55 MB)
MP4
5 Coding Exercise Solution.mp4 (9.03 MB)
MP4
6 IN (list matching).mp4 (10.54 MB)
MP4
8 Coding Exercise Solution.mp4 (6.22 MB)
MP4