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

seeders: 10
leechers: 4
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 96
  • Language: English

Files

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

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



Download torrent
873.1 MB
seeders:10
leechers:4
Udemy - Advanced T-SQL: Window Functions for Advanced Querying

Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
873.1 MB
seeders:10
leechers:4
Udemy - Advanced T-SQL: Window Functions for Advanced Querying

Torrent hash: 6236FF341C30BC6F47D3F19DB9897AE3D434A552