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
Видео Learn SQL by Building a Student Database Part 2 | FreeCodeCamp канала Landon Schlangen
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
Видео Learn SQL by Building a Student Database Part 2 | FreeCodeCamp канала Landon Schlangen
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Functional Programming | FreeCodeCampLearn Nano by Building a Castle | FreeCodeCampFor loops in 3 languagesUltimate Todo App Showdown | Web App BattlesWatch Me Solve Coding Problems Ep2 | CodewarsWhat is Svelte? | Svelte IntroductionBasic CSS | FreeCodeCampGoing through W3schools CSS DocumentationIntermediate Algorithm Scripting - Part 1 | FreeCodeCampJSON APIs and Ajax | FreeCodeCampMy Tabsystem ProjectPeriodic Table Database | FreeCodeCampAmerican British Translator | FreeCodeCampSudoku Solver | FreeCodeCampHow I do Frontendmentor ChallengesWhat is AWS EC2 (Elastic Cloud Compute)?Learn Intermediate CSS by Building a Picasso Painting | FreeCodeCampHow the back-end api connects to the front-end app | PERN StackFreeCodeCamp Tips and TricksSASS | FreeCodeCamp