Time Series Analysis in SQL Server
|
Explore ways to work with date and time data in SQL Server for time series analysis
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.
User Reviews
Be the first to review “Time Series Analysis in SQL Server”
Related Products
Getting Started Off-Platform for Data Science
Learn how to setup Jupyter Notebooks and PostGRESQL and run data science projects on your own computer locally!
Data Analyst Interview Preparation
Prepare for data analyst interviews from job postings to technical interviews.
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Data Manipulation in SQL
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Learn Node-SQLite
Learn how to interact with a SQL database from within your JavaScript programs!
There are no reviews yet.