Premium Only Content

Learn SQL by Building a Student Database Part 2 | FreeCodeCamp
In this video, we will query our data with some advanced SQL techniques. We learn about WHERE, LIKE, ORDER BY, GROUP BY, HAVING, AS (Alias), FULL, INNER, LEFT, and RIGHT JOINS.
Thank you for watching and have a great day!
Connect with me on LinkedIn: https://www.linkedin.com/in/landon-schlangen-a3989a16b/
Time Stamps:
0:00:00 Intro
0:00:55 Setting up the data
0:03:20 Creating student_info.sh
0:06:00 Students with 4.0 gpa
0:09:50 Courses first letter before 'D'
0:13:00 Students last name after 'R'
0:16:40 Students last name contains 'sa'
0:24:36 Students not selected a major, first begins with 'D'
0:25:00 Technical Difficulties
0:27:43 Continue students not selected major
0:31:16 Course name of the first five courses
0:35:23 Average GPA of all students
0:38:50 Major ID, total number of students in a column named 'number_of_students'
0:50:50 List of majors, in alphabetical order, that either not student is taking...
1:14:30 List of unique courses, in reverse alphabetical order, that no student...
1:24:40 List of courses, in alphabetical order, with only one student enrolled
-
13:27
Clownfish TV
15 hours agoSydney Sweeney Backlash BACKFIRES! American Eagle Stock UP 38%! | Clownfish TV
42.7K11 -
18:55
AndresRestart
16 hours ago $0.84 earnedSomething Key We Keep Missing About Metroid Prime 4 Beyond...
18.5K1 -
8:06
China Uncensored
16 hours agoThis Could Be China’s LAST CHANCE To Save Its Economy
22.7K29 -
LIVE
The Bubba Army
2 days agoDocumentary Premiere, A HUGE SUCCESS! - Bubba the Love Sponge® Show | 9/08/25
1,323 watching -
32:15
DeVory Darkins
10 hours ago $7.80 earnedDemocrats PAINFULLY WRECKED by Tom Homan as paid protesters ERUPT in Chicago
25.5K67 -
16:59
Degenerate Jay
15 hours ago $2.92 earnedIs Metal Gear Solid Delta: Snake Eater Worth Buying?
44.4K2 -
4:26:28
Flex011
7 hours ago $0.86 earnedCronos: The New Dawn – Brutal Time-Travel Horror Survival
17.3K2 -
33:11
The Finance Hub
19 hours ago $2.55 earnedBREAKING: JD VANCE JUST RELEASED A MASSIVE BOMBSHELL!!! OMG!!
18K31 -
18:06
Professor Gerdes Explains 🇺🇦
17 hours agoAfter Major Attack, Trump Vows "Phase II" Sanctions on Russia
14.8K11 -
5:24:59
EVASIVE_rabbi
7 hours ago✅️ 2 Dumb Navy Vets & A First Playthrough #Coop ✅️
8.5K1