English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 24 lectures (0h 33m) | 250 MB
Dive into a100% hands-on SQL course. Get started with a real SQL query editor. The most effective way to learn by doing!
Test, enhance and challenge your SQL skills with over +300 join practical challenges, expert guidance, and a user-friendly interface.
Here’s what you can expect from this course:
Diverse Challenges: With over 1058 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
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Cross Join
- Self Join
- Natural Join
- Anti Join
- Semi Join
- Where joining
Table of Contents
Introduction
1 Introduction
Challenges
2 Challenge 33 Inner Join with AND
3 Challenge 37 Apply an Inner Join
4 Challenge 38 Retrieving columns with and INNER JOIN
5 Challenge 39 Improving our INNER JOIN
6 Challenge 40 Start joining with USING
7 Challenge 41 Get colums with INNER JOIN and USING
8 Challenge 42 Sorting our USING results
9 Challenge 43 Get the numbers of languages spoken using two tables
10 Challenge 44 Get The number of languages spoken on each county
11 Challenge 48 Get the opponent with LEFT JOIN
12 Challenge 49 Get the opponent of a specific team using LEFT JOIN and WHERE
13 Challenge 50 Get the away home team opponent using LEFT JOIN and WHERE
14 Challenge 55 Brushing up INNER JOINS on another table
15 Challenge 56 Brushing up INNER JOINS join 3 tables
16 Challenge 57 Match the INNER JOIN by Year column
17 Challenge 58 Find the column to JOIN
18 Challenge 59 Change INNER to LEFT
19 Challenge 60 Filter by 2010 on JOIN
20 Challenge 61 AVG GDP per region
21 Challenge 62 highest AVG GDP per capita
22 Challenge 63 Perform a FULL JOIN
23 Challenge 64 Change the FULL JOIN to LEFT JOIN
24 Challenge 65 Perform an INNER JOIN instead of FULL JOIN and LEFT JOIN
Resolve the captcha to access the links!