Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • Training for Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam 70-463
  • 15 Hrs of High Quality e-Learning content
  • 3 SQL Server 2012 Simulation Exams
  • 40 Demos
  • 30 End of Chapter Quizzes
  • Exam Tips and Techniques

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

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

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

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.

Contact Us

+1-844-532-7688

(Toll Free)

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line