Quality Seal Emagister EMAGISTER CUM LAUDE

Implementing Data Warehouse MS SQL 2012

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • 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.

Important information

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

Compare this course with other similar courses
See all