Work with Dynamic Data Patterns in SQL Server
Год выпуска: 2024
Производитель: Pluralsight
Сайт производителя: Pluralsight.com
Автор: Ana Voicu
Продолжительность: 0h 32m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: 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.
Содержание
Course Overview 1m 41s
Looking beyond a Row of Data with Window Functions 14m 42s
Working with More Advanced Data Partitioning Techniques 15m 51s
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1024x768 30fps 293kbps [V: English [eng] (h264 high L4.0, yuv420p, 1281x720, 293 kb/s)]
Аудио: AAC 44100Hz stereo 95kbps [A: SoundHandler [eng] (aac lc, 44100 Hz, stereo, 95 kb/s)]
Доп. информация: Level Beginner
