Benefits
- Improve job skills
- Become more efficient
- Produce better results
- Earn certificates
- Study for certifications
- Managers view reports
Earn Certificates of Completion
Certificates

View all video tutorials for a course and download a certificate of completion to show employers or schools that you have completed that course.
Although online training can help prepare you to pass certification exams, we do not offer testing. Certification exams must be taken in person at an authorized testing center.
More Options
Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) Training Course
Improve job skills - Become more efficient - Produce better results !
Learn Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) (in only 8 hours)
Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.
Course Description: Business data analysis becomes more important as the amount of data involved in the analysis grows. This data is in various database management products, spreadsheets, and documents. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present. In this VTC course, author Mark Long walks you through the information you need to get prepared to take Microsoft's 70-463 certification exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is part of Microsoft's MCSA: SQL Server Certification. Online training videos are great for individuals and companies.
Click a play button below to view a free training video. Place your order online for full access.
Video Tutorials Included: 93
Free Video
Video Time
(minutes)
Welcome
SQL Server Basics
(4.32)
Database Types
(4.05)
Terminology
(5.55)
SQL Server 2012 Certification
(4.72)
About the 70-463 Exam
(3.02)
Getting Set Up
System Hardware Requirements
(4.32)
System Software Requirements
(3.53)
Getting the Software
(4.15)
Installing SQL Server 2012 pt. 1
(5.87)
Installing SQL Server 2012 pt. 2
(6.02)
Installing SQL Server 2012 pt. 3
(4.17)
Verifying the Installation
(3.93)
Attaching the Sample Database pt. 1
(2.92)
Attaching the Sample Database pt. 2
(4)
Exploring the Sample Database
(4.88)
Downloading Books Online
(4.4)
TechNet and MSDN
(4.42)
Data Warehouse Basics
Data Usage Challenges
(4.3)
Understanding Normalization
(4.33)
Normalized Structure Challenges
(5.53)
Star Schema Basics
(4.52)
Snowflake Schema Basics
(5.62)
Understanding Granularity
(4.45)
Auditing and Lineage
(5.13)
Simple DW Example
(6.3)
Creating a Data Warehouse
Understanding Fact Tables 2.87
Understanding Dimensions pt. 1 6.35
Understanding Dimensions pt. 2 3.78
Dimension Column Types 5.25
Understanding SCDs pt. 1 5.5
Understanding SCDs pt. 2 6.4
Understanding SCDs pt. 3 5.62
Creating Our DW Database 5.18
Identifying Our Dimensions 3.27
Identifying Our Fact Table 3.22
Understanding Indexes 6.47
Indexing the Data Warehouse 4.98
Understanding Indexed Views 4.5
Creating an Indexed View 6.53
Understanding Data Compression 5.47
Using Partitions 6.25
Data Lineage pt. 1 4.67
Data Lineage pt. 2 4.98
Creating Our Dimensions 5.87
Creating Our Fact Table 1.92
Creating Our Relationships 5.65
Data Flow Using SSIS
SSIS Basics 6.07
Getting SQL Server Data Tools 5.7
Getting Visual Studio 6.58
Using the Import Export Wizard 5.38
SSIS Development Overview 5.77
Data Movement Planning 3.93
Simple SSIS Example pt. 1 6.15
Simple SSIS Example pt. 2 5.8
Using Connection Managers 6.7
Data and Control Flow 4.02
Understanding Containers 6.72
Understanding Groups 4.7
Data Conversion Task 5.03
Customer Dimension Load Considerations 4.05
Loading the Customer Dimension pt. 1 6.83
Loading the Customer Dimension pt. 2 6.17
Loading the Customer Dimension pt. 3 6.12
Loading the FactInternetSales Table pt. 1 6.27
Loading the FactInternetSales Table pt. 2 6.25
Design and Implement Data Flow
Creating a Data Flow Task 6.4
Data Flow Source Adapters 6.32
Data Flow Destination Adapters 5.93
Row or Batch Processing 4.1
Advanced Control Flow
Using Variables pt. 1 5.98
Using Variables pt. 2 4.32
Understanding Variable Scope 3.33
Property Parameterization pt. 1 6.18
Property Parameterization pt. 2 4.55
Parameters vs. Variables 3.23
Understanding Expressions pt. 1 5.53
Understanding Expressions pt. 2 6.38
Package and Task Transactions pt. 1 6.33
Package and Task Transactions pt. 2 6.2
Data Services
Data Quality Services Overview 4.12
Implementing DQS 3.67
Master Data Services Overview 4.12
Custom Code in SSIS
Script Task Basics 2.75
Using a Script pt. 1 5.93
Using a Script pt. 2 6.25
Using a Script pt. 3 5.22
Configuring Script Tools 4.07
Deploying Packages
Deploying SSIS Packages 2.45
Creating the SSISDB Catalog 4.23
Deploying a Project 4.02
Executing a Package 5
Scheduling a Package 5.97
Conclusion
Course Wrap Up 4.43