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
-
1:10:55
Dear America
4 hours agoTrump Admin FINALLY Releasing More On Epstein!! + Department Of Education Is COOKED!
134K135 -
3:07:23
Matt Kohrs
12 hours agoCPI Inflation Report, Stocks Skyrocket & Bitcoin Cools || Live Trading
35.5K1 -
2:59:00
Wendy Bell Radio
7 hours agoSH*T Is About To Get Real
82.3K84 -
4:01:10
The Bubba Army
1 day agoGhislaine Maxwell: Ready to TALK?! - Bubba the Love Sponge® Show | 7/15/25
217K16 -
9:16
Zoufry
1 day ago $4.45 earnedThe Evil Design of Mcdonald's Drive Thru
45.6K22 -
LIVE
GritsGG
4 hours agoWe Are Winning Every Game!!!! Most Wins 3040+! 🔥
53 watching -
1:57:28
Gary Cardone
2 days ago $3.34 earnedLIVE With Gary Cardone
36.4K4 -
8:01
MattMorseTV
22 hours ago $14.39 earnedTrump just DROPPED a BOMBSHELL.
103K96 -
LIVE
FyrBorne
14 hours ago🔴Warzone M&K Sniping: Is The Overlook OP or Bait?
166 watching -
2:00:53
MG Show
1 day agoTrump Stops the Epstein Nonsense & Exposes FAKE MAGA; Victory Lap
127K101