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
-
43:44
Man in America
9 hours agoAmericans Are About to Lose Everything—And They Don’t Even Know It
54.2K27 -
1:41:11
Adam Does Movies
2 days ago $2.89 earnedTalking Movies + Ask Me Anything - LIVE
41.9K2 -
3:40:08
I_Came_With_Fire_Podcast
15 hours agoNASA Blocks China, TPUSA BOOSTED, Chinese Spamoflauge, & Factional Division
41.6K6 -
33:40
Jamie Kennedy
7 hours agoEp 222 Processing the Loss of Charlie Kirk | HTBITY with Jamie Kennedy
62.1K19 -
1:32:05
Badlands Media
22 hours agoAltered State S3 Ep. 46: Tactical Nukes, Thermite, and the 9/11 Puzzle
74.7K10 -
9:18
ARFCOM News
12 hours ago $1.97 earnedNSSF "Celebrates" ATF Partnership | Glocks BANNED | Redundant Spooky Boi Ban
39.3K9 -
13:09:13
LFA TV
20 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 9/17/25
309K61 -
1:00:00
BEK TV
1 day agoAPRIL LUND: FAITH, FOCUS, AND THE ROAD TO THE 2028 OLYMPIC MARATHON
25.7K1 -
37:15
Stephen Gardner
7 hours ago🔥Trump ERUPTS After Obama’s Charlie Kirk Comments!
38.6K79 -
13:40:35
Total Horse Channel
18 hours ago2025 WDAA Western Dressage World Championship Show | Day Two | Arena One
27.5K