Course description

  • What is the course all about?

    Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world. Simplilearn’s Implementing a Data Warehouse with SQL Server 2012 course introduces you to the key components of a data warehousing solution.

    The course provides learners with the technical skills required to design and implement a data warehouse. It also provides information on automating an ETL solution using SQL Server Integration Services. This course will help current and aspiring data professionals to prepare for exam 70-463, known as Implementing a Data Warehouse with SQL Server 2012.

  • What learning benefits do you get from Simplilearn’s training?

    Simplilearn’s training provides you the knowledge and skills to:
    • Create and manage data warehouse
    • Design and implement dimensions
    • Work with variables
    • Implement and automate ETL solution
    • Deploy and manage packages
    • Debug and secure packages
    The course will help you understand the implementation of data warehouse with SQL Server 2012. You will learn to design and implement a data warehouse. You will see how to install SSIS, create dimensions, add tasks to control flow, explore attributes and hierarchies, and so on.

    Simplilearn’s training breaks up the course material into 10 easy-to-follow modules that cover the course-level objectives. Further, demos are provided for all the major concepts covered in a lesson so that participants understand how the steps learned are implemented in real time.

  • What are the career benefits in-store for you?

    Passing the Implementing a Data Warehouse with SQL Server 2012 (70-463) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieving an MCSE certification.

    In high-growth industries, entry-level employees with a Microsoft Certified Solutions Associate (MCSA) certification can annually earn up to $16,000 more than their non-certified peers.

    Better job opportunities also await them.

  • Why Simplilearn?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course preview

    • Lesson 00 - Course Overview

      05:42
      • 0.1 Course Overview
        00:50
      • 0.2 Table of Contents
        00:41
      • 0.3 Objectives
        00:43
      • 0.4 Course Overview
        00:32
      • 0.5 Course Overview (contd.)
        00:30
      • 0.6 Value of Implementing a Data Warehouse for Professionals
        00:45
      • 0.7 Value of Implementing a Data Warehouse for Organizations
        00:33
      • 0.8 Lessons Covered
        00:12
      • 0.9 Exam Pattern
        00:24
      • 0.10 Implementing a Data Warehouse with SQL Server Certification
        00:15
      • 0.11 Sources of Information
        00:09
      • 0.12 Conclusion
        00:08
    • Lesson 1 - Introduction to Data Warehouses

      30:19
      • 1.1 Introduction
        00:25
      • 1.2 Objectives
        00:20
      • 1.3 Data Warehouses
        00:14
      • 1.4 Data Warehouse
        03:21
      • 1.5 Database vs. Data Warehouse
        04:13
      • 1.6 Need for Data Warehouses
        02:58
      • 1.7 Implementing Data Warehouses in SQL Server 2012
        00:42
      • 1.8 Data Warehousing Concepts
        00:24
      • 1.9 Star Schema
        01:50
      • 1.10 Star Schema—Uses
        01:58
      • 1.11 Dimensions
        02:57
      • 1.12 Facts
        01:23
      • 1.13 Keys
        01:54
      • 1.14 Other Schemas
        01:56
      • 1.15 Exploring an OLTP Database and its Data Warehouse
        00:10
      • 1.16 Exploring an OLTP Database and its Data Warehouse Demo 01
        02:27
      • 1.17 Introduction to ETL
        00:17
      • 1.18 Process of Extract-Transform-Load ( ETL )
        01:58
      • 1.19 Quiz
      • 1.20 Summary
        00:45
      • 1.21 Conclusion
        00:07
    • Lesson 2 - Dimension Tables

      39:54
      • 2.1 Dimension Tables
        00:23
      • 2.2 Objectives
        00:18
      • 2.3 Use and Types of Dimensions
        00:13
      • 2.4 Dimension Tables
        01:22
      • 2.5 Standalone Dimensions
        01:11
      • 2.6 Shared or Conformed Dimensions
        01:42
      • 2.7 Create a new Dimension
        00:09
      • 2.8 Create a new Dimension Demo 01
        02:28
      • 2.9 Attributes and Hierarchies
        00:18
      • 2.10 Attributes
        01:18
      • 2.11 Hierarchies
        02:01
      • 2.12 Denormalized Dimension Hierarchy
        00:51
      • 2.13 Normalized Snowflake Dimensions
        01:41
      • 2.14 Self Referencing Tables
        01:09
      • 2.15 Granularity
        02:33
      • 2.16 Exploring Attributes and Hierarchies
        00:08
      • 2.17 Exploring Attributes and Hierarchies Demo 02
        02:50
      • 2.18 Understanding Granularity
        00:09
      • 2.19 Understanding Granularity Demo 03
        01:57
      • 2.20 Historical Data
        00:16
      • 2.21 Historical Data
        02:57
      • 2.22 Slowly Changing Dimensions
        01:28
      • 2.23 SCD Type 1
        01:00
      • 2.24 SCD Type 2
        03:25
      • 2.25 SCD Type 3
        01:58
      • 2.26 Data Lineage
        00:38
      • 2.27 ETL For Loading Dimensions
        01:33
      • 2.28 Understanding SCD Type 2
        00:08
      • 2.29 Understanding SCD Type 2 Demo 04
        02:58
      • 2.30 Quiz
      • 2.31 Summary
        00:46
      • 2.32 Conclusion
        00:06
    • Lesson 3 - Fact Tables

      24:09
      • 3.1 Fact Table
        00:24
      • 3.2 Objectives
        00:36
      • 3.3 Facts and Measures
        00:14
      • 3.4 Measures
        01:05
      • 3.5 Properties of Measures
        02:09
      • 3.6 Steps of Implementing a Fact Table
        01:00
      • 3.7 Steps for Loading Data into Fact Tables
        01:19
      • 3.8 Creating and Exploring a Fact Table
        00:11
      • 3.9 Creating and Exploring a Fact Table Demo 01
        03:40
      • 3.10 Fact Table Indexing
        00:11
      • 3.11 Indexing Fact Tables
        02:31
      • 3.12 Type of Indexes
        02:06
      • 3.13 Storage of Fact Tables
        01:34
      • 3.14 Creating ColumnStore Indexes
        01:12
      • 3.15 Fact Table Lineage
        00:07
      • 3.16 Fact Table Lineage Demo 02
        01:50
      • 3.17 Using an Audit Dimension
        00:07
      • 3.18 Using an Audit Dimension Demo 03
        02:14
      • 3.19 Quiz
      • 3.20 Summary
        00:40
      • 3.21 Summary (contd.)
        00:47
      • 3.22 Conclusion
        00:12
    • Lesson 4 - Concepts Involved in Implementing a Data Warehouse with SQL Server 2012

      19:37
      • 4.1 Concepts Involved in Implementing a Data Warehouse with SQL Server 2012
        00:26
      • 4.2 Objectives
        00:26
      • 4.3 Roles of SQL Server Components
        00:18
      • 4.4 Database Engine for Data Warehousing
        01:12
      • 4.5 SQL Server Integration Services
        01:13
      • 4.6 SSIS - Introduction
        00:19
      • 4.7 SSIS - Components
        02:18
      • 4.8 SSIS Deployment Architecture
        02:33
      • 4.9 Deployment - Shared
        00:58
      • 4.10 Deployment - Dedicated
        00:50
      • 4.11 SSIS Installation and Implementation Requirements
        00:16
      • 4.12 Implementing SSIS Requirements
        01:27
      • 4.13 32-bit vs. 64-bit
        02:45
      • 4.14 Installing SSIS
        00:08
      • 4.15 Installing SSIS Demo 01
        03:24
      • 4.16 Quiz
      • 4.17 Summary
        00:53
      • 4.18 Conclusion
        00:11
    • Lesson 5 - SSIS Overview for ETL

      27:20
      • 5.1 SSIS Overview for ETL
        00:27
      • 5.2 Objectives
        00:38
      • 5.3 Understanding the Structure of SSIS
        00:17
      • 5.4 Structure of SSIS
        01:23
      • 5.5 SSIS Project
        01:29
      • 5.6 SSIS Package
        02:01
      • 5.7 Connection Manager
        02:21
      • 5.8 Project and Package Level Connection Managers
        01:24
      • 5.9 Connection Strings and Properties of Connection Manager
        01:24
      • 5.10 SSIS Catalog
        01:30
      • 5.11 Setting up a SSIS Catalog
        00:06
      • 5.12 Setting up a SSIS Catalog Demo 01
        01:05
      • 5.13 Creating a New SSIS Project
        00:10
      • 5.14 Creating a New SSIS Project Demo 02
        01:05
      • 5.15 Adding a Connection Manager
        00:09
      • 5.16 Adding a Connection Manager Demo 03
        01:48
      • 5.17 Advanced SSIS Projects
        00:12
      • 5.18 Parameterization
        01:55
      • 5.19 Package Type
        00:59
      • 5.20 Package Transactions
        01:58
      • 5.21 Transaction Support Matrix
        01:29
      • 5.22 Viewing and Changing Connection String Parameters
        00:07
      • 5.23 Viewing and Changing Connection String Parameters Demo 04
        01:48
      • 5.24 Quiz
      • 5.25 Summary
        00:45
      • 5.26 Summary (contd.)
        00:38
      • 5.27 Conclusion
        00:12
    • Lesson 6 - Understanding SSIS Control Flow

      41:41
      • 6.1 Understanding SSIS Control Flow
        00:26
      • 6.2 Objectives
        00:39
      • 6.3 Understanding the Control Flow of SSIS
        00:14
      • 6.4 SSIS Control Flow - Introduction
        01:07
      • 6.5 Control Flow Designer Surface
        02:21
      • 6.6 Control Flow - Elements
        01:21
      • 6.7 Working with Tasks in Control Flow
        00:07
      • 6.8 Tasks
        01:45
      • 6.9 Task Categories
        02:18
      • 6.10 Adding Tasks to a Control Flow
        00:08
      • 6.11 Adding Tasks to a Control Flow Demo 01
        04:07
      • 6.12 Understanding Containers and Constraints
        00:24
      • 6.13 Containers
        01:12
      • 6.14 Sequence Container
        01:09
      • 6.15 For Loop Container
        02:30
      • 6.16 Foreach Loop Container
        01:44
      • 6.17 Constraints
        01:19
      • 6.18 Types of Constraints
        01:32
      • 6.19 Adding a Container to the Control Flow
        00:07
      • 6.20 Adding a Container to the Control Flow Demo 02
        02:01
      • 6.21 Adding Constraints to a Control Flow
        00:11
      • 6.22 Adding Constraints to a Control Flow Demo 03
        00:42
      • 6.23 Using Event Handlers and Other Properties
        00:15
      • 6.24 Event Handlers
        01:12
      • 6.25 Event Bubbling
        02:48
      • 6.26 Checkpoint
        01:32
      • 6.27 Checkpoint (contd.)
        01:50
      • 6.28 Parallelism
        01:52
      • 6.29 Using Event Handlers
        00:06
      • 6.30 Using Event Handlers Demo 04
        03:08
      • 6.31 Quiz
      • 6.32 Summary
        00:37
      • 6.33 Summary (contd.)
        00:48
      • 6.34 Conclusion
        00:09
    • Lesson 7 - Working with Variables

      34:12
      • 7.1 Working with Variables
        00:26
      • 7.2 Objectives
        00:23
      • 7.3 Understanding variables in SSIS
        00:13
      • 7.4 Variables
        01:16
      • 7.5 Variable - Properties
        02:43
      • 7.6 Creating variables
        01:05
      • 7.7 Variable - Data Types
        00:36
      • 7.8 Scope of Variables
        00:56
      • 7.9 Creating New Variables
        00:06
      • 7.10 Creating new variables Demo 01
        02:38
      • 7.11 System Variables and Expressions
        00:14
      • 7.12 SSIS System Variables
        01:36
      • 7.13 Expressions
        01:12
      • 7.14 Precedence Constraints and Expressions
        01:22
      • 7.15 Adding Expressions with User Variables
        00:07
      • 7.16 Adding Expressions with User Variables Demo 02
        04:43
      • 7.17 Creating Expressions with System Variables
        00:07
      • 7.18 Creating Expressions with System Variables Demo 03
        01:09
      • 7.19 Parameters in Packages and Projects
        00:12
      • 7.20 Parameters
        02:04
      • 7.21 Package Templates
        01:19
      • 7.22 Package Configurations
        01:13
      • 7.23 Parameterizing expressions
        00:09
      • 7.24 Parameterizing expressions Demo 04
        01:52
      • 7.25 Creating a custom package template
        00:09
      • 7.26 Creating a custom package template Demo 05
        01:23
      • 7.27 Using Configurations
        00:08
      • 7.28 Using Configurations Demo 06
        03:33
      • 7.29 Quiz
      • 7.30 summary
        01:08
      • 7.31 Conclusion
        00:10
    • Lesson 8 - Introduction to ETL

      53:07
      • 8.1 Introduction to ETL
        00:21
      • 8.2 Objectives
        00:26
      • 8.3 ETL and the Data Flow Task
        00:20
      • 8.4 Understanding the BI Process
        01:22
      • 8.5 The Business Intelligence Process
        01:36
      • 8.6 SSIS ETL Processing - The Data Flow Task
        01:42
      • 8.7 Components of Data Flow
        01:03
      • 8.8 Data Source Components
        00:57
      • 8.9 Data Destination Components
        00:51
      • 8.10 Data Transform Components
        01:13
      • 8.11 Data Transform Components - Types
        03:17
      • 8.12 Creating a new ETL Process using Data Flow
        00:10
      • 8.13 Creating a new ETL Process using Data Flow Demo 01
        03:26
      • 8.14 Transforms—Types
        00:14
      • 8.15 Transforms in SSIS
        00:39
      • 8.16 Lookup Transforms
        00:57
      • 8.17 Using Lookup Transform
        00:05
      • 8.18 Using Lookup Transform Demo 02
        03:13
      • 8.19 Fuzzy Lookup Transform
        02:10
      • 8.20 Using Fuzzy Lookup
        00:07
      • 8.21 Using Fuzzy Lookup Demo 03
        03:03
      • 8.22 Text Mining Transforms
        01:00
      • 8.23 Using Text Mining
        00:05
      • 8.24 Using Text Mining Demo 04
        01:36
      • 8.25 SCD Transform
        01:15
      • 8.26 Configure SCD Transform
        00:08
      • 8.27 Configure SCD Transform Demo 05
        03:06
      • 8.28 Scripting in SSIS Packages
        01:22
      • 8.29 Data Cleaning
        00:53
      • 8.30 Using Data Profiling
        00:08
      • 8.31 Using Data Profiling Demo 06
        03:20
      • 8.32 Data Quality Services
        01:10
      • 8.33 Setting up and using DQS
        00:07
      • 8.34 Setting up and using DQS Demo 07
        10:42
      • 8.35 Quiz
      • 8.36 Summary
        00:53
      • 8.37 Conclusion
        00:10
    • Lesson 9 - Deploying and Managing Packages

      19:37
      • 9.1 Deploying and Managing Packages
        00:25
      • 9.2 Objectives
        00:21
      • 9.3 Executing SSIS Packages
        00:15
      • 9.4 SSIS Package Execution Methods
        01:27
      • 9.5 Deployment options
        01:40
      • 9.6 SQL Server Management Studio
        01:19
      • 9.7 Deployment Utility
        00:39
      • 9.8 Deploy and Execute Packages
        00:10
      • 9.9 Deploy and Execute Packages Demo 01
        03:33
      • 9.10 Create and Use a Deployment Utility
        00:09
      • 9.11 Create and Use a Deployment Utility Demo 02
        02:31
      • 9.12 Logging and Storing Packages
        00:14
      • 9.13 Logging and Auditing
        01:17
      • 9.14 Custom Logging
        01:22
      • 9.15 Turn On Logging
        00:06
      • 9.16 Turn On Logging Demo 03
        03:13
      • 9.17 Quiz
      • 9.18 Summary
        00:47
      • 9.19 Conclusion
        00:09
    • Lesson 10 - Debugging and Securing Packages

      21:56
      • 10.1 Debugging and Securing Packages
        00:27
      • 10.2 Objectives
        00:22
      • 10.3 Handling Errors and Notifying Operators
        00:15
      • 10.4 Error Handling in Data Flow
        01:36
      • 10.5 Alerts
        00:44
      • 10.6 Notifications
        00:28
      • 10.7 Debugging SSIS
        00:15
      • 10.8 Breakpoints
        01:08
      • 10.9 Control Flow Breakpoints
        01:28
      • 10.10 Data Flow Breakpoints
        00:50
      • 10.11 Debugging Control Flow
        00:05
      • 10.12 Debugging Control Flow Demo 01
        02:40
      • 10.13 Debugging Data Flow
        00:05
      • 10.14 Debugging Data Flow Demo 02
        02:46
      • 10.15 Package Security
        00:10
      • 10.16 SSIS Security
        01:07
      • 10.17 SSIS Security Roles
        01:23
      • 10.18 Package Protection Levels
        01:52
      • 10.19 Securing sensitive data in a package
        00:08
      • 10.20 Securing sensitive data in a package Demo 03
        03:16
      • 10.21 Quiz
      • 10.22 Summary
        00:42
      • 10.23 Conclusion
        00:09
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • What are the eligibility requirements to take the 70-463 exam?

    There are no eligibility requirements to take up this course. Register at the Microsoft website and select your exam to schedule with Pearson VUE.

  • Who should take this exam?

    This exam is targeted at database professionals whose primary duties involve installation, configuration, and maintenance tasks.

  • Why is this exam popular?

    SQL Server 2012 is a powerful platform that is widely used in the enterprise and cloud. Many critical systems are based on it. Exam 70-463 is part of a series of certifications that can make you a master of this platform.

Reviews

Hazel Hunt
Hazel Hunt

Simplilearn’s training was explained in a structured manner which made it easy to grasp.

Willow Hicks
Willow Hicks

I am very pleased with the training provided by Simplilearn. Thank you for the help.

Reese Dixon
Reese Dixon

This course from Simplilearn has been a great help for a professional like me as it covers a spectrum of topics in MS SQL and prepares for a better understanding of SQL server which comes in handy in future.

Read more Read less

    FAQs

    • How do I enroll for the Online training?

      You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
      1. Visa debit/credit card
      2. American express and Diners club card
      3. Master Card, or
      4. Through PayPal

    • What will I get along with this training?

      You will have access to the online e-learning and practice tests along with the training.

    • Can I cancel my enrollment? Do I get a refund?

      Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • Where and how can I access the e-learning content? Are there any limitations?

      Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

    • I am not able to access the online course. Whom should I contact for a solution?

      Please raise a request via our Help and Support portal to have your issue resolved.

    • Do you provide money back guarantee for the training programs?

      Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • I want to know more about the training program. Whom do I contact?

      Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.