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

  • Certification at Your Fingertips - Microsoft 70-342: Advanced Solutions of Exchange Server 2013

    Certification at Your Fingertips - Microsoft 70-342: Advanced Solutions of Exchange Server 2013

    SGD $299.00

    Course Description

    This course covers the following topics in order to prepare students for the Microsoft 70-342 Advanced Solutions of Exchange Server 2013 exam: how to configure, manage, and migrate unified messaging, how to design, configure, and manage site resiliency, how to design, configure, and manage advanced security, how to configure and manage compliance, archiving, and discovery solutions, and how to implement and manage coexistence, hybrid scenarios, migration, and federation. 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 theory aspects of the examination

    Read more...

  • Microsoft MCTS (70-640)

    Microsoft MCTS (70-640)

    SGD $40.00

    Course Description

    Achieving the Microsoft Server Administrator MCITP certification is a great way to prove your knowledge and skill level and help you stand out to employers. Microsoft's certifications are among the most recognized and respected in Information Technology. Achieving Microsoft Server Administrator MCITP certification requires you to pass three exams: MS 70-640 Configuring Active Directory, MS 70-642 Configuring Network Infrastructure and MS 70-646 Windows Server 2008 Server Administrator. In this course, Microsoft Certified Trainer Mark Long covers the topics that will be on the Microsoft Exam 70-640. You will learn about Active Directory, Group Policy, DNS, Certificate Services and much more as Mark guides you through many of the steps so you can follow along. He also explains the technologies and points out a number of exam topics to watch for, while directing you to more technical information for further study and preparation. 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...

  • Certification at Your Fingertips - Cisco 200-101: CCNA - ICND2 - Interconnecting Cisco Networking Devices Part 2

    Certification at Your Fingertips - Cisco 200-101: CCNA - ICND2 - Interconnecting Cisco Networking Devices Part 2

    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: This course is designed as preparation for the Cisco 200-101 ICND2 exam. The 200-101 Interconnecting Cisco Networking Devices Part 2 (ICND2) is the exam associated with the CCNA Routing and Switching certification. The exam tests a candidate's knowledge and skills required to successfully install, operate, and troubleshoot a small to medium-size enterprise branch network.  This course comes with a Simulated 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.  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 Simulated Practice Environment

    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.