download скачать Free download скачать : Udemy - Master SQL On 2024 +1066 Challenges to Level Up Your Skills
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:677.48 MB

Files Included :

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

 https://rapidgator.net/file/7e923ee359ed5d75c98dd6e4f072ce48/.Master.SQL.On.2024._1066.Challenges.to.Level.Up.Your.Skills.rar

 https://filestore.me/f9apw06ag3we/.Master.SQL.On.2024.%2B1066.Challenges.to.Level.Up.Your.Skills.rar