2 Walkthrough and structure of the course.mp4 (5.88 MB)
MP4
2 Key cocepts to solve challenges.mp4 (2.05 MB)
MP4
3 INNER JOIN.mp4 (8.42 MB)
MP4
4 LEFT JOIN.mp4 (1.97 MB)
MP4
5 RIGHT JOIN.mp4 (2.82 MB)
MP4
6 HAVING.mp4 (2.72 MB)
MP4
7 WINDOWS FUNCTION.mp4 (6.98 MB)
MP4
8 AUTO-INCREMENT.mp4 (2.85 MB)
MP4
9 CONDITIONAL AGGREGATION.mp4 (8.84 MB)
MP4
1 Challenge 1 AVG, HAVING, ROUND.mp4 (18.79 MB)
MP4
10 Challenge 10 COUNT DISTINCT, GROUP BY.mp4 (11.49 MB)
MP4
2 Challenge 2 CONCAT, Subquery.mp4 (18.99 MB)
MP4
3 Challenge 3 CASE WHEN.mp4 (9.16 MB)
MP4
4 Challenge 4 ARRAY AGG.mp4 (9.05 MB)
MP4
5 Challenge 5 COUNT DISTINCT.mp4 (9.95 MB)
MP4
6 Challenge 6 HAVING.mp4 (6.46 MB)
MP4
7 Challenge 7 AVG, GROUP BY.mp4 (9.25 MB)
MP4
8 Challenge 8 AVG, HAVING, GROUP BY.mp4 (13.08 MB)
MP4
9 Challenge 9 WHERE, HAVING, AVG.mp4 (11.87 MB)
MP4
1 Challenge 11 MAX, GROUP BY 2 COLS.mp4 (9.88 MB)
MP4
10 Challenge 20 MAX, BETWEEN.mp4 (4.86 MB)
MP4
2 Challenge 12 AVG DURATION.mp4 (3.01 MB)
MP4
3 Challenge 13 COUNT().mp4 (6.26 MB)
MP4
4 Challenge 14 FIND THE DIFFERENCE (MAX - MIN).mp4 (4.86 MB)
MP4
5 Challenge 15 FIND THE PERCENTAGE WITH COUNT().mp4 (5.22 MB)
MP4
6 Challenge 16 ROUND, AVG.mp4 (3.08 MB)
MP4
7 Challenge 17 SUM, GROUP BY.mp4 (4.5 MB)
MP4
8 Challenge 18 AVG, LIKE.mp4 (3.97 MB)
MP4
9 Challenge 19 MIN, WHERE.mp4 (3.23 MB)
MP4
1 Challenge 21 IS NULL.mp4 (6.14 MB)
MP4
2 Challenge 22 IS NOT NULL, DATA AVAILABLE.mp4 (4.95 MB)
MP4
3 Challenge 23 IN (' ', ' ').mp4 (6.15 MB)
MP4
4 Challenge 24 IN operator.mp4 (4.31 MB)
MP4
5 Challenge 25 IN with AND operator.mp4 (5.86 MB)
MP4
6 Challenge 26 COUNT DISTINCT IN.mp4 (14.46 MB)
MP4
7 Challenge 27 Inner Join a Tempview - AGG Function.mp4 (13.07 MB)
MP4
8 Challenge 29 First value and Last value.mp4 (11.42 MB)
MP4
9 Challenge 30 Having Less than five.mp4 (12.98 MB)
MP4
1 Challenge 31 Having more than thee.mp4 (10.01 MB)
MP4
10 Challenge 40 Start with USING.mp4 (9.7 MB)
MP4
2 Challenge 32 Get duplicates.mp4 (8.6 MB)
MP4
3 Challenge 33 Inner Join with AND.mp4 (12.12 MB)
MP4
4 Challenge 34 Get the output BY DESC.mp4 (5.26 MB)
MP4
5 Challenge 35 Get Salaries Between Using Sub queries.mp4 (8.57 MB)
MP4
6 Challenge 36 Find the Highest Value by Customer.mp4 (4.39 MB)
MP4
7 Challenge 37 Apply an Inner Join.mp4 (9.79 MB)
MP4
8 Challenge 38 Retrieving columns with and INNER JOIN.mp4 (9.68 MB)
MP4
9 Challenge 39 Improving our INNER JOIN.mp4 (8.4 MB)
MP4
1 Challenge 41 Get colums with INNER JOIN and USING.mp4 (2.74 MB)
MP4
10 Challenge 50 Get the away home team opponent using LEFT JOIN and WHERE.mp4 (13.28 MB)
MP4
2 Challenge 42 Sorting our USING results.mp4 (2.38 MB)
MP4
3 Challenge 43 Get the numbers of languages spoken using two tables.mp4 (14.78 MB)
MP4
4 Challenge 44 Get The number of languages spoken on each county.mp4 (7.91 MB)
MP4
5 Challenge 45 Get two specific values.mp4 (7.96 MB)
MP4
6 Challenge 46 Filter with Case When.mp4 (10.93 MB)
MP4
7 Challenge 47 Identify with Case When progressive exercise.mp4 (7.43 MB)
MP4
8 Challenge 48 Get the opponent with LEFT JOIN.mp4 (24.24 MB)
MP4
9 Challenge 49 Get the opponent of a specific team using LEFT JOIN and WHERE.mp4 (17.78 MB)
MP4
1 Challenge 51 using WHERE to create a CASE WHEN.mp4 (23.41 MB)
MP4
10 Challenge 60 Filter by 2010 on JOIN.mp4 (8.12 MB)
MP4
2 Challenge 52 using WHERE to create the final CASE WHEN.mp4 (25.88 MB)
MP4
3 Challenge 53 Get all wins!.mp4 (10.17 MB)
MP4
4 Challenge 54 Get all wins filtering the null values.mp4 (15.67 MB)
MP4
5 Challenge 55 Brushing up INNER JOINS on another table.mp4 (9.24 MB)
MP4
6 Challenge 56 Brushing up INNER JOINS join 3 tables.mp4 (14.63 MB)
MP4
7 Challenge 57 Match the INNER JOIN by Year column.mp4 (11.85 MB)
MP4
8 Challenge 58 Find the column to JOIN.mp4 (9.69 MB)
MP4
9 Challenge 59 Change INNER to LEFT.mp4 (6.62 MB)
MP4
1 Challenge 61 AVG GDP per region.mp4 (17.69 MB)
MP4
2 Challenge 62 highest AVG GDP per capita.mp4 (13.46 MB)
MP4
3 Challenge 63 Perform a FULL JOIN.mp4 (9 MB)
MP4
4 Challenge 64 Change the FULL JOIN to LEFT JOIN.mp4 (9.11 MB)
MP4
5 Challenge 65 Perform an INNER JOIN instead of FULL JOIN and LEFT JOIN.mp4 (8.14 MB)
MP4