▲
0
0

report

Udemy - Advanced T-SQL: Window Functions for Advanced Querying

seeders: 0
leechers: 0
Download torrent
Added 5 years ago by tutsnode in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

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

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

Related Torrents

torrent name size uploader age seed leech
Udemy - RF Engineering Fundamentals to Advanced Circuit Design Posted by freecoursewb in Other
3.1 GB freecoursewb 1 week 16 9
Udemy - Huawei HCIE Datacom Labs - Advanced IGP, BGP, MPLS VPN, EVPN Posted by freecoursewb in Other
3.8 GB freecoursewb 2 weeks 8 9
Udemy - Advanced Real Bug Bounty Case Studies - Volume 1 Posted by freecoursewb in Other
271.8 MB freecoursewb 2 weeks 12 6
Udemy - Beatbox - Complete Beginner to Advanced Course Posted by freecoursewb in Other
4 GB freecoursewb 2 weeks 0 0
Udemy - Oracle FCCS Advanced Consolidation, Ownership Accounting Posted by freecoursewb in Other
2.7 GB freecoursewb 4 weeks 2 1