Optimizing a Data Warehouse on the Microsoft SQL Server Platform [2020, ENG]
movies, software, shows...
Files
| 0. Course Overview | |||
| 0. Course Overview.mp4 | 4.55 MB | ||
| 0. Course Overview.srt | 3.37 KB | ||
| 1. Managing Data Warehouse with Best Practices | |||
| 0. Introduction.mp4 | 4.91 MB | ||
| 0. Introduction.srt | 4.74 KB | ||
| 1. Demo- Course Resource ZIP File and Restoring a Database.mp4 | 3.72 MB | ||
| 1. Demo- Course Resource ZIP File and Restoring a Database.srt | 2.47 KB | ||
| 2. Partitioning Data Warehouse Fact Tables | |||
| 0. Table Partitioning in SQL Server.mp4 | 8.35 MB | ||
| 0. Table Partitioning in SQL Server.srt | 8.78 KB | ||
| 1. Demo- Table Partitioning in SQL Server.mp4 | 10.55 MB | ||
| 1. Demo- Table Partitioning in SQL Server.srt | 5.39 KB | ||
| 10. Summary.mp4 | 917.44 KB | ||
| 10. Summary.srt | 1.06 KB | ||
| 2. Implementing Partitioning on a Fact Table for Faster Querying.mp4 | 10.21 MB | ||
| 2. Implementing Partitioning on a Fact Table for Faster Querying.srt | 8.25 KB | ||
| 3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.mp4 | 16.24 MB | ||
| 3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.srt | 5.16 KB | ||
| 4. Implementing Partition Switching on a Fact Table for Faster Loading.mp4 | 4.06 MB | ||
| 4. Implementing Partition Switching on a Fact Table for Faster Loading.srt | 4.1 KB | ||
| 5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.mp4 | 15.99 MB | ||
| 5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.srt | 5.92 KB | ||
| 6. Using Integration Services for Loading a Fact Table.mp4 | 4.34 MB | ||
| 6. Using Integration Services for Loading a Fact Table.srt | 4.2 KB | ||
| 7. Demo- Using Integration Services for Loading a Fact Table.mp4 | 27.67 MB | ||
| 7. Demo- Using Integration Services for Loading a Fact Table.srt | 8.93 KB | ||
| 8. Preparing Data and Tables for Bulk Insert.mp4 | 6.56 MB | ||
| 8. Preparing Data and Tables for Bulk Insert.srt | 7.62 KB | ||
| 9. Demo- Database Recovery Modes.mp4 | 15.04 MB | ||
| 9. Demo- Database Recovery Modes.srt | 4.48 KB | ||
| 3. Indexing Data Warehouse Tables | |||
| 0. Indexing in a Data Warehouse.mp4 | 16.99 MB | ||
| 0. Indexing in a Data Warehouse.srt | 16.2 KB | ||
| 1. Demo- Indexing in a Data Warehouse.mp4 | 44.11 MB | ||
| 1. Demo- Indexing in a Data Warehouse.srt | 14.22 KB | ||
| 2. Building a Clustered Index on the Date Key of a Fact Table.mp4 | 6.81 MB | ||
| 2. Building a Clustered Index on the Date Key of a Fact Table.srt | 6.43 KB | ||
| 3. Demo- Building a Clustered Index on the Date Key of a Fact Table.mp4 | 14.1 MB | ||
| 3. Demo- Building a Clustered Index on the Date Key of a Fact Table.srt | 4.55 KB | ||
| 4. Creating and Working with Columnstore Indexes.mp4 | 5.46 MB | ||
| 4. Creating and Working with Columnstore Indexes.srt | 4.93 KB | ||
| 5. Demo- Creating and Working with Columnstore Indexes.mp4 | 12.02 MB | ||
| 5. Demo- Creating and Working with Columnstore Indexes.srt | 4.15 KB | ||
| 6. Maintenance Plans for Indexes.mp4 | 3.49 MB | ||
| 6. Maintenance Plans for Indexes.srt | 4.86 KB | ||
| 7. Demo- Maintenance Plans for Indexes.mp4 | 7.83 MB | ||
| 7. Demo- Maintenance Plans for Indexes.srt | 4.19 KB | ||
| 8. Summary.mp4 | 1.86 MB | ||
| 8. Summary.srt | 2.26 KB | ||
| 4. Extracting, Transforming, and Loading (ETL) a Data Warehouse | |||
| 0. Creating an SSIS Package Template for Reuse.mp4 | 3.83 MB | ||
| 0. Creating an SSIS Package Template for Reuse.srt | 4.28 KB | ||
| 1. Demo- Creating an SSIS Package Template for Reuse.mp4 | 21.04 MB | ||
| 1. Demo- Creating an SSIS Package Template for Reuse.srt | 7.73 KB | ||
| 2. Creating a SSIS Solution and Project Template for Reuse.mp4 | 3.43 MB | ||
| 2. Creating a SSIS Solution and Project Template for Reuse.srt | 3.73 KB | ||
| 3. Demo- Creating a SSIS Solution and Project Template for Reuse.mp4 | 22.46 MB | ||
| 3. Demo- Creating a SSIS Solution and Project Template for Reuse.srt | 9.21 KB | ||
| 4. Creating Reusable Units of SSIS Package Workflow.mp4 | 1.92 MB | ||
| 4. Creating Reusable Units of SSIS Package Workflow.srt | 1.75 KB | ||
| 5. Demo- Creating Reusable Units of SSIS Package Workflow.mp4 | 12.05 MB | ||
| 5. Demo- Creating Reusable Units of SSIS Package Workflow.srt | 5.4 KB | ||
| 6. Implementing Parallelism for Faster Loading in SSIS.mp4 | 5.33 MB | ||
| 6. Implementing Parallelism for Faster Loading in SSIS.srt | 4.59 KB | ||
| 7. Demo- Implementing Parallelism for Faster Loading in SSIS.mp4 | 14.32 MB | ||
| 7. Demo- Implementing Parallelism for Faster Loading in SSIS.srt | 6.96 KB | ||
| 8. Summary.mp4 | 1.31 MB | ||
| 8. Summary.srt | 1.6 KB | ||
| 5. Cleansing Data in a Data Warehouse | |||
| 0. Data Quality Domains.mp4 | 4.08 MB | ||
| 0. Data Quality Domains.srt | 4.35 KB | ||
| 1. Demo- Data Quality Domains.mp4 | 10.5 MB | ||
| 1. Demo- Data Quality Domains.srt | 7.11 KB | ||
| 2. Creating a Project in Data Quality Services (DQS).mp4 | 2.63 MB | ||
| 2. Creating a Project in Data Quality Services (DQS).srt | 3.07 KB | ||
| 3. Demo- Creating a Project in Data Quality Services (DQS).mp4 | 6.42 MB | ||
| 3. Demo- Creating a Project in Data Quality Services (DQS).srt | 4.49 KB | ||
| 4. Cleaning Data in SSIS with a DQS Component.mp4 | 4.84 MB | ||
| 4. Cleaning Data in SSIS with a DQS Component.srt | 4.63 KB | ||
| 5. Demo- Cleaning Data in SSIS with a DQS Component.mp4 | 26.17 MB | ||
| 5. Demo- Cleaning Data in SSIS with a DQS Component.srt | 9.69 KB | ||
| 6. Summary.mp4 | 1.11 MB | ||
| 6. Summary.srt | 1.38 KB | ||
| 6. Centralizing Data with Master Data Management Processes | |||
| 0. Introduction to Master Data Services.mp4 | 1.41 MB | ||
| 0. Introduction to Master Data Services.srt | 1.23 KB | ||
| 1. Creating Projects with Master Data Services.mp4 | 5.07 MB | ||
| 1. Creating Projects with Master Data Services.srt | 5.05 KB | ||
| 2. Demo- Creating Projects with Master Data Services.mp4 | 12.94 MB | ||
| 2. Demo- Creating Projects with Master Data Services.srt | 8.49 KB | ||
| 3. Using Master Data Services for Common Data.mp4 | 5.3 MB | ||
| 3. Using Master Data Services for Common Data.srt | 5.66 KB | ||
| 4. Demo- Using Master Data Services for Common Data.mp4 | 19.42 MB | ||
| 4. Demo- Using Master Data Services for Common Data.srt | 8.36 KB | ||
| 5. Implementing a Master Data Services Model.mp4 | 3.37 MB | ||
| 5. Implementing a Master Data Services Model.srt | 3.37 KB | ||
| 6. Demo- Implementing a Master Data Services Model.mp4 | 15.59 MB | ||
| 6. Demo- Implementing a Master Data Services Model.srt | 9.01 KB | ||
| 7. Using Excel, SSMS, and SSDT for Managing MDM Data.mp4 | 3.37 MB | ||
| 7. Using Excel, SSMS, and SSDT for Managing MDM Data.srt | 3.4 KB | ||
| 8. Demo- Using Views in SSIS and Staging Data with SSMS.mp4 | 21.88 MB | ||
| 8. Demo- Using Views in SSIS and Staging Data with SSMS.srt | 8.57 KB | ||
| 9. Security and Sharing.mp4 | 7.41 MB | ||
| 9. Security and Sharing.srt | 8.65 KB | ||
| 7. Documenting a Data Warehouse | |||
| 0. Documenting a Data Warehouse.mp4 | 1.51 MB | ||
| 0. Documenting a Data Warehouse.srt | 1.69 KB | ||
| 1. Building a Data Dictionary through Data Profiling.mp4 | 3.92 MB | ||
| 1. Building a Data Dictionary through Data Profiling.srt | 3.9 KB | ||
| 2. Demo- Building a Data Dictionary through Data Profiling.mp4 | 16.75 MB | ||
| 2. Demo- Building a Data Dictionary through Data Profiling.srt | 8.21 KB | ||
| 3. Automating DDL SQL Production.mp4 | 2.08 MB | ||
| 3. Automating DDL SQL Production.srt | 2.14 KB | ||
| 4. Demo- Automating DDL for a New Database.mp4 | 11.67 MB | ||
| 4. Demo- Automating DDL for a New Database.srt | 4.63 KB | ||
| 5. Demo- Automating DDL for a Change.mp4 | 17.12 MB | ||
| 5. Demo- Automating DDL for a Change.srt | 8.01 KB | ||
| 6. Document Data Flows.mp4 | 2.41 MB | ||
| 6. Document Data Flows.srt | 2.53 KB | ||
| 7. Demo- Document Data Flows.mp4 | 9.46 MB | ||
| 7. Demo- Document Data Flows.srt | 3.39 KB | ||
| 8. Summary.mp4 | 1.12 MB | ||
| 8. Summary.srt | 1.46 KB | ||
| content.txt | 3.55 KB | ||
| optimizing-data-warehouse-microsoft-sql-server-platform.zip | 76.29 MB |
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » ОС и серверные программы Microsoft
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
Год выпуска: 2020
Производитель: Pluralsight
Сайт производителя: www.Pluralsight.com
Автор: Thomas LeBlanc
Продолжительность: 3h 3m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: Once a data warehouse is initially created, performance and maintainability come into question. In this course, you'll explore SQL Server and the tools and resources needed to efficiently optimize a data warehouse.
Как только хранилище данных создано, производительность и ремонтопригодность ставятся под сомнение. В этом курсе вы изучите SQL Server, а также инструменты и ресурсы, необходимые для эффективной оптимизации хранилища данных.
[spoiler="Содержание"]
Course Overview 2m 5s
Course Overview 2m 5s
Managing Data Warehouse with Best Practices 4m 9s
Introduction 2m 50s
Demo: Course Resource ZIP File and Restoring a Database 1m 19s
Partitioning Data Warehouse Fact Tables 38m 35s
Table Partitioning in SQL Server 5m 10s
Demo: Table Partitioning in SQL Server 3m 17s
Implementing Partitioning on a Fact Table for Faster Querying 5m 12s
Demo: Implementing Partitioning on a Fact Table for Faster Querying 2m 58s
Implementing Partition Switching on a Fact Table for Faster Loading 2m 25s
Demo: Implementing Partition Switching on a Fact Table for Faster Loading 3m 37s
Using Integration Services for Loading a Fact Table 2m 32s
Demo: Using Integration Services for Loading a Fact Table 5m 31s
Preparing Data and Tables for Bulk Insert 4m 19s
Demo: Database Recovery Modes 2m 51s
Summary 38s
Indexing Data Warehouse Tables 35m 11s
Indexing in a Data Warehouse 9m 1s
Demo: Indexing in a Data Warehouse 8m 0s
Building a Clustered Index on the Date Key of a Fact Table 3m 45s
Demo: Building a Clustered Index on the Date Key of a Fact Table 2m 40s
Creating and Working with Columnstore Indexes 2m 53s
Demo: Creating and Working with Columnstore Indexes 2m 26s
Maintenance Plans for Indexes 2m 41s
Demo: Maintenance Plans for Indexes 2m 29s
Summary 1m 13s
Extracting, Transforming, and Loading (ETL) a Data Warehouse 26m 37s
Creating an SSIS Package Template for Reuse 2m 27s
Demo: Creating an SSIS Package Template for Reuse 4m 35s
Creating a SSIS Solution and Project Template for Reuse 2m 11s
Demo: Creating a SSIS Solution and Project Template for Reuse 5m 40s
Creating Reusable Units of SSIS Package Workflow 1m 10s
Demo: Creating Reusable Units of SSIS Package Workflow 3m 6s
Implementing Parallelism for Faster Loading in SSIS 2m 40s
Demo: Implementing Parallelism for Faster Loading in SSIS 3m 52s
Summary 53s
Cleansing Data in a Data Warehouse 20m 12s
Data Quality Domains 2m 38s
Demo: Data Quality Domains 4m 7s
Creating a Project in Data Quality Services (DQS) 1m 43s
Demo: Creating a Project in Data Quality Services (DQS) 2m 27s
Cleaning Data in SSIS with a DQS Component 2m 43s
Demo: Cleaning Data in SSIS with a DQS Component 5m 46s
Summary 45s
Centralizing Data with Master Data Management Processes 36m 6s
Introduction to Master Data Services 52s
Creating Projects with Master Data Services 3m 4s
Demo: Creating Projects with Master Data Services 5m 4s
Using Master Data Services for Common Data 3m 13s
Demo: Using Master Data Services for Common Data 4m 47s
Implementing a Master Data Services Model 2m 0s
Demo: Implementing a Master Data Services Model 5m 24s
Using Excel, SSMS, and SSDT for Managing MDM Data 1m 54s
Demo: Using Views in SSIS and Staging Data with SSMS 4m 47s
Security and Sharing 4m 57s
Documenting a Data Warehouse 20m 52s
Documenting a Data Warehouse 1m 0s
Building a Data Dictionary through Data Profiling 2m 14s
Demo: Building a Data Dictionary through Data Profiling 4m 35s
Automating DDL SQL Production 1m 14s
Demo: Automating DDL for a New Database 2m 52s
Demo: Automating DDL for a Change 4m 39s
Document Data Flows 1m 29s
Demo: Document Data Flows 1m 57s
Summary 49s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1280x720 30fps 198kbps [V: ETI ISO Video Media Handler (h264 high L3.1, yuv420p, 1280x720, 198 kb/s)]
Аудио: AAC 48000Hz stereo 96kbps [A: ETI ISO Audio Media Handler [eng] (aac lc, 48000 Hz, stereo, 96 kb/s)]
[spoiler="Скриншоты"]
[/spoiler]
Доп. информация: Level Intermediate
Duration 3h 3m
Released 1 Apr 2020
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 690.5 MB | freecoursewb | 4 years | 4 | 1 | |
| 347.3 MB | abidmail | 6 years | 0 | 0 | |
| 322.4 MB | freecoursewb | 6 years | 7 | 0 | |
| 192.26 MB | 2boweb | 11 years | 1 | 0 | |
| 185.7 MB | groovymax123 | 11 years | 0 | 0 |
All Comments