Share Description
In this course, you will :
- covers SQL Server date and time functionality, such as constructing dates from component parts, formatting dates for reporting, and working with calendar tables.
- learn how to aggregate data over time We will go over aggregation functions and statistical aggregation functions briefly.
- will go over data upsampling and downsampling Finally, we'll take a look at the grouping operators.
- Learn how to use window functions to perform time-based calculations such as running totals and moving averages, calculating intervals, and determining the maximum levels of overlap.
Syllabus :
- Working with Dates and Times
- Converting to Dates and Times
- Aggregating Time Series Data
- Answering Time Series Questions with Window Functions
