Advanced Functions in SQL Server: Performance and Practicality [2024, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Advanced Functions in SQL Server: Performance and Practicality

Год выпуска: 2024
Производитель: Pluralsight
Сайт производителя: Pluralsight.com
Автор: Rudi Bruchez
Продолжительность: 0h 35m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: Businesses and organizations must manage and analyze vast amounts of data efficiently in today's data-driven world. Slow query responses and inefficient data handling can significantly impact your business. In this course, Advanced Functions in SQL Server: Performance and Practicality, you'll learn to optimize database performance through advanced SQL Server functions. First, you'll learn how to write user-defined functions for advanced data manipulation, including scalar, table-valued, multi-statement functions, as well as writing clean, efficient, and reusable code. Next, you’ll discover techniques for optimizing these functions' performance, particularly in large databases. Finally, you’ll learn how to differentiate between deterministic and nondeterministic functions, identify and avoid common pitfalls in function usage, and apply functions for efficient data manipulation and analysis in real-world scenarios. When you’re finished with this course, you’ll have the skills and knowledge of advanced SQL Server functions needed to design, implement, and optimize complex functions, improving data retrieval speeds, report generation, and overall database efficiency.
[spoiler="Содержание"]
Course Overview 1m 18s
Advanced Function Optimization and Performance Assessment 16m 3s
Advanced Function Syntax and Usage 18m 36s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1024x768 30fps 293kbps [V: English [eng] (h264 high L4.0, yuv420p, 1280x720, 293 kb/s)]
Аудио: AAC 44100Hz stereo 95kbps [A: SoundHandler [eng] (aac lc, 44100 Hz, stereo, 95 kb/s)]
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Level Beginner