Querying Data with SQL Server [2023, ENG] torrent

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

Querying Data with SQL Server

Год выпуска: 2023
Производитель: Pluralsight
Сайт производителя: Pluralsight.com
Автор: Mihaela Danci
Продолжительность: 1h 56m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: SQL is a fundamental skill in data management and data analysis that empowers you to handle complex scenarios with ease. In this course, Querying Data with SQL Server, you’ll gain the ability to extract, manipulate, and analyze data required to unlock valuable insights. First, you’ll learn the structure and basic components of an SQL query. Next, you’ll discover how to retrieve data from one or multiple tables while performing calculations on groups of rows. Finally, you’ll explore more advanced ways of retrieving data by working with subqueries, common table expressions, and window functions. When you’re finished with this course, you’ll have the SQL skills and knowledge needed to uncover hidden insights in your data.
[spoiler="Содержание"]
Course Overview 1m 46s
Selecting Data 22m 36s
Aggregating Data 17m 5s
Joining Data 16m 38s
Cleaning Data 16m 21s
Using Subqueries and CTEs 15m 41s
Working with Window Functions 26m 44s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: 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)]
[spoiler="Скриншоты"]

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