Advanced T-SQL: Window Functions for Advanced Querying

7 Jan 2021 07:54 LEARNING » e-learning - Tutorial

Advanced T-SQL: Window Functions for Advanced Querying
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 17 lectures (1h 42m) | Size: 688 MB

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

Learn how to use Window Functions or Analytical Functions to perform data analysis in SQL Server

The concept of looking at data through a window

The fundamentals of Window Functions

How Window Functions compare to the traditional way of grouping data

The different types of window functions available in SQL

How to implement Window Functions

Window Ranking Functions

Window Aggregate Functions

Window Offset Functions

Window Statistical Functions

SQL Server 2012+

Experience writing and Tuning (Transact) SQL Queries

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?

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





Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis