17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
[ CourseBoat.com ] Linkedin - Level Up - Advanced SQL
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Want to test out your advanced SQL skills? This course was designed for you. These concise challenges let you stretch your brain and push your talents to the next level. Join Microsoft MVP and SQL expert Jess Pomfret to find out more about what it takes to become a master SQL user. Learn how to execute some of the more sophisticated SQLite queries, including complex join types, grouping, advanced select options, windowing functions, and more.
This course is integrated with GitHub Codespaces, an instant development environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace.
Each installment of the Level Up series offers at least 15 bite-sized opportunities to practice programming at various levels of difficulty, so you can challenge yourself and reinforce what you’ve learned. Check out the “Using GitHub Codespaces with this course” video to learn how to get a codespace up and running.
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~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
21.6 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 KB
~Get Your Files Here !/02 - 1. Joins/03 - List all customers and their sales, even if some data is gone.mp4
10.6 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
12.9 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