[ CourseBoat.com ] Linkedin - Level Up - Advanced SQL

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/01 - Introduction/01 - Advanced SQL code challenges.mp4

4.7 MB

~Get Your Files Here !/01 - Introduction/01 - Advanced SQL code challenges.srt

1.8 kB

~Get Your Files Here !/01 - Introduction/02 - Using GitHub Codespaces with this course.mp4

22 MB

~Get Your Files Here !/01 - Introduction/02 - Using GitHub Codespaces with this course.srt

9.5 kB

~Get Your Files Here !/01 - Introduction/03 - How to execute SQLite queries.mp4

7.8 MB

~Get Your Files Here !/01 - Introduction/03 - How to execute SQLite queries.srt

5.8 kB

~Get Your Files Here !/02 - 1. Joins/01 - Create a list of employees and their immediate managers.mp4

5.4 MB

~Get Your Files Here !/02 - 1. Joins/01 - Create a list of employees and their immediate managers.srt

2.8 kB

~Get Your Files Here !/02 - 1. Joins/02 - Find salespeople who have zero sales.mp4

5.2 MB

~Get Your Files Here !/02 - 1. Joins/02 - Find salespeople who have zero sales.srt

3.0 kB

~Get Your Files Here !/02 - 1. Joins/03 - List all customers and their sales, even if some data is gone.mp4

11 MB

~Get Your Files Here !/02 - 1. Joins/03 - List all customers and their sales, even if some data is gone.srt

5.5 kB

~Get Your Files Here !/03 - 2. Grouping/01 - How many cars have been sold per employee.mp4

6.8 MB

~Get Your Files Here !/03 - 2. Grouping/01 - How many cars have been sold per employee.srt

3.7 kB

~Get Your Files Here !/03 - 2. Grouping/02 - Find the least and most expensive car sold by each employee.mp4

6.7 MB

~Get Your Files Here !/03 - 2. Grouping/02 - Find the least and most expensive car sold by each employee.srt

4.5 kB

~Get Your Files Here !/03 - 2. Grouping/03 - Display a report for employees who have sold at least five cars.mp4

7.2 MB

~Get Your Files Here !/03 - 2. Grouping/03 - Display a report for employees who have sold at least five cars.srt

3.5 kB

~Get Your Files Here !/04 - 3. Advanced Select Options/01 - Summarize sales per year by using a CTE.mp4

6.3 MB

~Get Your Files Here !/04 - 3. Advanced Select Options/01 - Summarize sales per year by using a CTE.srt

3.8 kB

~Get Your Files Here !/04 - 3. Advanced Select Options/02 - Display the number of sales for each employee by month for 2021.mp4

13 MB

~Get Your Files Here !/04 - 3. Advanced Select Options/02 - Display the number of sales for each employee by month for 2021.srt

5.4 kB

~Get Your Files Here !/04 - 3. Advanced Select Options/03 - Find the sales of cars that are electric by using a subquery.mp4

6.6 MB

~Get Your Files Here !/04 - 3. Advanced Select Options/03 - Find the sales of cars that are electric by using a subquery.srt

3.3 kB

~Get Your Files Here !/05 - 4. Windowing Functions/01 - For each salesperson, rank the car models they've sold the most.mp4

9.6 MB

~Get Your Files Here !/05 - 4. Windowing Functions/01 - For each salesperson, rank the car models they've sold the most.srt

4.7 kB

~Get Your Files Here !/05 - 4. Windowing Functions/02 - Create a report showing sales per month and an annual total.mp4

7.8 MB

~Get Your Files Here !/05 - 4. Windowing Functions/02 - Create a report showing sales per month and an annual total.srt

3.9 kB

~Get Your Files Here !/05 - 4. Windowing Functions/03 - Display the number of cars sold this month and last month.mp4

7.9 MB

~Get Your Files Here !/05 - 4. Windowing Functions/03 - Display the number of cars sold this month and last month.srt

5.2 kB

~Get Your Files Here !/06 - Conclusion/01 - Keep learning.mp4

2.4 MB

~Get Your Files Here !/06 - Conclusion/01 - Keep learning.srt

1.6 kB

~Get Your Files Here !/Bonus Resources.txt

386 B