Download [Udemy] EssentialSQL - SQL Window Functions for Business Analytics By Kris Wenzel Torrent

Torrent Contents Size: 1.24 GB

[Udemy] EssentialSQL - SQL Window Functions for Business Analytics By Kris Wenzel

1. Introduction

1. Welcome to the Course.mp4	MP4	27.8 MB
1. Welcome to the Course.srt	SRT	3.55 KB
2. Why You Should Learn Windows Functions.mp4	MP4	15.85 MB
2. Why You Should Learn Windows Functions.srt	SRT	4.75 KB
3. What Flavor of SQL Should I Choose.mp4	MP4	29.86 MB
3. What Flavor of SQL Should I Choose.srt	SRT	6 KB
4. How to Take the Course.mp4	MP4	17.43 MB
4. How to Take the Course.srt	SRT	5.63 KB
5. Tools Used and Database Setup.mp4	MP4	45.45 MB
5. Tools Used and Database Setup.srt	SRT	8.75 KB
5.1 Azure Data Studio.html	HTML	115 B
5.2 MySQL Downloads.html	HTML	93 B
5.3 PostgreSQL Download.html	HTML	97 B
5.4 PostgreSQL Extension for Azure Data Studio.html	HTML	168 B
5.5 Sample Database Scripts.html	HTML	108 B
5.6 SQL Server Downloads.html	HTML	124 B
5.7 SQLite.html	HTML	94 B

2. Warmup

1. What is a Window Function.mp4	MP4	23.91 MB
1. What is a Window Function.srt	SRT	7.86 KB
1.1 01 What is a Window Function.pdf	PDF	366.44 KB
1.2 01 What is a Window Function.sql	SQL	117 B
2. GROUP BY versus Window Function Results.mp4	MP4	55.56 MB
2. GROUP BY versus Window Function Results.srt	SRT	14.24 KB
2.1 02 Group By versus Window Function.pdf	PDF	441.74 KB
2.2 02 Group By versus Window Function.sql	SQL	328 B
3. Getting to Know Window Functions.html	HTML	155 B
4. Create Running Totals using SQL Joins versus Window Functions.mp4	MP4	54.83 MB
4. Create Running Totals using SQL Joins versus Window Functions.srt	SRT	14.41 KB
4.1 03 Running Total.sql	SQL	763 B
5. Write Your First Windows Function.html	HTML	151 B

3. Windows and Partitions

01+Introduction+to+Windows+and+Partitions.pdf	PDF	626 KB
02+Window+Function+Order+of+Operations.pdf	PDF	1.01 MB
02+Window+Function+Order+of+Operations.sql	SQL	946 B
03+Using+Over+to+Create+A+Window.sql	SQL	1.21 KB
03+Using+Over+to+Create+a+Window.pdf	PDF	1.09 MB
04+Using+PARTITION+BY+to+group+rows.pdf	PDF	655.23 KB
04+Using+PARTITION+BY+to+group+rows.sql	SQL	2.53 KB
05+Overcome+Limitations.sql	SQL	808 B
05+Overcome+Window+Function+Limitations.pdf	PDF	1.03 MB
1. Introduction.mp4	MP4	5.83 MB
1. Introduction.srt	SRT	1.23 KB
10. Case Study in using Window Functions to Summarize Data.html	HTML	155 B
2. Window Function Order of Operations.mp4	MP4	53.12 MB
2. Window Function Order of Operations.srt	SRT	9.19 KB
3. Using OVER to create a window.mp4	MP4	73.34 MB
3. Using OVER to create a window.srt	SRT	11.08 KB
4. Using PARTITION BY to group rows.mp4	MP4	205.13 MB
4. Using PARTITION BY to group rows.srt	SRT	17.31 KB
5. Introduction to Partition By.html	HTML	151 B
6. Using Multiple Window Functions.html	HTML	151 B
7. Replacing Subquery with Window Function.html	HTML	151 B
8. Overcome Window Function Limitations.mp4	MP4	96.62 MB
8. Overcome Window Function Limitations.srt	SRT	13.07 KB
9. Overcome Window Function Limitations.html	HTML	151 B

4. Defining Window Function Frames with ROW and RANGE

01+Introduction+to+Ordering+Windows+and+Defining+Boundaries.pdf	PDF	626.56 KB
02+Over+and+Order+By.sql	SQL	1.71 KB
02+Using+OVER+with+ORDER+BY.pdf	PDF	381.31 KB
03+Defining+Window+Frames+Rows+and+Ranges+Introduction.pdf	PDF	1.21 MB
04+Using+ROWS+to+define+the+Frame.pdf	PDF	1.04 MB
04+Using+Rows+to+Define+the+Frame.sql	SQL	1.79 KB
05+Using+RANGE+to+define+the+Frame.pdf	PDF	1.1 MB
05+Using+Range+to+Define+the+Frame.sql	SQL	1.08 KB
1. Introduction to Window Frames.mp4	MP4	9.59 MB
1. Introduction to Window Frames.srt	SRT	1.96 KB
10. Using ROWS to Define the Window Frame #2.html	HTML	151 B
11. Using ROWS to Define the Window Frame #3.html	HTML	151 B
12. Using RANGE to define the Window Frame.mp4	MP4	36.32 MB
12. Using RANGE to define the Window Frame.srt	SRT	3.89 KB
13. Demonstration on Using RANGE to Define a Windows Frame.mp4	MP4	53.7 MB
13. Demonstration on Using RANGE to Define a Windows Frame.srt	SRT	9.83 KB
14. Using Range to Define the Frame #2.html	HTML	151 B
15. Using Range to Define the Frame #1.html	HTML	151 B
16. Section Review (Evolution 1 of 3).html	HTML	151 B
17. Section Review (Evolution 2 of 3).html	HTML	151 B
18. Section Review (Evolution 3 of 3).html	HTML	151 B
2. Using Over and Order by with Window Functions.mp4	MP4	42.13 MB
2. Using Over and Order by with Window Functions.srt	SRT	9.33 KB
3. Coding Exercise – Over and Order By #1.html	HTML	151 B
4. Coding Exercise – Over and Order By #2.html	HTML	151 B
5. Coding Exercise – Over and Order By #3.html	HTML	151 B
6. Introduction to Defining Window Frames using ROWS and RANGES.mp4	MP4	24.14 MB
6. Introduction to Defining Window Frames using ROWS and RANGES.srt	SRT	4.5 KB
7. Using ROWS to Define the Window Frame.mp4	MP4	52.13 MB
7. Using ROWS to Define the Window Frame.srt	SRT	7.14 KB
8. Demonstration on Using ROWS to Define the Window Frame.mp4	MP4	49.41 MB
8. Demonstration on Using ROWS to Define the Window Frame.srt	SRT	9.51 KB
9. Using ROWS to Define the Window Frame #1.html	HTML	151 B

5. Aggregate Functions

01+Introduction+to+Aggregrate+Functions.pdf	PDF	624.08 KB
02+Aggregrate+Functions+-+Common.pdf	PDF	557.3 KB
03+Aggregrate+Functions++-+Uncommom.pdf	PDF	963.72 KB
04+Coding+Exercise+-+Aggregate+Functions.SQL	SQL	2.79 KB
1. Introduction to Aggregate Functions with OVER.mp4	MP4	10.17 MB
1. Introduction to Aggregate Functions with OVER.srt	SRT	2.42 KB
2. Commonly Used Aggregate Functions.mp4	MP4	29.05 MB
2. Commonly Used Aggregate Functions.srt	SRT	2.61 KB
3. Uncommonly Used Aggregate Functions.mp4	MP4	31.23 MB
3. Uncommonly Used Aggregate Functions.srt	SRT	4.93 KB
4. Coding Exercise - Aggregate Functions and OVER().html	HTML	2.55 KB

6. Ranking Functions

01+Introduction+to+Ranking+Functions.pdf	PDF	1.11 MB
02+Comparison+of+Ranking+Functions.pdf	PDF	375.62 KB
02+Comparison+of+Ranking+Functions.sql	SQL	1.11 KB
03+Named+Windows.pdf	PDF	371.99 KB
03+Named+Windows.sql	SQL	713 B
1. Introduction and Review of Functions.mp4	MP4	10.66 MB
1. Introduction and Review of Functions.srt	SRT	973 B
2. Comparison of Ranking Functions.mp4	MP4	66.86 MB
2. Comparison of Ranking Functions.srt	SRT	15.31 KB
3. Using the WINDOWS clause.mp4	MP4	20.32 MB
3. Using the WINDOWS clause.srt	SRT	4.11 KB
4. Ranking Weekly Radio Sales.html	HTML	151 B
5. Ranking All Product Sales.html	HTML	151 B
6. Ranking the top 10% Product Sales.html	HTML	151 B

7. Analytic Functions

01+Introuction+to+Analytic+Functions.pdf	PDF	767.53 KB
02+Comparison+of+LEAD^J+LAG^J+FIRST_ROW^J+LAST_ROW.pdf	PDF	744.52 KB
02+Demo+FIRST_VALUE+LAST_VALUE.sql	SQL	987 B
02+Demo+LEAD+and+LAG.sql	SQL	875 B
03+Comparison+PERCENTILE_RANK+and+CUME_DIST.pdf	PDF	391.08 KB
03+Demo+PERCENT_RANK+CUME_DIST.sql	SQL	1.28 KB
1. Introduction to Analytic Functions.mp4	MP4	3.87 MB
1. Introduction to Analytic Functions.srt	SRT	1.12 KB
10. Working with Cumulative Distributions.html	HTML	151 B
2. Comparison of LEAD, LAG, FIRST_ROW and LAST_ROW functions.mp4	MP4	25.71 MB
2. Comparison of LEAD, LAG, FIRST_ROW and LAST_ROW functions.srt	SRT	5.75 KB
3. LEAD and LAG Demo.mp4	MP4	28.57 MB
3. LEAD and LAG Demo.srt	SRT	6.52 KB
4. FIRST_VALUE and LAST_VALUE Demo.mp4	MP4	32.4 MB
4. FIRST_VALUE and LAST_VALUE Demo.srt	SRT	6.08 KB
5. Lead and Lag #1.html	HTML	151 B
6. Lead and Lag #2.html	HTML	151 B
7. Lead and Lag #3.html	HTML	151 B
8. Calculating Percentiles using Window Functions.mp4	MP4	27.78 MB
8. Calculating Percentiles using Window Functions.srt	SRT	7.77 KB
9. Working with Percent Ranks.html	HTML	151 B

8. Window Function Recipies

1. How Do I Calculate a Running Total Using SQL.html	HTML	4.84 KB
2. How Do I Calculate a Moving Average using SQL.html	HTML	5.87 KB
3. How Do I Find Duplicates Using Windows Functions.html	HTML	3.86 KB
4. How Do I Remove Duplicates Using ROW_NUMBER.html	HTML	5.07 KB
5. How Do I Calculate the Median value using SQL.html	HTML	1.92 KB
6. Calculate the Percentage Change from One Value to the Next.html	HTML	4.1 KB
7. How to Compare Two Moving Averages.html	HTML	4.82 KB
8. How to Add a Unique ID to a Query Result.html	HTML	2.51 KB

9. Bounus

1. Bonus Lecture.html

HTML

3.25 KB

Description

Show full description

[Udemy] EssentialSQL - SQL Window Functions for Business Analytics By Kris Wenzel

Torrent Contents Size: 1.24 GB

Description

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://open.demonoid.ch:6969/announce
udp://open.demonii.com:1337/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.torrent.eu.org:451/announce
udp://open.stealth.si:80/announce
udp://explodie.org:6969/announce
udp://exodus.desync.com:6969/announce
udp://tracker2.dler.org:80/announce