-
Course
- Data
Work with Dynamic Data Patterns in SQL Server
Extracting information from data usually requires some processing. This course will show you how to partition your data in order to gain valuable insights without writing difficult queries.
What you'll learn
A useful functionality in SQL Server is the ability to perform calculations on a subset of table rows related to the current row.
In this course, Work with Dynamic Data Patterns in SQL Server, you’ll gain the ability to partition your data in order to gain valuable insights without writing difficult queries.
First, you’ll discover what window functions are.
Next, you’ll explore some real-life scenarios where using window functions in your queries comes in handy.
Finally, you’ll learn how to use different window functions in several scenarios, like calculating running totals and rolling averages, as well as examining benchmarks for comparison.
When you’re finished with this course, you’ll have the skills and knowledge of window functions needed to enhance your SQL queries' efficiency.
Table of contents
About the author
Ana Voicu is a software developer passionate about databases, Business Intelligence, and data science. She works on developing enterprise level Business Intelligence solutions for various types of industries, with a focus on performance optimization, pattern recognition, efficient analysis of the business processes, and interactive visualizations.
More Courses by Ana