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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 9470
    حجم: 1282 مگابایت
    مدت زمان: 183 دقیقه
    تاریخ انتشار: ۲۲ فروردین ۱۴۰۲
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید