Time Series Analysis in SQL Server
Explore ways to work with date and time data in SQL Server for time series analysis
Comienza El Curso Gratis5 horas16 vídeos60 ejercicios27.783 aprendicesDeclaración de cumplimiento
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?
Probar DataCamp for BusinessPreferido por estudiantes en miles de empresas
Descripción del curso
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.
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
Desarrollador SQL Server
Ir a la pistaFundamentos de SQL Server
Ir a la pista- 1
Working with Dates and Times
GratuitoThis chapter covers date and time functionality in SQL Server, including building dates from component parts, formatting dates for reporting, and working with calendar tables.
Building dates50 xpBreak out a date into year, month, and day100 xpBreak a date and time into component parts100 xpDate math and leap years100 xpRounding dates100 xpFormatting dates for reporting50 xpFormatting dates with CAST() and CONVERT()100 xpFormatting dates with FORMAT()100 xpWorking with calendar tables50 xpThe benefits of calendar tables50 xpTry out a calendar table100 xpJoining to a calendar table100 xp - 2
Converting to Dates and Times
Here, we'll be converting strings and other inputs to date and time data types.
Building dates from parts50 xpBuild dates from parts100 xpBuild dates and times from parts100 xpBuild dates and times with offsets from parts100 xpTranslating date strings50 xpCast strings to dates100 xpConvert strings to dates100 xpParse strings to dates100 xpWorking with offsets50 xpChanging a date's offset100 xpUsing the time zone DMV to look up times100 xpConverting to a date offset100 xpHandling invalid dates50 xpTry out type-safe date functions100 xpConvert imported data to dates with time zones100 xpTest type-safe conversion function performance100 xp - 3
Aggregating Time Series Data
In this chapter, we will learn techniques to aggregate data over time. We will briefly review aggregation functions and statistical aggregation functions. We will cover upsampling and downsampling of data. Finally, we will look at the grouping operators.
Basic aggregate functions50 xpSummarize data over a time frame100 xpCalculating distinct counts100 xpCalculating filtered aggregates100 xpStatistical aggregate functions50 xpWorking with statistical aggregate functions100 xpCalculating median in SQL Server100 xpDownsampling and upsampling data50 xpDownsample to a daily grain100 xpDownsample to a weekly grain100 xpDownsample using a calendar table100 xpGrouping by ROLLUP, CUBE, and GROUPING SETS50 xpGenerate a summary with ROLLUP100 xpView all aggregations with CUBE100 xpGenerate custom groupings with GROUPING SETS100 xpCombine multiple aggregations in one query100 xp - 4
Answering Time Series Questions with Window Functions
In this chapter, we will learn how to use window functions to perform calculations over time, including calculating running totals and moving averages, calculating intervals, and finding the maximum levels of overlap.
Using aggregation functions over windows50 xpContrasting ROW_NUMBER(), RANK(), and DENSE_RANK()100 xpAggregate window functions100 xpCalculating running totals and moving averages50 xpRunning totals with SUM()100 xpInvestigating window frames100 xpCalculating moving averages100 xpWorking with LAG() and LEAD()50 xpSeeing prior and future periods100 xpSeeing the prior three periods100 xpCalculating days elapsed between incidents100 xpFinding maximum levels of overlap50 xpAnalyze client data for potential fraud100 xpBuild a stream of events100 xpComplete the fraud analysis100 xpWrapping up50 xp
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.En las siguientes pistas
Desarrollador SQL Server
Ir a la pistaFundamentos de SQL Server
Ir a la pistacolaboradores
requisitos previos
Intermediate SQL Server
¿Qué tienen que decir otros alumnos?
¡Únete a 15 millones de estudiantes y empieza Time Series Analysis in SQL Server hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.