Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012

文件列表

• Ex_Files_IDW_SQLS/Exercise Files/CreateView.txt1.6 KB
• Ex_Files_IDW_SQLS/Exercise Files/Customers.csv65.2 KB
• Ex_Files_IDW_SQLS/Exercise Files/DataProfile.txt6.4 KB
• Ex_Files_IDW_SQLS/Exercise Files/EnableCDC.txt245 B
• Ex_Files_IDW_SQLS/Exercise Files/EnableTrack.txt378 B
• Ex_Files_IDW_SQLS/Exercise Files/Encryption.txt328 B
• Ex_Files_IDW_SQLS/Exercise Files/Geography.csv13.3 KB
• Ex_Files_IDW_SQLS/Exercise Files/Reporting.txt943 B
• Ex_Files_IDW_SQLS/Exercise Files/ResellerSales.txt12.2 MB
• Ex_Files_IDW_SQLS/Exercise Files/ResellerSalesErr.txt849 B
• Ex_Files_IDW_SQLS/Exercise Files/Truncate.txt41 B
• 1. Setting Up the Environment - Finding and downloading SQL Server 2012 trial edition.mp43.4 MB
• 1. Setting Up the Environment - Finding and installing the sample data.mp46.4 MB
• 1. Setting Up the Environment - Installing SQL Server 2012 trial edition.mp410.3 MB
• 2. Introduction to Data Warehousing - Implementing a data warehouse using a SQL database engine.mp46.8 MB
• 2. Introduction to Data Warehousing - Overview of data warehousing.mp44.3 MB
• 3. Designing a Data Warehouse - Choosing between star and snowflake schema design techniques.mp411.2 MB
• 3. Designing a Data Warehouse - Logical design for a data warehouse.mp44.9 MB
• 3. Designing a Data Warehouse - Physical design for a data warehouse.mp425.1 MB
• 4. Data Warehouse Hardware - Appliances and big data.mp45.7 MB
• 4. Data Warehouse Hardware - Considerations for building a data warehouse.mp47.8 MB
• 4. Data Warehouse Hardware - Data warehouse reference architectures.mp46.5 MB
• 6. Debugging and Troubleshooting SSIS Packages - Debugging an SSIS package.mp417.6 MB
• 6. Debugging and Troubleshooting SSIS Packages - Handling errors in an SSIS package.mp413.8 MB
• 6. Debugging and Troubleshooting SSIS Packages - Logging SSIS package events.mp418.6 MB
• 7. Implementing an Incremental ETL Process - Extracting modified data.mp424.2 MB
• 7. Implementing an Incremental ETL Process - Introduction to incremental ETL.mp45.2 MB
• 7. Implementing an Incremental ETL Process - Loading modified data.mp410.5 MB
• 7. Implementing an Incremental ETL Process - Working with slowly changing dimensions.mp46.5 MB
• 8. Deploying and Configuring SSIS Packages - Configuring advanced SSIS settings.mp48.5 MB
• 8. Deploying and Configuring SSIS Packages - Deploying SSIS solutions.mp414.3 MB
• 8. Deploying and Configuring SSIS Packages - Installing and maintaining SSIS components.mp49.2 MB
• 8. Deploying and Configuring SSIS Packages - Using SQL Server Agent to execute an ETL package.mp415.4 MB
• 9. Enforcing Data Quality - Installing Data Quality Services.mp46.3 MB
• 9. Enforcing Data Quality - Using Data Quality Services to cleanse data.mp49.9 MB
• 9. Enforcing Data Quality - Using Data Quality Services to find duplicate data.mp419.0 MB
• 9. Enforcing Data Quality - Utilizing Data Quality Services in an SSIS data flow.mp419.6 MB
• 10. Consuming Data in a Data Warehouse - Introduction to business intelligence.mp44.6 MB
• 10. Consuming Data in a Data Warehouse - Using Reporting Services with a data warehouse.mp420.1 MB
• Conclusion - Next steps.mp43.1 MB
• Introduction - Using the exercise files.mp4886.3 KB
• Introduction - Welcome.mp46.5 MB
• Introduction - What you should know.mp4694.1 KB