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
-
3:14:05
Geeks + Gamers
4 hours agoGeeks + Gamers Play- MARIO KART WORLD
28.6K -
LIVE
Alex Zedra
3 hours agoLIVE! Scary Games tn!
298 watching -
47:26
Friday Beers
7 hours ago $1.43 earnedWe Drank 12 Beers & Found the Zodiac Killer
32.1K2 -
1:02:33
Mike Rowe
1 day agoCan We Fix The American Diet? | Jillian Michaels #441 | The Way I Heard It
20K17 -
1:08:23
VapinGamers
4 hours ago $0.95 earnedDune Awakening - Community Spice and Everything Nice Game Night - !rumbot !music
15.5K -
3:32:02
Fragniac
5 hours ago🔴 MAKE FPS GREAT AGAIN❗
13.8K -
3:05:48
RCAM
4 hours ago $0.79 earnedMarvel Rivals | Expedition 33 | Gaming on Rumble | @SELFMADEGGS
12.3K3 -
Razeo
4 hours agoEp 3 Batman Arkham City 1st playthrough – The Bat signal calls, Gotham’s Hero Rises Again!
9.48K1 -
8:50:56
Dr Disrespect
14 hours ago🔴LIVE - DR DISRESPECT vs TARKOV - NEW HARDCORE WIPE (DAY 1)
148K9 -
2:01:03
Melonie Mac
5 hours agoGo Boom Live Ep 54!
13.9K5