English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 23 lectures (0h 31m) | 184 MB
Dive into a 100% hands-on experience. With a SQL code console that 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
Challenges 1 to 10 ~ Solutions
1 Challenge 1 AVG, HAVING, ROUND
2 Challenge 2 CONCAT, Subquery
3 Challenge 3 CASE WHEN
4 Challenge 4 ARRAY_AGG
5 Challenge 5 COUNT DISTINCT
6 Challenge 6 HAVING
7 Challenge 7 AVG, GROUP BY
8 Challenge 8 AVG, HAVING, GROUP BY
9 Challenge 9 WHERE, HAVING, AVG
10 Challenge 10 COUNT DISTINCT, GROUP BY
Challenges 11 to 20 ~ Solutions
11 Challenge 11 MAX, GROUP BY 2 COLS
12 Challenge 12 AVG DURATION
13 Challenge 13 COUNT()
14 Challenge 14 FIND THE DIFFERENCE (MAX – MIN)
15 Challenge 15 FIND THE PERCENTAGE WITH COUNT()
16 Challenge 16 ROUND, AVG
17 Challenge 17 SUM, GROUP BY
18 Challenge 18 AVG, LIKE
19 Challenge 19 MIN, WHERE
20 Challenge 20 MAX, BETWEEN
21 Challenge 21 IS NULL
22 Challenge 22 IS NOT NULL, DATA AVAILABLE
23 Challenge 23 IN (‘ ‘, ‘ ‘)
Resolve the captcha to access the links!