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
-
2:16:28
Robert Gouveia
4 hours agoBarrack Obama is GUILTY!! Declassified Docs RELEASED! Ghislaine Maxwell MEETING!!
32.5K13 -
LIVE
charwinslow
1 hour ago🐈 Pokemon: Violet IRL Team Nintendo Switch 2 playthrough!
52 watching -
LIVE
RaikenNight
5 hours ago $0.02 earnedLets Play Games As We Rock Out To Crazy Train!
60 watching -
DVR
Edge of Wonder
6 hours agoCroatoan Mystery & Haunted Outer Banks: The Lost Colony of Roanoke
4.97K -
LIVE
Galactic Gaming Den
6 hours agoFinal Fantasy XIV Dawntrail Raid & Rant
15 watching -
2:22:10
Nick Freitas
3 hours agoChurchill, Franco, and Rhodesia: Rethinking the Villains and Heroes of History
11.1K5 -
13:01
Professor Gerdes Explains 🇺🇦
5 hours agoUkraine in Turmoil: MASSIVE PROTESTS Against Zelensky ERUPT Nationwide
14.6K4 -
1:43:11
Redacted News
5 hours agoBREAKING! TRUMP DECLARES WAR ON OBAMA "TREASON" AS A DEEP STATE RINGLEADER IN RUSSIA HOAX | REDACTED
147K181 -
1:22:13
Michael Franzese
5 hours agoPablo Escobar’s Son Breaks Silence About His Father, Narcos, and The Cartel
43.3K10 -
9:02
Hollywood Exposed
4 hours agoPiers Morgan's Guests ROAST DC's New Superman - It’s A Trainwreck!
15.8K4