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 to certification: SQL Server 2014 (70-464)

    1st step to certification: SQL Server 2014 (70-464)

    SGD $45.00

    Course Description

    SQL Server is the foundation of Microsoft's comprehensive data platform. SQL Server 2014, the latest version, introduces new in-memory capabilities and other improvements are gaining a lot of attention in the database world. SQL Server 2014 will continue the explosive growth in this product, create more and more opportunities for those holding certifications on the Microsoft Data Platform. In this course, Mark Long brings his 20+ years of experience with SQL Server to you as he helps you prepare for Microsoft's 70-464 Developing Microsoft SQL Server Databases certification exam. 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 - ITIL Services Operations

    Certification at Your Fingertips - ITIL Services Operations

    SGD $299.00

    Course Description

    The objective of ITIL Service Operation is to make sure that IT services are delivered effectively and efficiently. The Service Operation lifecycle stage includes the fulfilling of user requests, resolving service failures, fixing problems, as well as carrying out routine operational tasks. Service Operation focuses on delivery and control process activities and aims for a steady state of managing services. Understand the importance of Service Delivery.  - Know what is ITIL Service Operations  - Understand the various process level in ITIL  - Be able to apply the knowledge into actual projects  - Understand the key role of ITIL Service Operations 

    Read more...

  • Certification at Your Fingertips - Microsoft 70 -685 Pro: Windows 7, Enterprise Desktop Support Technician

    Certification at Your Fingertips - Microsoft 70 -685 Pro: Windows 7, Enterprise Desktop Support Technician

    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 covers the following topics in order to prepare students for the Microsoft 70-685 Pro: Windows 7, Enterprise Desktop Support Technician exam: Identifying cause of and resolving desktop application issues, identifying cause of and resolving networking issues, managing and maintaining systems that run Windows 7 client, supporting mobile users. and identifying cause of and resolving security issues. Be fully prepared for the examinations with the correct knowledge and skills in order to ace the examination.   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

    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.