وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Level Up: Advanced SQL

سرفصل های دوره

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.


01 - Introduction
  • 01 - Advanced SQL code challenges
  • 02 - Using GitHub Codespaces with this course
  • 03 - How to execute SQLite queries

  • 02 - 1. Joins
  • 01 - Create a list of employees and their immediate managers
  • 02 - Find salespeople who have zero sales
  • 03 - List all customers and their sales, even if some data is gone

  • 03 - 2. Grouping
  • 01 - How many cars have been sold per employee
  • 02 - Find the least and most expensive car sold by each employee
  • 03 - Display a report for employees who have sold at least five cars

  • 04 - 3. Advanced Select Options
  • 01 - Summarize sales per year by using a CTE
  • 02 - Display the number of sales for each employee by month for 2021
  • 03 - Find the sales of cars that are electric by using a subquery

  • 05 - 4. Windowing Functions
  • 01 - For each salesperson, rank the car models theyve sold the most
  • 02 - Create a report showing sales per month and an annual total
  • 03 - Display the number of cars sold this month and last month

  • 06 - Conclusion
  • 01 - Keep learning
  • 54,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 10945
    حجم: 130 مگابایت
    مدت زمان: 38 دقیقه
    تاریخ انتشار: 10 اردیبهشت 1402
    طراحی سایت و خدمات سئو

    54,900 تومان
    افزودن به سبد خرید