Lynda Implementing Data Warehouse with Microsoft SQL Server 2012 | B7BA2C81F8AEA6C1DCFF2A29986F5E5E39B6571E

Lynda Implementing Data Warehouse with Microsoft SQL Server 2012

Name	Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012	DOWNLOAD Copy Link
Total Size	355.8 MB
Total Files	43
Hash	B7BA2C81F8AEA6C1DCFF2A29986F5E5E39B6571E

/Exercise Files/
CreateView.txt	1.7 KB
Customers.csv	66.7 KB
DataProfile.txt	6.6 KB
EnableCDC.txt	0.2 KB
EnableTrack.txt	0.4 KB
Encryption.txt	0.3 KB
Geography.csv	13.6 KB
Reporting.txt	0.9 KB
ResellerSales.txt	12.8 MB
ResellerSalesErr.txt	0.8 KB
Truncate.txt	0.0 KB
/
1. Setting Up the Environment - Finding and downloading SQL Server 2012 trial edition.mp4	3.5 MB
1. Setting Up the Environment - Finding and installing the sample data.mp4	6.7 MB
1. Setting Up the Environment - Installing SQL Server 2012 trial edition.mp4	10.8 MB
2. Introduction to Data Warehousing - Implementing a data warehouse using a SQL database engine.mp4	7.2 MB
2. Introduction to Data Warehousing - Overview of data warehousing.mp4	4.5 MB
3. Designing a Data Warehouse - Choosing between star and snowflake schema design techniques.mp4	11.8 MB
3. Designing a Data Warehouse - Logical design for a data warehouse.mp4	5.2 MB
3. Designing a Data Warehouse - Physical design for a data warehouse.mp4	26.3 MB
4. Data Warehouse Hardware - Appliances and big data.mp4	6.0 MB
4. Data Warehouse Hardware - Considerations for building a data warehouse.mp4	8.2 MB
4. Data Warehouse Hardware - Data warehouse reference architectures.mp4	6.8 MB
6. Debugging and Troubleshooting SSIS Packages - Debugging an SSIS package.mp4	18.4 MB
6. Debugging and Troubleshooting SSIS Packages - Handling errors in an SSIS package.mp4	14.5 MB
6. Debugging and Troubleshooting SSIS Packages - Logging SSIS package events.mp4	19.6 MB
7. Implementing an Incremental ETL Process - Extracting modified data.mp4	25.4 MB
7. Implementing an Incremental ETL Process - Introduction to incremental ETL.mp4	5.5 MB
7. Implementing an Incremental ETL Process - Loading modified data.mp4	11.0 MB
7. Implementing an Incremental ETL Process - Working with slowly changing dimensions.mp4	6.8 MB
8. Deploying and Configuring SSIS Packages - Configuring advanced SSIS settings.mp4	8.9 MB
8. Deploying and Configuring SSIS Packages - Deploying SSIS solutions.mp4	15.0 MB
8. Deploying and Configuring SSIS Packages - Installing and maintaining SSIS components.mp4	9.6 MB
8. Deploying and Configuring SSIS Packages - Using SQL Server Agent to execute an ETL package.mp4	16.2 MB
9. Enforcing Data Quality - Installing Data Quality Services.mp4	6.6 MB
9. Enforcing Data Quality - Using Data Quality Services to cleanse data.mp4	10.3 MB
9. Enforcing Data Quality - Using Data Quality Services to find duplicate data.mp4	19.9 MB
9. Enforcing Data Quality - Utilizing Data Quality Services in an SSIS data flow.mp4	20.6 MB
10. Consuming Data in a Data Warehouse - Introduction to business intelligence.mp4	4.9 MB
10. Consuming Data in a Data Warehouse - Using Reporting Services with a data warehouse.mp4	21.1 MB
Conclusion - Next steps.mp4	3.3 MB
Introduction - Using the exercise files.mp4	907.6 KB
Introduction - Welcome.mp4	6.8 MB
Introduction - What you should know.mp4	710.8 KB
Total files 43