Don't like banners? Log in and we will make sure you see no banners. For free.
Advanced T-SQL Window Functions for Advanced Querying

Advanced T-SQL Window Functions for Advanced Querying

Other
Size
873 MB
Seeders
1
Leechers
0
Files
64
Category
Other
Added
at 5:31pm GMT+1
Infohash
6236ff341c30bc6f47d3f19db9897ae3d434a552
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description


Description



Learn how to analyze data in SQL Databases with ease using Window Functions.



In this self-paced course, I’ll be introducing you to Window Functions, also known as Analytical Functions because of their usefulness in data analysis.



We’ll cover the basics, key concepts, the different Window Functions we can work with, how to design these functions, and also some practical implementations. During the course, you’ll also be given an opportunity to try each technique for yourself.



The course comprises video presentations, resources, and referential links to text-based resources.



Also, Window Functions are part of the ANSI standard SQL specification, which means the topics we’ll cover in this course aren’t limited to SQL Server, we can use them with any relational database management system that supports SQL.



Once you have finished this course, you’ll receive a certificate that you can use to show your employers you have what it takes to Implement Window Functions.



So, what are you waiting for?

Who this course is for:



   Data Analysts

   Database Developers

   Database Administrators

   Anyone who wants to learn the art of writing Window Functions to analyze their data

   Anyone who wants to refresh their knowledge on Window Functions



Requirements



   SQL Server 2012+

   Experience writing and Tuning (Transact) SQL Queries



Last Updated 12/2020

File list
  • Advanced T-SQL Window Functions for Advanced Querying
  • .pad/0 73.4 KB
  • .pad/1 173.2 KB
  • .pad/10 441.9 KB
  • .pad/11 376 KB
  • .pad/12 462 KB
  • .pad/13 264.1 KB
  • .pad/14 289 KB
  • .pad/15 377.7 KB
  • .pad/16 390 KB
  • .pad/17 498.8 KB
  • .pad/2 172.7 KB
  • .pad/3 192.7 KB
  • .pad/4 297.4 KB
  • .pad/5 5.9 KB
  • .pad/6 52.7 KB
  • .pad/7 209.8 KB
  • .pad/8 59.1 KB
  • .pad/9 339.2 KB
  • TutsNode.com.txt 63 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/1. Welcome to this Course!.html 1.1 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/2. Course Introduction.mp4 7.7 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/2. Course Introduction.srt 4 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/3. Setting up your environment.html 608 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/3.1 Setting up your environment - Downloading SQL Server.pdf 435 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/3.2 Setting up your environment - Installing SQL Server.pdf 2.6 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4. Setting up your environment - Restoring the Database.mp4 12 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4. Setting up your environment - Restoring the Database.srt 3 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4.1 Chinook.bacpac 187.6 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4.2 Chinook v13.0.1742.0.bak 7.1 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4.3 BikeStores v13.0.1742.0.bak 25.1 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/4.4 BikeStores.bacpac 3.5 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/5. Introduction to Window Functions.mp4 36.2 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/1. Introduction/5. Introduction to Window Functions.srt 12.7 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/1. ROW_NUMBER.mp4 90.8 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/1. ROW_NUMBER.srt 14.8 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/2. RANK & DENSE_RANK.mp4 82.2 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/2. RANK & DENSE_RANK.srt 14.1 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/3. NTILE.mp4 57.8 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/3. NTILE.srt 9.6 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/4. Ranking Window Functions.html 153 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/2. Ranking Window Functions/5. Calculate the Bonus based on Employee Ratings.html 157 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/1. Types of Window Aggregate Functions.mp4 10.2 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/1. Types of Window Aggregate Functions.srt 3.1 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/2. Using Window Aggregate Functions.mp4 138.1 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/2. Using Window Aggregate Functions.srt 20.6 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/3. Introduction to Framing.mp4 36.1 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/3. Introduction to Framing.srt 11.9 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/4. Using Window Aggregate Functions with Frames.mp4 86.8 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/4. Using Window Aggregate Functions with Frames.srt 15.5 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/5. Window Aggregate Functions.html 153 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/3. Window Aggregate Functions/6. Sales per country and year.html 157 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/4. Window Offset Functions/1. LAG & LEAD.mp4 61.4 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/4. Window Offset Functions/1. LAG & LEAD.srt 11.7 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/4. Window Offset Functions/2. FIRST_VALUE & LAST_VALUE.mp4 44.4 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/4. Window Offset Functions/2. FIRST_VALUE & LAST_VALUE.srt 7.4 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/4. Window Offset Functions/3. Window Offset Functions.html 153 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/5. Window Statistical Functions/1. PERCENT_RANK & CUME_DIST.mp4 75.1 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/5. Window Statistical Functions/1. PERCENT_RANK & CUME_DIST.srt 14.7 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/5. Window Statistical Functions/2. PERCENTILE_CONT & PERCENTILE_DISC.mp4 82.8 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/5. Window Statistical Functions/2. PERCENTILE_CONT & PERCENTILE_DISC.srt 19 KB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/5. Window Statistical Functions/2.1 Table Value Constructor (SQL Server).html 170 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/6. Course Summary and Final Considerations/1. Final Assignment.html 157 B
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/6. Course Summary and Final Considerations/2. Course Summary.mp4 7.6 MB
  • [TutsNode.com] - Advanced T-SQL Window Functions for Advanced Querying/6. Course Summary and Final Considerations/2. Course Summary.srt 3.8 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
833 MB01