Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012

1. 1. Setting Up the Environment - Finding and downloading SQL Server 2012 trial edition.mp43.36MB
2. 1. Setting Up the Environment - Finding and installing the sample data.mp46.35MB
3. 1. Setting Up the Environment - Installing SQL Server 2012 trial edition.mp410.35MB
4. 2. Introduction to Data Warehousing - Implementing a data warehouse using a SQL database engine.mp46.83MB
5. 2. Introduction to Data Warehousing - Overview of data warehousing.mp44.32MB
6. 3. Designing a Data Warehouse - Choosing between star and snowflake schema design techniques.mp411.22MB
7. 3. Designing a Data Warehouse - Logical design for a data warehouse.mp44.91MB
8. 3. Designing a Data Warehouse - Physical design for a data warehouse.mp425.09MB
9. 4. Data Warehouse Hardware - Appliances and big data.mp45.74MB
10. 4. Data Warehouse Hardware - Considerations for building a data warehouse.mp47.78MB
11. 4. Data Warehouse Hardware - Data warehouse reference architectures.mp46.49MB
12. 6. Debugging and Troubleshooting SSIS Packages - Debugging an SSIS package.mp417.58MB
13. 6. Debugging and Troubleshooting SSIS Packages - Handling errors in an SSIS package.mp413.82MB
14. 6. Debugging and Troubleshooting SSIS Packages - Logging SSIS package events.mp418.65MB
15. 7. Implementing an Incremental ETL Process - Extracting modified data.mp424.2MB
16. 7. Implementing an Incremental ETL Process - Introduction to incremental ETL.mp45.21MB
17. 7. Implementing an Incremental ETL Process - Loading modified data.mp410.51MB
18. 7. Implementing an Incremental ETL Process - Working with slowly changing dimensions.mp46.53MB
19. 8. Deploying and Configuring SSIS Packages - Configuring advanced SSIS settings.mp48.5MB
20. 8. Deploying and Configuring SSIS Packages - Deploying SSIS solutions.mp414.34MB
21. 8. Deploying and Configuring SSIS Packages - Installing and maintaining SSIS components.mp49.18MB
22. 8. Deploying and Configuring SSIS Packages - Using SQL Server Agent to execute an ETL package.mp415.41MB
23. 9. Enforcing Data Quality - Installing Data Quality Services.mp46.34MB
24. 9. Enforcing Data Quality - Using Data Quality Services to cleanse data.mp49.85MB
25. 9. Enforcing Data Quality - Using Data Quality Services to find duplicate data.mp418.98MB
26. 9. Enforcing Data Quality - Utilizing Data Quality Services in an SSIS data flow.mp419.6MB
27. 10. Consuming Data in a Data Warehouse - Introduction to business intelligence.mp44.63MB
28. 10. Consuming Data in a Data Warehouse - Using Reporting Services with a data warehouse.mp420.12MB
29. Conclusion - Next steps.mp43.13MB
30. Introduction - Using the exercise files.mp4886.33KB
31. Introduction - Welcome.mp46.48MB
32. Introduction - What you should know.mp4694.11KB