VTC Implementing Data Warehouse with Microsoft SQL Server 2012 | 50F760389D11CFD41E2E291AC1CEA29BF66FA8D3

VTC Implementing Data Warehouse with Microsoft SQL Server 2012

Name	VTC - Implementing a Data Warehouse with Microsoft SQL Server 2012	DOWNLOAD Copy Link
Total Size	973.8 MB
Total Files	101
Hash	50F760389D11CFD41E2E291AC1CEA29BF66FA8D3

/sqlserver2012exam70463/
AdventureWorksDataFiles.zip	78.1 MB
Create_VTCDW_Database.sql	12.7 KB
TSQL LoadDimensionTables.sql	1.5 KB
CreateDimensionTables.sql	1.3 KB
TSQL LoadFactTable.sql	0.7 KB
Create Fact Table.sql	0.5 KB
/5. Data Flow Using SSIS/
04.Using the Import Export Wizard.flv	17.5 MB
19.Loading the FactInternetSales Table pt. 2.flv	14.9 MB
11.Understanding Containers.flv	14.5 MB
16.Loading the Customer Dimension pt. 2.flv	13.8 MB
15.Loading the Customer Dimension pt. 1.flv	13.5 MB
18.Loading the FactInternetSales Table pt. 1.flv	13.4 MB
08.Simple SSIS Example pt. 2.flv	13.4 MB
17.Loading the Customer Dimension pt. 3.flv	13.3 MB
07.Simple SSIS Example pt. 1.flv	12.9 MB
09.Using Connection Managers.flv	12.1 MB
12.Understanding Groups.flv	10.3 MB
03.Getting Visual Studio.flv	9.9 MB
01.SSIS Basics.flv	9.8 MB
05.SSIS Development Overview.flv	9.1 MB
02.Getting SQL Server Data Tools.flv	8.6 MB
13.Data Conversion Task.flv	7.9 MB
14.Customer Dimension Load Considerations.flv	6.0 MB
06.Data Movement Planning.flv	5.8 MB
10.Data and Control Flow.flv	5.7 MB
/2. Getting Set Up/
12.TechNet and MSDN.flv	17.2 MB
10.Exploring the Sample Database.flv	16.8 MB
04.Installing SQL Server 2012 pt- 1.flv	16.0 MB
05.Installing SQL Server 2012 pt- 2.flv	15.5 MB
07.Verifying the Installation.flv	13.6 MB
09.Attaching the Sample Database pt- 2.flv	13.0 MB
03.Getting the Software.flv	12.9 MB
11.Downloading Books Online.flv	11.5 MB
06.Installing SQL Server 2012 pt- 3.flv	9.1 MB
01.System Hardware Requirements.flv	8.2 MB
02.System Software Requirements.flv	6.1 MB
08.Attaching the Sample Database pt- 1.flv	6.1 MB
/7. Advanced Control Flow/
10.Package and Task Transactions pt. 2.flv	16.6 MB
08.Understanding Expressions pt. 2.flv	16.1 MB
01.Using Variables pt. 1.flv	12.8 MB
04.Property Parameterization pt. 1.flv	12.7 MB
09.Package and Task Transactions pt. 1.flv	12.0 MB
05.Property Parameterization pt. 2.flv	11.6 MB
07.Understanding Expressions pt. 1.flv	11.4 MB
02.Using Variables pt. 2.flv	10.2 MB
03.Understanding Variable Scope.flv	5.7 MB
06.Parameters vs. Variables.flv	5.1 MB
/6. Design and Implement Data Flow/
03.Data Flow Destination Adapters.flv	12.7 MB
01.Creating a Data Flow Task.flv	12.5 MB
02.Data Flow Source Adapters.flv	12.5 MB
04.Row or Batch Processing.flv	8.2 MB
/9. Custom Code in SSIS/
03.Using a Script pt. 2.flv	12.7 MB
02.Using a Script pt. 1.flv	11.6 MB
04.Using a Script pt. 3.flv	11.4 MB
05.Configuring Script Tools.flv	8.4 MB
01.Script Task Basics.flv	4.7 MB
/4. Creating a Data Warehouse/
19.Creating Our Dimensions.flv	12.6 MB
21.Creating Our Relationships.flv	11.1 MB
11.Understanding Indexes.flv	10.1 MB
06.Understanding SCDs pt. 2.flv	10.1 MB
02.Understanding Dimensions pt. 1.flv	9.9 MB
18.Data Lineage pt. 2.flv	9.7 MB
16.Using Partitions.flv	9.4 MB
08.Creating Our DW Database.flv	9.3 MB
15.Understanding Data Compression.flv	9.0 MB
07.Understanding SCDs pt. 3.flv	8.7 MB
05.Understanding SCDs pt. 1.flv	8.4 MB
04.Dimension Column Types.flv	8.1 MB
13.Indexing the Data Warehouse.flv	7.6 MB
17.Data Lineage pt. 1.flv	6.9 MB
14.Understanding Indexed Views.flv	6.8 MB
03.Understanding Dimensions pt. 2.flv	5.8 MB
09.Identifying Our Dimensions.flv	4.7 MB
10.Identifying Our Fact Table.flv	4.7 MB
01.Understanding Fact Tables.flv	4.5 MB
20.Creating Our Fact Table.flv	4.3 MB
12.Creating an Indexed View - missing.txt	0.0 KB
/3. Data Warehouse Basics/
08.Simple DW Example.flv	10.2 MB
03.Normalized Structure Challenges.flv	9.1 MB
05.Snowflake Schema Basics.flv	8.8 MB
07.Auditing and Lineage.flv	7.9 MB
04.Star Schema Basics.flv	7.1 MB
02.Understanding Normalization.flv	6.9 MB
01.Data Usage Challenges.flv	6.9 MB
06.Understanding Granularity.flv	6.8 MB
/10. Deploying Packages/
05.Scheduling a Package.flv	10.1 MB
04.Executing a Package.flv	8.0 MB
03.Deploying a Project.flv	7.1 MB
02.Creating the SSISDB Catalog.flv	6.7 MB
01.Deploying SSIS Packages.flv	3.7 MB
/1. Welcome/
05.Terminology.flv	9.4 MB
06.SQL Server 2012 Certification.flv	9.1 MB
03.SQL Server Basics.flv	6.9 MB
04.Database Types.flv	6.8 MB
07.About the 70-463 Exam.flv	5.1 MB
02.Course Overview.flv	3.4 MB
01.Introduction.flv	1.6 MB
/8. Data Services/
01.Data Quality Services Overview.flv	6.5 MB
03.Master Data Services Overview.flv	6.3 MB
02.Implementing DQS.flv	5.9 MB
/11. Conclusion/
Course Wrap Up.flv	6.3 MB
Total files 101