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

EssentialSQL: SQL Window Functions for Business Analytics

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

SQL Window Functions for SQL Server, MySQL, SQLite & PostgreSQL, for Data Analysis, Business Analytics and Intelligence


1. Introduction
  • 1. Welcome to the Course
  • 2. Why You Should Learn Windows Functions
  • 3. What Flavor of SQL Should I Choose
  • 4. How to Take the Course
  • 5.1 Azure Data Studio.html
  • 5.2 MySQL Downloads.html
  • 5.3 PostgreSQL Download.html
  • 5.4 PostgreSQL Extension for Azure Data Studio.html
  • 5.5 Sample Database Scripts.html
  • 5.6 SQL Server Downloads.html
  • 5.7 SQLite.html
  • 5. Tools Used and Database Setup

  • 2. Warmup
  • 1.1 01 What is a Window Function.pdf
  • 1.2 01 what is a window function.zip
  • 1. What is a Window Function
  • 2.1 02 Group By versus Window Function.pdf
  • 2.2 02 group by versus window function.zip
  • 2. GROUP BY versus Window Function Results
  • 3. Getting to Know Window Functions.html
  • 4.1 03 running total.zip
  • 4. Create Running Totals using SQL Joins versus Window Functions
  • 5. Write Your First Windows Function.html

  • 3. Windows and Partitions
  • 1.1 01 Introduction to Windows and Partitions.pdf
  • 1. Introduction
  • 2.1 02 Window Function Order of Operations.pdf
  • 2.2 02 window function order of operations.zip
  • 2. Window Function Order of Operations
  • 3.1 03 Using Over to Create a Window.pdf
  • 3.2 03 using over to create a window.zip
  • 3. Using OVER to create a window
  • 4.1 04 Using PARTITION BY to group rows.pdf
  • 4.2 04 using partition by to group rows.zip
  • 4. Using PARTITION BY to group rows
  • 5. Introduction to Partition By.html
  • 6. Using Multiple Window Functions.html
  • 7. Replacing Subquery with Window Function.html
  • 8.1 05 overcome limitations.zip
  • 8.2 05 Overcome Window Function Limitations.pdf
  • 8. Overcome Window Function Limitations
  • 9. Overcome Window Function Limitations.html
  • 10. Case Study in using Window Functions to Summarize Data.html

  • 4. Defining Window Function Frames with ROW and RANGE
  • 1.1 01 Introduction to Ordering Windows and Defining Boundaries.pdf
  • 1. Introduction to Window Frames
  • 2.1 02 over and order by.zip
  • 2.2 02 Using OVER with ORDER BY.pdf
  • 2. Using Over and Order by with Window Functions
  • 3. Coding Exercise Over and Order By #1.html
  • 4. Coding Exercise Over and Order By #2.html
  • 5. Coding Exercise Over and Order By #3.html
  • 6.1 03 Defining Window Frames Rows and Ranges Introduction.pdf
  • 6. Introduction to Defining Window Frames using ROWS and RANGES
  • 7.1 04 Using ROWS to define the Frame.pdf
  • 7. Using ROWS to Define the Window Frame.
  • 8.1 04 using rows to define the frame.zip
  • 8. Demonstration on Using ROWS to Define the Window Frame
  • 9. Using ROWS to Define the Window Frame #1.html
  • 10. Using ROWS to Define the Window Frame #2.html
  • 11. Using ROWS to Define the Window Frame #3.html
  • 12.1 05 Using RANGE to define the Frame.pdf
  • 12. Using RANGE to define the Window Frame
  • 13.1 05 using range to define the frame.zip
  • 13. Demonstration on Using RANGE to Define a Windows Frame
  • 14. Using Range to Define the Frame #2.html
  • 15. Using Range to Define the Frame #1.html
  • 16. Section Review (Evolution 1 of 3).html
  • 17. Section Review (Evolution 2 of 3).html
  • 18. Section Review (Evolution 3 of 3).html

  • 5. Aggregate Functions
  • 1.1 01 Introduction to Aggregrate Functions.pdf
  • 1. Introduction to Aggregate Functions with OVER
  • 2.1 02 Aggregrate Functions - Common.pdf
  • 2. Commonly Used Aggregate Functions
  • 3.1 03 Aggregrate Functions - Uncommom.pdf
  • 3. Uncommonly Used Aggregate Functions
  • 4.1 04 coding exercise - aggregate functions.zip
  • 4. Coding Exercise - Aggregate Functions and OVER().html

  • 6. Ranking Functions
  • 1.1 01 Introduction to Ranking Functions.pdf
  • 1. Introduction and Review of Functions
  • 2.1 02 Comparison of Ranking Functions.pdf
  • 2.2 02 comparison of ranking functions.zip
  • 2. Comparison of Ranking Functions
  • 3.1 03 Named Windows.pdf
  • 3.2 03 named windows.zip
  • 3. Using the WINDOWS clause.
  • 4. Ranking Weekly Radio Sales.html
  • 5. Ranking All Product Sales.html
  • 6. Ranking the top 10% Product Sales.html

  • 7. Analytic Functions
  • 1.1 01 Introuction to Analytic Functions.pdf
  • 1. Introduction to Analytic Functions
  • 2.1 02 Comparison of LEAD^J LAG^J FIRST ROW^J LAST ROW.pdf
  • 2. Comparison of LEAD, LAG, FIRST ROW and LAST ROW functions
  • 3.1 02 demo lead and lag.zip
  • 3. LEAD and LAG Demo
  • 4.1 02 demo first value last value.zip
  • 4. FIRST VALUE and LAST VALUE Demo
  • 5. Lead and Lag #1.html
  • 6. Lead and Lag #2.html
  • 7. Lead and Lag #3.html
  • 8.1 03 Comparison PERCENTILE RANK and CUME DIST.pdf
  • 8.2 03 demo percent rank cume dist.zip
  • 8. Calculating Percentiles using Window Functions
  • 9. Working with Percent Ranks.html
  • 10. Working with Cumulative Distributions.html

  • 8. Window Function Recipies
  • 1. How Do I Calculate a Running Total Using SQL.html
  • 2. How Do I Calculate a Moving Average using SQL.html
  • 3. How Do I Find Duplicates Using Windows Functions.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 9470
    حجم: 1282 مگابایت
    مدت زمان: 183 دقیقه
    تاریخ انتشار: 22 فروردین 1402
    طراحی سایت و خدمات سئو

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