TrainingCenter.com

Online Computer Training Courses, At Your Own Pace

Learn Online

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.

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

Getting Set Up

Data Warehouse Basics

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

Advanced Control Flow

Data Services

Custom Code in SSIS

Deploying Packages

Conclusion

TrainingCenter.com

Virtual Training

Benefits

Earn Certificates of Completion

Certificates

More Options

Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) Training Course