» » VTC :Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463



Information of news
  • Author: kityvn
  • Date: 25-09-2013, 14:27
25-09-2013, 14:27

VTC :Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463

Category: Tutorials

VTC :Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463
VTC :Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463
English | 94 WebRips (FLV) + 7 Exercises (5 SQLs, 2 MDFs) | Size: 1.22 GB



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. To begin learning
today, simply click on the movie links.

VTC - Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463-tG

Introduction

01 Course Overview

02 SQL Server Basics

03 Database Types

04 Terminology

05 SQL Server 2012 Certification

06 About the 70-463 Exam



Getting Set Up

01 System Hardware Requirements

02 System Software Requirements

03 Getting the Software

04 Installing SQL Server 2012 pt. 1

05 Installing SQL Server 2012 pt. 2

06 Installing SQL Server 2012 pt. 3

07 Verifying the Installation

08 Attaching the Sample Database pt. 1

09 Attaching the Sample Database pt. 2

10 Exploring the Sample Database

11 Downloading Books Online

12 TechNet and MSDN



Data Warehouse Basics

01 Data Usage Challenges

02 Understanding Normalization

03 Normalized Structure Challenges

04 Star Schema Basics

05 Snowflake Schema Basics

06 Understanding Granularity

07 Auditing and Lineage

08 Simple DW Example



Creating a Data Warehouse

01 Understanding Fact Tables

02 Understanding Dimensions pt. 1

03 Understanding Dimensions pt. 2

04 Dimension Column Types

05 Understanding SCDs pt. 1

06 Understanding SCDs pt. 2

07 Understanding SCDs pt. 3

08 Creating Our DW Database

09 Identifying Our Dimensions

10 Identifying Our Fact Table

11 Understanding Indexes

12 Indexing the Data Warehouse

13 Understanding Indexed Views

14 Creating an Indexed View

15 Understanding Data Compression

16 Using Partitions

17 Data Lineage pt. 1

18 Data Lineage pt. 2

19 Creating Our Dimensions

20 Creating Our Fact Table

21 Creating Our Relationships



Data Flow Using SSIS

01 SSIS Basics

02 Getting SQL Server Data Tools

03 Getting Visual Studio

04 Using the Import Export Wizard

05 SSIS Development Overview

06 Data Movement Planning

07 Simple SSIS Example pt. 1

08 Simple SSIS Example pt. 2

09 Using Connection Managers

10 Data and Control Flow

11 Understanding Containers

12 Understanding Groups

13 Data Conversion Task

14 Customer Dimension Load Considerations

15 Loading the Customer Dimension pt. 1

16 Loading the Customer Dimension pt. 2

17 Loading the Customer Dimension pt. 3

18 Loading the FactInternetSales Table pt. 1

19 Loading the FactInternetSales Table pt. 2



Design and Implement Data Flow

01 Creating a Data Flow Task

02 Data Flow Source Adapters

03 Data Flow Destination Adapters

04 Row or Batch Processing



Advanced Control Flow

01 Using Variables pt. 1

02 Using Variables pt. 2

03 Understanding Variable Scope

04 Property Parameterization pt. 1

05 Property Parameterization pt. 2

06 Parameters vs. Variables

07 Understanding Expressions pt. 1

08 Understanding Expressions pt. 2

09 Package and Task Transactions pt. 1

10 Package and Task Transactions pt. 2



Data Services

01 Data Quality Services Overview

02 Implementing DQS

03 Master Data Services Overview



Custom Code in SSIS

01 script Task Basics

02 Using a script pt. 1

03 Using a script pt. 2

04 Using a script pt. 3

05 Configuring script Tools



Deploying Packages

01 Deploying SSIS Packages

02 Creating the SSISDB Catalog

03 Deploying a Project

04 Executing a Package

05 Scheduling a Package



Conclusion

01 Course Wrap Up


I recommends Buy premimum account for High speed+parallel downloads!

rapidgator


uploaded





ryushare


uploaded


Rapidgator.net
Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.