Accéder au contenu principal

cours

Time Series Analysis in SQL Server

Intermédiaire

Updated 12/2024

Explore ways to work with date and time data in SQL Server for time series analysis

Commencer le cours gratuitement

Inclus gratuitementPremium or Teams

SQLManipulation des données5 heures16 vidéos60 exercices5,150 XP27,988Déclaration de réalisation

Créez votre compte gratuit

Google LinkedIn Facebook

ou

En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.

Formation de 2 personnes ou plus ?

Essayer DataCamp for Business

Apprécié par les apprenants de milliers d’entreprises

Description du cours

SQL Server has a robust set of tools to prepare, aggregate, and query time series data. This course will show you how to build and work with dates, parse dates from strings (and deal with invalid strings), and format dates for reporting. From there, you will see how SQL Server's built-in aggregation operators and window functions can solve important business problems like calculating running totals, finding moving averages, and displaying month-over-month differences using realistic sample data sets. You will also see how taking a different perspective on your data can solve difficult problems.

Conditions préalables

Intermediate SQL Server

1

Working with Dates and Times

Commencer le chapitre

Building dates

Break out a date into year, month, and day

Break a date and time into component parts

Date math and leap years

Rounding dates

Formatting dates for reporting

Formatting dates with CAST() and CONVERT()

Formatting dates with FORMAT()

Working with calendar tables

The benefits of calendar tables

Try out a calendar table

Joining to a calendar table

2

Converting to Dates and Times

Commencer le chapitre

Building dates from parts

Build dates from parts

Build dates and times from parts

Build dates and times with offsets from parts

Translating date strings

Cast strings to dates

Convert strings to dates

Parse strings to dates

Working with offsets

Changing a date's offset

Using the time zone DMV to look up times

Converting to a date offset

Handling invalid dates

Try out type-safe date functions

Convert imported data to dates with time zones

Test type-safe conversion function performance

3

Aggregating Time Series Data

Commencer le chapitre

Basic aggregate functions

Summarize data over a time frame

Calculating distinct counts

Calculating filtered aggregates

Statistical aggregate functions

Working with statistical aggregate functions

Calculating median in SQL Server

Downsampling and upsampling data

Downsample to a daily grain

Downsample to a weekly grain

Downsample using a calendar table

Grouping by ROLLUP, CUBE, and GROUPING SETS

Generate a summary with ROLLUP

View all aggregations with CUBE

Generate custom groupings with GROUPING SETS

Combine multiple aggregations in one query

4

Answering Time Series Questions with Window Functions

Commencer le chapitre

Using aggregation functions over windows

Contrasting ROW_NUMBER(), RANK(), and DENSE_RANK()

Aggregate window functions

Calculating running totals and moving averages

Running totals with SUM()

Investigating window frames

Calculating moving averages

Working with LAG() and LEAD()

Seeing prior and future periods

Seeing the prior three periods

Calculating days elapsed between incidents

Finding maximum levels of overlap

Analyze client data for potential fraud

Build a stream of events

Complete the fraud analysis

Wrapping up

Time Series Analysis in SQL Server

Cours
terminé

Earn Déclaration de réalisation

Ajoutez ces informations d’identification à votre profil LinkedIn, à votre CV ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance

Inclus avecPremium or Teams

S'inscrire maintenant

Inscrivez-vous 15 millions d’apprenants et commencer Time Series Analysis in SQL Server Aujourd’hui!

Créez votre compte gratuit

Google LinkedIn Facebook

ou

En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.