English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 75 lectures (1h 40m) | 677 MB
Dive into a 100% hands-on experience. Provided with a SQL console, ensures the most practical approach to SQL learning.
Welcome to 1000 challenges course. This course is designed for you to master whereas windows functions, grouping operations, and subqueries at an intermediate to advanced level.
Here’s what you can expect from this course:
Diverse Challenges: With over 1000 practical challenges, you’ll encounter a wide world of scenarios to test and enhance your skills.
Online Setup: No need to install anything locally; our platform is entirely web-based, providing hassle-free access to resources.
Hands-On Learning: Dive into a 100% hands-on experience with a code console, ensuring less theory and more practical application of concepts.
Experts Assistance: If you encounter difficulties, expert support is readily available to guide you back on track.
User-Friendly Interface: Our course features easy navigation.
Progressive Learning Pace: Tackle challenges at your own pace, with just 10 per day over 100 days, allowing for steady progress without overwhelming you.
What you’ll learn
- Windows functions
- Case statements
- All type of joins
- Query optimization
- Manage table transformations
- Sorting tecniques
- Advanced filtering
- CTS query
- Group by operations
- Subqueries (intermediate and advanced)
- Data Manipulation Language
- Having filtering and where clause
- Aggregate Functions
- Date and time functions
- String functions
- Conversion functions
- Practice advanced Data Analyst exercises
- Perform high level Data Engineering exercises
- Apply and develop Data Science skills
- Receive constant feedback and detailed logs to track your performance
- Expert support is always available to guide you back on track if you need assistance
- Continuously adding new challenges to keep your learning journey dynamic
- Progressive learning pace: Each section has 10 set of challenges in order you to get progress without overwhelming you
Table of Contents
User SQL resourse app
1 SQL Platform Access to Students
2 Walkthrough and structure of the course
Let’s get started
3 If you feel ready…
4 Key cocepts to solve challenges
5 INNER JOIN
6 LEFT JOIN
7 RIGHT JOIN
8 HAVING
9 WINDOWS FUNCTION
10 AUTO-INCREMENT
11 CONDITIONAL AGGREGATION
Challenges 1 to 10 ~ Solutions
12 Challenge 1 AVG, HAVING, ROUND
13 Challenge 2 CONCAT, Subquery
14 Challenge 3 CASE WHEN
15 Challenge 4 ARRAY_AGG
16 Challenge 5 COUNT DISTINCT
17 Challenge 6 HAVING
18 Challenge 7 AVG, GROUP BY
19 Challenge 8 AVG, HAVING, GROUP BY
20 Challenge 9 WHERE, HAVING, AVG
21 Challenge 10 COUNT DISTINCT, GROUP BY
Challenges 11 to 20 ~ Solutions
22 Challenge 11 MAX, GROUP BY 2 COLS
23 Challenge 12 AVG DURATION
24 Challenge 13 COUNT()
25 Challenge 14 FIND THE DIFFERENCE (MAX – MIN)
26 Challenge 15 FIND THE PERCENTAGE WITH COUNT()
27 Challenge 16 ROUND, AVG
28 Challenge 17 SUM, GROUP BY
29 Challenge 18 AVG, LIKE
30 Challenge 19 MIN, WHERE
31 Challenge 20 MAX, BETWEEN
Challenges 21 to 30 ~ Solutions
32 Challenge 21 IS NULL
33 Challenge 22 IS NOT NULL, DATA AVAILABLE
34 Challenge 23 IN (‘ ‘, ‘ ‘)
35 Challenge 24 IN operator
36 Challenge 25 IN with AND operator
37 Challenge 26 COUNT DISTINCT IN
38 Challenge 27 Inner Join a Tempview – AGG Function
39 Challenge 29 First value and Last value
40 Challenge 30 Having Less than five
Challenges 31 to 40 ~ Solutions
41 Challenge 31 Having more than thee
42 Challenge 32 Get duplicates
43 Challenge 33 Inner Join with AND
44 Challenge 34 Get the output BY DESC
45 Challenge 35 Get Salaries Between Using Sub queries
46 Challenge 36 Find the Highest Value by Customer
47 Challenge 37 Apply an Inner Join
48 Challenge 38 Retrieving columns with and INNER JOIN
49 Challenge 39 Improving our INNER JOIN
50 Challenge 40 Start with USING
Challenges 41 to 50 ~ Solutions
51 Challenge 41 Get colums with INNER JOIN and USING
52 Challenge 42 Sorting our USING results
53 Challenge 43 Get the numbers of languages spoken using two tables
54 Challenge 44 Get The number of languages spoken on each county
55 Challenge 45 Get two specific values
56 Challenge 46 Filter with Case When
57 Challenge 47 Identify with Case When progressive exercise
58 Challenge 48 Get the opponent with LEFT JOIN
59 Challenge 49 Get the opponent of a specific team using LEFT JOIN and WHERE
60 Challenge 50 Get the away home team opponent using LEFT JOIN and WHERE
Challenges 51 to 60 ~ Solutions
61 Challenge 51 using WHERE to create a CASE WHEN
62 Challenge 52 using WHERE to create the final CASE WHEN
63 Challenge 53 Get all wins!
64 Challenge 54 Get all wins filtering the null values
65 Challenge 55 Brushing up INNER JOINS on another table
66 Challenge 56 Brushing up INNER JOINS join 3 tables
67 Challenge 57 Match the INNER JOIN by Year column
68 Challenge 58 Find the column to JOIN
69 Challenge 59 Change INNER to LEFT
70 Challenge 60 Filter by 2010 on JOIN
Challenges 61 to 70 ~ Solutions
71 Challenge 61 AVG GDP per region
72 Challenge 62 highest AVG GDP per capita
73 Challenge 63 Perform a FULL JOIN
74 Challenge 64 Change the FULL JOIN to LEFT JOIN
75 Challenge 65 Perform an INNER JOIN instead of FULL JOIN and LEFT JOIN
Resolve the captcha to access the links!