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

  • Enterprise Blockchain Bootcamp

    Enterprise Blockchain Bootcamp

    SGD $74.98

    Course Description

    So if your a customer facing technical sales expert focused on driving revenue then this course will help enable you get started talking blockchain. The course would also be helpful to sales executives, Technical Account Managers and IT Managers As a past solutions engineer, pre sales engineer and professional services engineer for companies such as HP 3PAR, HDS Federal (Vion), Brocade Communications and Dimension Data one thing I know well is how to sell solutions. Blockchain is going to part of the enterprise so knowing it could be critical if your part of a high volume VAR, Integrator or Vendor.

    Read more...

  • Certification at Your Fingertips - Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

    Certification at Your Fingertips - Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

    SGD $589.00

    Course Description

    Practice Lab  This course comes with a Remote Practice Environment, a virtual remote environment; where you are able to practically apply the skills you have learned on the respective server, systems and networks. With this platform, get one step ahead in your preparation for your certification exams! Whether it’s Cisco, Microsoft or VMware, our Practice Lab unifies access to all of these vendors through a web browser interface. Pre-configured hardware layouts with accompanying lab guides for fast, convenient access to gain hands on experience. With step-by-step instructions covering thousands of practical tasks across Cisco, Microsoft, VMware and CompTIA exam titles, the Practice Lab makes studying for an exam or learning new technologies an engaging experience. What this course prepares you for: Prepare for your Microsoft 70-466: Implementing Data Models and Reports with SQL Server 2012 exam whit his course. This course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining. Ace your certification examination with this preparation course! - Learn of the examination outline before sitting for your certification  - Know and understand the topics that may be covered in your examinations - Understand both practical and theory aspects of the examination - Apply the practical skills through the Remote Practice Environment This course is SkillsFuture Credit Eligible.

    Read more...

  • 1st step to certification: CompTIA Linux+ (LX0-101)

    1st step to certification: CompTIA Linux+ (LX0-101)

    SGD $54.00

    Course Description

    Veteran VTC instructor Bobby Rogers guides you through an in-depth review of the Linux+ LX0-101 exam from a very practical, hands-on perspective. This course provides step-by-step demonstrations of the different commands, utilities, and configuration options you really need to know before taking the exam. Bobby covers all domains and objectives required for the exam, including installation, hardware configuration, package management, and file management. 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.