1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)


  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course
  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course
  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course
  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course
  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course
  • 1st step to certification: Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463), Singapore SKillsFuture elarning online course

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.

Be fully prepared for your certifications exams!

- Learn of the examination outline before sitting for your certification
- Know and understand the topics that may be covered in your examinations
- Learn and understand the chapters for each tailored certification
- Go through past questions to have a feel of the examinations


Course Objectives

1. Know what to expect for your examination 
2. Understand the introduction to SQL Server 2012
3. Be able to install and configure SQL Server 2012 
4. Know how to create a Data Warehouse
5. Understand the Data Flow with SSIS
6. Be able to Design and Implement Data Flow 
7. Know about the Advanced Control Flow 
8. Understand the Data Services
9. Be able to Custom Code in SSIS
10. Understand about Deploying Packages


Related Courses

  • 1st step towards certification: CISSP-ISSEP

    1st step towards certification: CISSP-ISSEP

    SGD $58.00

    Course Description

    In this VTC course, veteran instructor Bobby Rogers prepares you for the ISC2 Information System Security Engineering Professional (ISSEP) certification exam. Designed for persons already holding a current CISSP certification, the course will cover all 4 domains of the ISSEP Common Body of Knowledge (CBK): Information System Security Engineering, Certification and Accreditation, Technical Management, and US Government IA Publications. This course covers the new March 2012 objectives.  Be fully prepared for your certifications exams! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Learn and understand the chapters for each tailored certification  - Go through past questions to have a feel of the examinations This course is SkillsFuture Credit Eligible.

    Read more...

  • A+ Certification Prep

    A+ Certification Prep

    SGD $299.00

    Course Description

    The A+ Certification Prep Course readies students for CompTIA's A+ certification which validates an understanding of the most common hardware and software technologies in business as well as the skills necessary to support complex IT infrastructures. With top experts and an interactive, lab-filled enviornment students gain essential competencies with the equivalent understanding of at least one year of hands-on experience in the field/lab. The A+ Certification by CompTIA is a powerful credential helping IT professionals, worldwide, ignite their careers by proving knowledge needed to assemble elements based on install, customer requirements, configuration and maintenance of software as well as PCs and devices for end users. Students will also gain an understanding of the basics of security, forensics and networking and finally learn to safely and properly diagnose, document and resolve common software and hardware issues while applying troubleshooting expertise. This course prepares students for the CompTIA A+ Certification exams 220-802 and 220-801.

    Read more...

  • Certification at Your Fingertips - Microsoft 70-413: Designing and Implementing a Server Infrastructure

    Certification at Your Fingertips - Microsoft 70-413: Designing and Implementing a Server Infrastructure

    SGD $299.00

    Course Description

    This course covers the following topics in order to prepare students for the Microsoft 70-413: Designing and Implementing a Server Infrastructure exam: how to plan and deploy a server infrastructure, design and implement network infrastructure services, design and implement network access services, design and implement an Active Directory infrastructure (logical), and design and implement an Active Directory infrastructure (physical). Be fully prepared for your certifications exams! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Learn and understand the chapters for each tailored certification  - Go through past questions to have a feel of the examinations

    Read more...


Content

Welcome

Preview Available

+

SQL Server Basics

Database Types

Terminology

SQL Server 2012 Certification

About the 70-463 Exam

Introduction

Course Overview

Getting Set Up

+

System Hardware Requirements

System Software Requirements

Getting the Software

Installing SQL Server 2012 pt. 1

Installing SQL Server 2012 pt. 2

Installing SQL Server 2012 pt. 3

Verifying the Installation

Attaching the Sample Database pt. 1

Attaching the Sample Database pt. 2

Exploring the Sample Database

Downloading Books Online

TechNet and MSDN

Data Warehouse Basics

+

Data Usage Challenges

Understanding Normalization

Normalized Structure Challenges

Star Schema Basics

Snowflake Schema Basics

Understanding Granularity

Auditing and Lineage

Simple DW Example

Creating a Data Warehouse

+

Understanding Fact Tables

Understanding Dimensions pt. 1

Understanding Dimensions pt. 2

Dimension Column Types

Understanding SCDs pt. 1

Understanding SCDs pt. 2

Understanding SCDs pt. 3

Creating Our DW Database

Identifying Our Dimensions

Identifying Our Fact Table

Understanding Indexes

Indexing the Data Warehouse

Understanding Indexed Views

Creating an Indexed View

Understanding Data Compression

Using Partitions

Data Lineage pt. 1

Data Lineage pt. 2

Creating Our Dimensions

Creating Our Fact Table

Creating Our Relationships

Data Flow Using SSIS

+

SSIS Basics

Getting SQL Server Data Tools

Getting Visual Studio

Using the Import Export Wizard

SSIS Development Overview

Data Movement Planning

Simple SSIS Example pt. 1

Simple SSIS Example pt. 2

Using Connection Managers

Data and Control Flow

Understanding Containers

Understanding Groups

Data Conversion Task

Customer Dimension Load Considerations

Loading the Customer Dimension pt. 1

Loading the Customer Dimension pt. 2

Loading the Customer Dimension pt. 3

Loading the FactInternetSales Table pt. 1

Loading the FactInternetSales Table pt. 2

Design and Implement Data Flow

+

Creating a Data Flow Task

Data Flow Source Adapters

Data Flow Destination Adapters

Row or Batch Processing

Advanced Control Flow

+

Using Variables pt. 1

Using Variables pt. 2

Understanding Variable Scope

Property Parameterization pt. 1

Property Parameterization pt. 2

Parameters vs. Variables

Understanding Expressions pt. 1

Understanding Expressions pt. 2

Package and Task Transactions pt. 1

Package and Task Transactions pt. 2

Data Services

+

Data Quality Services Overview

Implementing DQS

Master Data Services Overview

Custom Code in SSIS

+

Script Task Basics

Using a Script pt. 1

Using a Script pt. 2

Using a Script pt. 3

Configuring Script Tools

Deploying Packages

+

Deploying SSIS Packages

Creating the SSISDB Catalog

Deploying a Project

Executing a Package

Scheduling a Package

Conclusion

+
Resource Files

Course Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.