Implementing Data Warehouse MS SQL 2012

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More

Important information

Typology Course
Methodology Online
  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,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.

Opinions

There are no opinions on this course yet

What you'll learn on the course

SQL

Course programme

Course Preview
  • Implementing a Data Warehouse with SQL Server 2012 (Exam 70-463)
    • Lesson 00 - Course Overview
      • 0.1 Course Overview
      • 0.2 Table of Contents
      • 0.3 Objectives
      • 0.4 Course Overview
      • 0.5 Course Overview (contd.)
      • 0.6 Value of Implementing a Data Warehouse for Professionals
      • 0.7 Value of Implementing a Data Warehouse for Organizations
      • 0.8 Lessons Covered
      • 0.9 Exam Pattern
      • 0.10 Implementing a Data Warehouse with SQL Server Certification
      • 0.11 Sources of Information
      • 0.12 Conclusion
    • Lesson 1 - Introduction to Data Warehouses
      • 1.1 Introduction
      • 1.2 Objectives
      • 1.3 Data Warehouses
      • 1.4 Data Warehouse
      • 1.5 Database vs. Data Warehouse
      • 1.6 Need for Data Warehouses
      • 1.7 Implementing Data Warehouses in SQL Server 2012
      • 1.8 Data Warehousing Concepts
      • 1.9 Star Schema
      • 1.10 Star Schema—Uses
      • 1.11 Dimensions
      • 1.12 Facts
      • 1.13 Keys
      • 1.14 Other Schemas
      • 1.15 Exploring an OLTP Database and its Data Warehouse
      • 1.16 Exploring an OLTP Database and its Data Warehouse Demo 01
      • 1.17 Introduction to ETL
      • 1.18 Process of Extract-Transform-Load ( ETL )
      • 1.19 Quiz
      • 1.20 Summary
      • 1.21 Conclusion
    • Lesson 2 - Dimension Tables
      • 2.1 Dimension Tables
      • 2.2 Objectives
      • 2.3 Use and Types of Dimensions
      • 2.4 Dimension Tables
      • 2.5 Standalone Dimensions
      • 2.6 Shared or Conformed Dimensions
      • 2.7 Create a new Dimension
      • 2.8 Create a new Dimension Demo 01
      • 2.9 Attributes and Hierarchies
      • 2.10 Attributes
      • 2.11 Hierarchies
      • 2.12 Denormalized Dimension Hierarchy
      • 2.13 Normalized Snowflake Dimensions
      • 2.14 Self Referencing Tables
      • 2.15 Granularity
      • 2.16 Exploring Attributes and Hierarchies
      • 2.17 Exploring Attributes and Hierarchies Demo 02
      • 2.18 Understanding Granularity
      • 2.19 Understanding Granularity Demo 03
      • 2.20 Historical Data
      • 2.21 Historical Data
      • 2.22 Slowly Changing Dimensions
      • 2.23 SCD Type 1
      • 2.24 SCD Type 2
      • 2.25 SCD Type 3
      • 2.26 Data Lineage
      • 2.27 ETL For Loading Dimensions
      • 2.28 Understanding SCD Type 2
      • 2.29 Understanding SCD Type 2 Demo 04
      • 2.30 Quiz
      • 2.31 Summary
      • 2.32 Conclusion
    • Lesson 3 - Fact Tables
      • 3.1 Fact Table
      • 3.2 Objectives
      • 3.3 Facts and Measures
      • 3.4 Measures
      • 3.5 Properties of Measures
      • 3.6 Steps of Implementing a Fact Table
      • 3.7 Steps for Loading Data into Fact Tables
      • 3.8 Creating and Exploring a Fact Table
      • 3.9 Creating and Exploring a Fact Table Demo 01
      • 3.10 Fact Table Indexing
      • 3.11 Indexing Fact Tables
      • 3.12 Type of Indexes
      • 3.13 Storage of Fact Tables
      • 3.14 Creating ColumnStore Indexes
      • 3.15 Fact Table Lineage
      • 3.16 Fact Table Lineage Demo 02
      • 3.17 Using an Audit Dimension
      • 3.18 Using an Audit Dimension Demo 03
      • 3.19 Quiz
      • 3.20 Summary
      • 3.21 Summary (contd.)
      • 3.22 Conclusion
    • Lesson 4 - Concepts Involved in Implementing a Data Warehouse with SQL Server 2012
      • 4.1 Concepts Involved in Implementing a Data Warehouse with SQL Server 2012
      • 4.2 Objectives
      • 4.3 Roles of SQL Server Components
      • 4.4 Database Engine for Data Warehousing
      • 4.5 SQL Server Integration Services
      • 4.6 SSIS - Introduction
      • 4.7 SSIS - Components
      • 4.8 SSIS Deployment Architecture
      • 4.9 Deployment - Shared
      • 4.10 Deployment - Dedicated
      • 4.11 SSIS Installation and Implementation Requirements
      • 4.12 Implementing SSIS Requirements
      • 4.13 32-bit vs. 64-bit
      • 4.14 Installing SSIS
      • 4.15 Installing SSIS Demo 01
      • 4.16 Quiz
      • 4.17 Summary
      • 4.18 Conclusion
    • Lesson 5 - SSIS Overview for ETL
      • 5.1 SSIS Overview for ETL
      • 5.2 Objectives
      • 5.3 Understanding the Structure of SSIS
      • 5.4 Structure of SSIS
      • 5.5 SSIS Project
      • 5.6 SSIS Package
      • 5.7 Connection Manager
      • 5.8 Project and Package Level Connection Managers
      • 5.9 Connection Strings and Properties of Connection Manager
      • 5.10 SSIS Catalog
      • 5.11 Setting up a SSIS Catalog
      • 5.12 Setting up a SSIS Catalog Demo 01
      • 5.13 Creating a New SSIS Project
      • 5.14 Creating a New SSIS Project Demo 02
      • 5.15 Adding a Connection Manager
      • 5.16 Adding a Connection Manager Demo 03
      • 5.17 Advanced SSIS Projects
      • 5.18 Parameterization
      • 5.19 Package Type
      • 5.20 Package Transactions
      • 5.21 Transaction Support Matrix
      • 5.22 Viewing and Changing Connection String Parameters
      • 5.23 Viewing and Changing Connection String Parameters Demo 04
      • 5.24 Quiz
      • 5.25 Summary
      • 5.26 Summary (contd.)
      • 5.27 Conclusion
    • Lesson 6 - Understanding SSIS Control Flow
      • 6.1 Understanding SSIS Control Flow
      • 6.2 Objectives
      • 6.3 Understanding the Control Flow of SSIS
      • 6.4 SSIS Control Flow - Introduction
      • 6.5 Control Flow Designer Surface
      • 6.6 Control Flow - Elements
      • 6.7 Working with Tasks in Control Flow
      • 6.8 Tasks
      • 6.9 Task Categories
      • 6.10 Adding Tasks to a Control Flow
      • 6.11 Adding Tasks to a Control Flow Demo 01
      • 6.12 Understanding Containers and Constraints
      • 6.13 Containers
      • 6.14 Sequence Container
      • 6.15 For Loop Container
      • 6.16 Foreach Loop Container
      • 6.17 Constraints
      • 6.18 Types of Constraints
      • 6.19 Adding a Container to the Control Flow
      • 6.20 Adding a Container to the Control Flow Demo 02
      • 6.21 Adding Constraints to a Control Flow
      • 6.22 Adding Constraints to a Control Flow Demo 03
      • 6.23 Using Event Handlers and Other Properties
      • 6.24 Event Handlers
      • 6.25 Event Bubbling
      • 6.26 Checkpoint
      • 6.27 Checkpoint (contd.)
      • 6.28 Parallelism
      • 6.29 Using Event Handlers
      • 6.30 Using Event Handlers Demo 04
      • 6.31 Quiz
      • 6.32 Summary
      • 6.33 Summary (contd.)
      • 6.34 Conclusion
    • Lesson 7 - Working with Variables
      • 7.1 Working with Variables
      • 7.2 Objectives
      • 7.3 Understanding variables in SSIS
      • 7.4 Variables
      • 7.5 Variable - Properties
      • 7.6 Creating variables
      • 7.7 Variable - Data Types
      • 7.8 Scope of Variables
      • 7.9 Creating New Variables
      • 7.10 Creating new variables Demo 01
      • 7.11 System Variables and Expressions
      • 7.12 SSIS System Variables
      • 7.13 Expressions
      • 7.14 Precedence Constraints and Expressions
      • 7.15 Adding Expressions with User Variables
      • 7.16 Adding Expressions with User Variables Demo 02
      • 7.17 Creating Expressions with System Variables
      • 7.18 Creating Expressions with System Variables Demo 03
      • 7.19 Parameters in Packages and Projects
      • 7.20 Parameters
      • 7.21 Package Templates
      • 7.22 Package Configurations
      • 7.23 Parameterizing expressions
      • 7.24 Parameterizing expressions Demo 04
      • 7.25 Creating a custom package template
      • 7.26 Creating a custom package template Demo 05
      • 7.27 Using Configurations
      • 7.28 Using Configurations Demo 06
      • 7.29 Quiz
      • 7.30 summary
      • 7.31 Conclusion
    • Lesson 8 - Introduction to ETL
      • 8.1 Introduction to ETL
      • 8.2 Objectives
      • 8.3 ETL and the Data Flow Task
      • 8.4 Understanding the BI Process
      • 8.5 The Business Intelligence Process
      • 8.6 SSIS ETL Processing - The Data Flow Task
      • 8.7 Components of Data Flow
      • 8.8 Data Source Components
      • 8.9 Data Destination Components
      • 8.10 Data Transform Components
      • 8.11 Data Transform Components - Types
      • 8.12 Creating a new ETL Process using Data Flow
      • 8.13 Creating a new ETL Process using Data Flow Demo 01
      • 8.14 Transforms—Types
      • 8.15 Transforms in SSIS
      • 8.16 Lookup Transforms
      • 8.17 Using Lookup Transform
      • 8.18 Using Lookup Transform Demo 02
      • 8.19 Fuzzy Lookup Transform
      • 8.20 Using Fuzzy Lookup
      • 8.21 Using Fuzzy Lookup Demo 03
      • 8.22 Text Mining Transforms
      • 8.23 Using Text Mining
      • 8.24 Using Text Mining Demo 04
      • 8.25 SCD Transform
      • 8.26 Configure SCD Transform
      • 8.27 Configure SCD Transform Demo 05
      • 8.28 Scripting in SSIS Packages
      • 8.29 Data Cleaning
      • 8.30 Using Data Profiling
      • 8.31 Using Data Profiling Demo 06
      • 8.32 Data Quality Services
      • 8.33 Setting up and using DQS
      • 8.34 Setting up and using DQS Demo 07
      • 8.35 Quiz
      • 8.36 Summary
      • 8.37 Conclusion
    • Lesson 9 - Deploying and Managing Packages
      • 9.1 Deploying and Managing Packages
      • 9.2 Objectives
      • 9.3 Executing SSIS Packages
      • 9.4 SSIS Package Execution Methods
      • 9.5 Deployment options
      • 9.6 SQL Server Management Studio
      • 9.7 Deployment Utility
      • 9.8 Deploy and Execute Packages
      • 9.9 Deploy and Execute Packages Demo 01
      • 9.10 Create and Use a Deployment Utility
      • 9.11 Create and Use a Deployment Utility Demo 02
      • 9.12 Logging and Storing Packages
      • 9.13 Logging and Auditing
      • 9.14 Custom Logging
      • 9.15 Turn On Logging
      • 9.16 Turn On Logging Demo 03
      • 9.17 Quiz
      • 9.18 Summary
      • 9.19 Conclusion
    • Lesson 10 - Debugging and Securing Packages
      • 10.1 Debugging and Securing Packages
      • 10.2 Objectives
      • 10.3 Handling Errors and Notifying Operators
      • 10.4 Error Handling in Data Flow
      • 10.5 Alerts
      • 10.6 Notifications
      • 10.7 Debugging SSIS
      • 10.8 Breakpoints
      • 10.9 Control Flow Breakpoints
      • 10.10 Data Flow Breakpoints
      • 10.11 Debugging Control Flow
      • 10.12 Debugging Control Flow Demo 01
      • 10.13 Debugging Data Flow
      • 10.14 Debugging Data Flow Demo 02
      • 10.15 Package Security
      • 10.16 SSIS Security
      • 10.17 SSIS Security Roles
      • 10.18 Package Protection Levels
      • 10.19 Securing sensitive data in a package
      • 10.20 Securing sensitive data in a package Demo 03
      • 10.21 Quiz
      • 10.22 Summary
      • 10.23 Conclusion

Achievements for this centre

2016

Students that were interested in this course also looked at...
See all