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
-
LIVE
This is the Ray Gaming
3 hours ago $0.02 earnedBattlefield 6 Launch Day Part 2 | Rumble Premium Creator
133 watching -
58:29
NAG Podcast
5 hours agoChrissie Mayr: BOLDTALK W/Angela Belcamino
17.1K5 -
LIVE
Jokeuhl Gaming and Chat
5 hours agoMEGABONK - Why am I still playing this?
21 watching -
4:21:25
Fragniac
5 hours ago🔴 LIVE - FRAGNIAC - BATTLEFIELD 6 LAUNCH DAY w/ The BRRRAP Pack❗
1.67K -
12:25:12
Dr Disrespect
15 hours ago🔴LIVE - DR DISRESPECT - BATTLEFIELD 6 - THE WAR BEGINS | BF6 LAUNCH DAY
181K16 -
2:35:29
Bare Knuckle Fighting Championship
4 days agoBKFC ICE WARS 3: Laporte vs Lafferière
36.5K -
55:11
Sarah Westall
4 hours agoHidden Forces: Global Pushback from Lockdowns, Starvation and Death is Real w/ John Tamny
19.4K1 -
SynthTrax & DJ Cheezus Livestreams
1 day agoFriday Night Synthwave 80s 90s Electronica and more DJ MIX Livestream FUTUREPROOF / VARIETY Edition
17.4K1 -
8:59
China Uncensored
10 hours agoChina Just Declared Economic WAR On The US
13.3K12 -
13:10:25
LFA TV
1 day agoLIVE & BREAKING NEWS! | FRIDAY 10/10/25
172K42