VTC - Implementing a Data Warehouse with Microsoft SQL Server 2012 收录时间:2018-03-08 04:02:21 文件大小:929MB 下载次数:36 最近下载:2020-12-17 20:03:55 磁力链接: magnet:?xt=urn:btih:50f760389d11cfd41e2e291ac1cea29bf66fa8d3 立即下载 复制链接 文件列表 sqlserver2012exam70463/AdventureWorksDataFiles.zip 75MB 5. Data Flow Using SSIS/04.Using the Import Export Wizard.flv 17MB 2. Getting Set Up/12.TechNet and MSDN.flv 16MB 2. Getting Set Up/10.Exploring the Sample Database.flv 16MB 7. Advanced Control Flow/10.Package and Task Transactions pt. 2.flv 16MB 7. Advanced Control Flow/08.Understanding Expressions pt. 2.flv 15MB 2. Getting Set Up/04.Installing SQL Server 2012 pt- 1.flv 15MB 2. Getting Set Up/05.Installing SQL Server 2012 pt- 2.flv 15MB 5. Data Flow Using SSIS/19.Loading the FactInternetSales Table pt. 2.flv 14MB 5. Data Flow Using SSIS/11.Understanding Containers.flv 14MB 5. Data Flow Using SSIS/16.Loading the Customer Dimension pt. 2.flv 13MB 2. Getting Set Up/07.Verifying the Installation.flv 13MB 5. Data Flow Using SSIS/15.Loading the Customer Dimension pt. 1.flv 13MB 5. Data Flow Using SSIS/18.Loading the FactInternetSales Table pt. 1.flv 13MB 5. Data Flow Using SSIS/08.Simple SSIS Example pt. 2.flv 13MB 5. Data Flow Using SSIS/17.Loading the Customer Dimension pt. 3.flv 13MB 2. Getting Set Up/09.Attaching the Sample Database pt- 2.flv 12MB 5. Data Flow Using SSIS/07.Simple SSIS Example pt. 1.flv 12MB 2. Getting Set Up/03.Getting the Software.flv 12MB 7. Advanced Control Flow/01.Using Variables pt. 1.flv 12MB 7. Advanced Control Flow/04.Property Parameterization pt. 1.flv 12MB 6. Design and Implement Data Flow/03.Data Flow Destination Adapters.flv 12MB 9. Custom Code in SSIS/03.Using a Script pt. 2.flv 12MB 4. Creating a Data Warehouse/19.Creating Our Dimensions.flv 12MB 6. Design and Implement Data Flow/01.Creating a Data Flow Task.flv 12MB 6. Design and Implement Data Flow/02.Data Flow Source Adapters.flv 12MB 5. Data Flow Using SSIS/09.Using Connection Managers.flv 12MB 7. Advanced Control Flow/09.Package and Task Transactions pt. 1.flv 11MB 7. Advanced Control Flow/05.Property Parameterization pt. 2.flv 11MB 9. Custom Code in SSIS/02.Using a Script pt. 1.flv 11MB 2. Getting Set Up/11.Downloading Books Online.flv 11MB 9. Custom Code in SSIS/04.Using a Script pt. 3.flv 11MB 7. Advanced Control Flow/07.Understanding Expressions pt. 1.flv 11MB 4. Creating a Data Warehouse/21.Creating Our Relationships.flv 11MB 5. Data Flow Using SSIS/12.Understanding Groups.flv 10MB 7. Advanced Control Flow/02.Using Variables pt. 2.flv 10MB 3. Data Warehouse Basics/08.Simple DW Example.flv 10MB 10. Deploying Packages/05.Scheduling a Package.flv 10MB 4. Creating a Data Warehouse/11.Understanding Indexes.flv 10MB 4. Creating a Data Warehouse/06.Understanding SCDs pt. 2.flv 10MB 5. Data Flow Using SSIS/03.Getting Visual Studio.flv 9MB 4. Creating a Data Warehouse/02.Understanding Dimensions pt. 1.flv 9MB 5. Data Flow Using SSIS/01.SSIS Basics.flv 9MB 4. Creating a Data Warehouse/18.Data Lineage pt. 2.flv 9MB 4. Creating a Data Warehouse/16.Using Partitions.flv 9MB 1. Welcome/05.Terminology.flv 9MB 4. Creating a Data Warehouse/08.Creating Our DW Database.flv 9MB 3. Data Warehouse Basics/03.Normalized Structure Challenges.flv 9MB 5. Data Flow Using SSIS/05.SSIS Development Overview.flv 9MB 2. Getting Set Up/06.Installing SQL Server 2012 pt- 3.flv 9MB 1. Welcome/06.SQL Server 2012 Certification.flv 9MB 4. Creating a Data Warehouse/15.Understanding Data Compression.flv 9MB 3. Data Warehouse Basics/05.Snowflake Schema Basics.flv 8MB 4. Creating a Data Warehouse/07.Understanding SCDs pt. 3.flv 8MB 5. Data Flow Using SSIS/02.Getting SQL Server Data Tools.flv 8MB 9. Custom Code in SSIS/05.Configuring Script Tools.flv 8MB 4. Creating a Data Warehouse/05.Understanding SCDs pt. 1.flv 8MB 2. Getting Set Up/01.System Hardware Requirements.flv 8MB 6. Design and Implement Data Flow/04.Row or Batch Processing.flv 8MB 4. Creating a Data Warehouse/04.Dimension Column Types.flv 8MB 10. Deploying Packages/04.Executing a Package.flv 8MB 3. Data Warehouse Basics/07.Auditing and Lineage.flv 8MB 5. Data Flow Using SSIS/13.Data Conversion Task.flv 8MB 4. Creating a Data Warehouse/13.Indexing the Data Warehouse.flv 7MB 10. Deploying Packages/03.Deploying a Project.flv 7MB 3. Data Warehouse Basics/04.Star Schema Basics.flv 7MB 1. Welcome/03.SQL Server Basics.flv 7MB 4. Creating a Data Warehouse/17.Data Lineage pt. 1.flv 7MB 3. Data Warehouse Basics/02.Understanding Normalization.flv 7MB 3. Data Warehouse Basics/01.Data Usage Challenges.flv 7MB 3. Data Warehouse Basics/06.Understanding Granularity.flv 7MB 1. Welcome/04.Database Types.flv 6MB 4. Creating a Data Warehouse/14.Understanding Indexed Views.flv 6MB 10. Deploying Packages/02.Creating the SSISDB Catalog.flv 6MB 8. Data Services/01.Data Quality Services Overview.flv 6MB 11. Conclusion/Course Wrap Up.flv 6MB 8. Data Services/03.Master Data Services Overview.flv 6MB 2. Getting Set Up/02.System Software Requirements.flv 6MB 2. Getting Set Up/08.Attaching the Sample Database pt- 1.flv 6MB 5. Data Flow Using SSIS/14.Customer Dimension Load Considerations.flv 6MB 8. Data Services/02.Implementing DQS.flv 6MB 4. Creating a Data Warehouse/03.Understanding Dimensions pt. 2.flv 6MB 5. Data Flow Using SSIS/06.Data Movement Planning.flv 6MB 5. Data Flow Using SSIS/10.Data and Control Flow.flv 5MB 7. Advanced Control Flow/03.Understanding Variable Scope.flv 5MB 1. Welcome/07.About the 70-463 Exam.flv 5MB 7. Advanced Control Flow/06.Parameters vs. Variables.flv 5MB 4. Creating a Data Warehouse/09.Identifying Our Dimensions.flv 5MB 4. Creating a Data Warehouse/10.Identifying Our Fact Table.flv 4MB 9. Custom Code in SSIS/01.Script Task Basics.flv 4MB 4. Creating a Data Warehouse/01.Understanding Fact Tables.flv 4MB 4. Creating a Data Warehouse/20.Creating Our Fact Table.flv 4MB 10. Deploying Packages/01.Deploying SSIS Packages.flv 4MB 1. Welcome/02.Course Overview.flv 3MB 1. Welcome/01.Introduction.flv 2MB sqlserver2012exam70463/Create_VTCDW_Database.sql 12KB sqlserver2012exam70463/TSQL LoadDimensionTables.sql 1KB sqlserver2012exam70463/CreateDimensionTables.sql 1KB sqlserver2012exam70463/TSQL LoadFactTable.sql 665B sqlserver2012exam70463/Create Fact Table.sql 517B 4. Creating a Data Warehouse/12.Creating an Indexed View - missing.txt 0B