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 Overview00:50
      • 0.2 Table of Contents00:41
      • 0.3 Objectives00:43
      • 0.4 Course Overview00:32
      • 0.5 Course Overview (contd.)00:30
      • 0.6 Value of Implementing a Data Warehouse for Professionals00:45
      • 0.7 Value of Implementing a Data Warehouse for Organizations00:33
      • 0.8 Lessons Covered00:12
      • 0.9 Exam Pattern00:24
      • 0.10 Implementing a Data Warehouse with SQL Server Certification00:15
      • 0.11 Sources of Information00:09
      • 0.12 Conclusion00:08
    • Lesson 1 - Introduction to Data Warehouses 30:19
      • 1.1 Introduction00:25
      • 1.2 Objectives00:20
      • 1.3 Data Warehouses00:14
      • 1.4 Data Warehouse03:21
      • 1.5 Database vs. Data Warehouse04:13
      • 1.6 Need for Data Warehouses02:58
      • 1.7 Implementing Data Warehouses in SQL Server 201200:42
      • 1.8 Data Warehousing Concepts00:24
      • 1.9 Star Schema01:50
      • 1.10 Star Schema—Uses01:58
      • 1.11 Dimensions02:57
      • 1.12 Facts01:23
      • 1.13 Keys01:54
      • 1.14 Other Schemas01:56
      • 1.15 Exploring an OLTP Database and its Data Warehouse00:10
      • 1.16 Exploring an OLTP Database and its Data Warehouse Demo 0102:27
      • 1.17 Introduction to ETL00:17
      • 1.18 Process of Extract-Transform-Load ( ETL )01:58
      • 1.19 Quiz
      • 1.20 Summary00:45
      • 1.21 Conclusion00:07
    • Lesson 2 - Dimension Tables 39:54
      • 2.1 Dimension Tables00:23
      • 2.2 Objectives00:18
      • 2.3 Use and Types of Dimensions00:13
      • 2.4 Dimension Tables01:22
      • 2.5 Standalone Dimensions01:11
      • 2.6 Shared or Conformed Dimensions01:42
      • 2.7 Create a new Dimension00:09
      • 2.8 Create a new Dimension Demo 0102:28
      • 2.9 Attributes and Hierarchies00:18
      • 2.10 Attributes01:18
      • 2.11 Hierarchies02:01
      • 2.12 Denormalized Dimension Hierarchy00:51
      • 2.13 Normalized Snowflake Dimensions01:41
      • 2.14 Self Referencing Tables01:09
      • 2.15 Granularity02:33
      • 2.16 Exploring Attributes and Hierarchies00:08
      • 2.17 Exploring Attributes and Hierarchies Demo 0202:50
      • 2.18 Understanding Granularity00:09
      • 2.19 Understanding Granularity Demo 0301:57
      • 2.20 Historical Data00:16
      • 2.21 Historical Data02:57
      • 2.22 Slowly Changing Dimensions01:28
      • 2.23 SCD Type 101:00
      • 2.24 SCD Type 203:25
      • 2.25 SCD Type 301:58
      • 2.26 Data Lineage00:38
      • 2.27 ETL For Loading Dimensions01:33
      • 2.28 Understanding SCD Type 200:08
      • 2.29 Understanding SCD Type 2 Demo 0402:58
      • 2.30 Quiz
      • 2.31 Summary00:46
      • 2.32 Conclusion00:06
    • Lesson 3 - Fact Tables 24:09
      • 3.1 Fact Table00:24
      • 3.2 Objectives00:36
      • 3.3 Facts and Measures00:14
      • 3.4 Measures01:05
      • 3.5 Properties of Measures02:09
      • 3.6 Steps of Implementing a Fact Table01:00
      • 3.7 Steps for Loading Data into Fact Tables01:19
      • 3.8 Creating and Exploring a Fact Table00:11
      • 3.9 Creating and Exploring a Fact Table Demo 0103:40
      • 3.10 Fact Table Indexing00:11
      • 3.11 Indexing Fact Tables02:31
      • 3.12 Type of Indexes02:06
      • 3.13 Storage of Fact Tables01:34
      • 3.14 Creating ColumnStore Indexes01:12
      • 3.15 Fact Table Lineage00:07
      • 3.16 Fact Table Lineage Demo 0201:50
      • 3.17 Using an Audit Dimension00:07
      • 3.18 Using an Audit Dimension Demo 0302:14
      • 3.19 Quiz
      • 3.20 Summary00:40
      • 3.21 Summary (contd.)00:47
      • 3.22 Conclusion00: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 201200:26
      • 4.2 Objectives00:26
      • 4.3 Roles of SQL Server Components00:18
      • 4.4 Database Engine for Data Warehousing01:12
      • 4.5 SQL Server Integration Services01:13
      • 4.6 SSIS - Introduction00:19
      • 4.7 SSIS - Components02:18
      • 4.8 SSIS Deployment Architecture02:33
      • 4.9 Deployment - Shared00:58
      • 4.10 Deployment - Dedicated00:50
      • 4.11 SSIS Installation and Implementation Requirements00:16
      • 4.12 Implementing SSIS Requirements01:27
      • 4.13 32-bit vs. 64-bit02:45
      • 4.14 Installing SSIS00:08
      • 4.15 Installing SSIS Demo 0103:24
      • 4.16 Quiz
      • 4.17 Summary00:53
      • 4.18 Conclusion00:11
    • Lesson 5 - SSIS Overview for ETL 27:20
      • 5.1 SSIS Overview for ETL00:27
      • 5.2 Objectives00:38
      • 5.3 Understanding the Structure of SSIS00:17
      • 5.4 Structure of SSIS01:23
      • 5.5 SSIS Project01:29
      • 5.6 SSIS Package02:01
      • 5.7 Connection Manager02:21
      • 5.8 Project and Package Level Connection Managers01:24
      • 5.9 Connection Strings and Properties of Connection Manager01:24
      • 5.10 SSIS Catalog01:30
      • 5.11 Setting up a SSIS Catalog00:06
      • 5.12 Setting up a SSIS Catalog Demo 0101:05
      • 5.13 Creating a New SSIS Project00:10
      • 5.14 Creating a New SSIS Project Demo 0201:05
      • 5.15 Adding a Connection Manager00:09
      • 5.16 Adding a Connection Manager Demo 0301:48
      • 5.17 Advanced SSIS Projects00:12
      • 5.18 Parameterization01:55
      • 5.19 Package Type00:59
      • 5.20 Package Transactions01:58
      • 5.21 Transaction Support Matrix01:29
      • 5.22 Viewing and Changing Connection String Parameters00:07
      • 5.23 Viewing and Changing Connection String Parameters Demo 0401:48
      • 5.24 Quiz
      • 5.25 Summary00:45
      • 5.26 Summary (contd.)00:38
      • 5.27 Conclusion00:12
    • Lesson 6 - Understanding SSIS Control Flow 41:41
      • 6.1 Understanding SSIS Control Flow00:26
      • 6.2 Objectives00:39
      • 6.3 Understanding the Control Flow of SSIS00:14
      • 6.4 SSIS Control Flow - Introduction01:07
      • 6.5 Control Flow Designer Surface02:21
      • 6.6 Control Flow - Elements01:21
      • 6.7 Working with Tasks in Control Flow00:07
      • 6.8 Tasks01:45
      • 6.9 Task Categories02:18
      • 6.10 Adding Tasks to a Control Flow00:08
      • 6.11 Adding Tasks to a Control Flow Demo 0104:07
      • 6.12 Understanding Containers and Constraints00:24
      • 6.13 Containers01:12
      • 6.14 Sequence Container01:09
      • 6.15 For Loop Container02:30
      • 6.16 Foreach Loop Container01:44
      • 6.17 Constraints01:19
      • 6.18 Types of Constraints01:32
      • 6.19 Adding a Container to the Control Flow00:07
      • 6.20 Adding a Container to the Control Flow Demo 0202:01
      • 6.21 Adding Constraints to a Control Flow00:11
      • 6.22 Adding Constraints to a Control Flow Demo 0300:42
      • 6.23 Using Event Handlers and Other Properties00:15
      • 6.24 Event Handlers01:12
      • 6.25 Event Bubbling02:48
      • 6.26 Checkpoint01:32
      • 6.27 Checkpoint (contd.)01:50
      • 6.28 Parallelism01:52
      • 6.29 Using Event Handlers00:06
      • 6.30 Using Event Handlers Demo 0403:08
      • 6.31 Quiz
      • 6.32 Summary00:37
      • 6.33 Summary (contd.)00:48
      • 6.34 Conclusion00:09
    • Lesson 7 - Working with Variables 34:12
      • 7.1 Working with Variables00:26
      • 7.2 Objectives00:23
      • 7.3 Understanding variables in SSIS00:13
      • 7.4 Variables01:16
      • 7.5 Variable - Properties02:43
      • 7.6 Creating variables01:05
      • 7.7 Variable - Data Types00:36
      • 7.8 Scope of Variables00:56
      • 7.9 Creating New Variables00:06
      • 7.10 Creating new variables Demo 0102:38
      • 7.11 System Variables and Expressions00:14
      • 7.12 SSIS System Variables01:36
      • 7.13 Expressions01:12
      • 7.14 Precedence Constraints and Expressions01:22
      • 7.15 Adding Expressions with User Variables00:07
      • 7.16 Adding Expressions with User Variables Demo 0204:43
      • 7.17 Creating Expressions with System Variables00:07
      • 7.18 Creating Expressions with System Variables Demo 0301:09
      • 7.19 Parameters in Packages and Projects00:12
      • 7.20 Parameters02:04
      • 7.21 Package Templates01:19
      • 7.22 Package Configurations01:13
      • 7.23 Parameterizing expressions00:09
      • 7.24 Parameterizing expressions Demo 0401:52
      • 7.25 Creating a custom package template00:09
      • 7.26 Creating a custom package template Demo 0501:23
      • 7.27 Using Configurations00:08
      • 7.28 Using Configurations Demo 0603:33
      • 7.29 Quiz
      • 7.30 summary01:08
      • 7.31 Conclusion00:10
    • Lesson 8 - Introduction to ETL 53:07
      • 8.1 Introduction to ETL00:21
      • 8.2 Objectives00:26
      • 8.3 ETL and the Data Flow Task00:20
      • 8.4 Understanding the BI Process01:22
      • 8.5 The Business Intelligence Process01:36
      • 8.6 SSIS ETL Processing - The Data Flow Task01:42
      • 8.7 Components of Data Flow01:03
      • 8.8 Data Source Components00:57
      • 8.9 Data Destination Components00:51
      • 8.10 Data Transform Components01:13
      • 8.11 Data Transform Components - Types03:17
      • 8.12 Creating a new ETL Process using Data Flow00:10
      • 8.13 Creating a new ETL Process using Data Flow Demo 0103:26
      • 8.14 Transforms—Types00:14
      • 8.15 Transforms in SSIS00:39
      • 8.16 Lookup Transforms00:57
      • 8.17 Using Lookup Transform00:05
      • 8.18 Using Lookup Transform Demo 0203:13
      • 8.19 Fuzzy Lookup Transform02:10
      • 8.20 Using Fuzzy Lookup00:07
      • 8.21 Using Fuzzy Lookup Demo 0303:03
      • 8.22 Text Mining Transforms01:00
      • 8.23 Using Text Mining00:05
      • 8.24 Using Text Mining Demo 0401:36
      • 8.25 SCD Transform01:15
      • 8.26 Configure SCD Transform00:08
      • 8.27 Configure SCD Transform Demo 0503:06
      • 8.28 Scripting in SSIS Packages01:22
      • 8.29 Data Cleaning00:53
      • 8.30 Using Data Profiling00:08
      • 8.31 Using Data Profiling Demo 0603:20
      • 8.32 Data Quality Services01:10
      • 8.33 Setting up and using DQS00:07
      • 8.34 Setting up and using DQS Demo 0710:42
      • 8.35 Quiz
      • 8.36 Summary00:53
      • 8.37 Conclusion00:10
    • Lesson 9 - Deploying and Managing Packages 19:37
      • 9.1 Deploying and Managing Packages00:25
      • 9.2 Objectives00:21
      • 9.3 Executing SSIS Packages00:15
      • 9.4 SSIS Package Execution Methods01:27
      • 9.5 Deployment options01:40
      • 9.6 SQL Server Management Studio01:19
      • 9.7 Deployment Utility00:39
      • 9.8 Deploy and Execute Packages00:10
      • 9.9 Deploy and Execute Packages Demo 0103:33
      • 9.10 Create and Use a Deployment Utility00:09
      • 9.11 Create and Use a Deployment Utility Demo 0202:31
      • 9.12 Logging and Storing Packages00:14
      • 9.13 Logging and Auditing01:17
      • 9.14 Custom Logging01:22
      • 9.15 Turn On Logging00:06
      • 9.16 Turn On Logging Demo 0303:13
      • 9.17 Quiz
      • 9.18 Summary00:47
      • 9.19 Conclusion00:09
    • Lesson 10 - Debugging and Securing Packages 21:56
      • 10.1 Debugging and Securing Packages00:27
      • 10.2 Objectives00:22
      • 10.3 Handling Errors and Notifying Operators00:15
      • 10.4 Error Handling in Data Flow01:36
      • 10.5 Alerts00:44
      • 10.6 Notifications00:28
      • 10.7 Debugging SSIS00:15
      • 10.8 Breakpoints01:08
      • 10.9 Control Flow Breakpoints01:28
      • 10.10 Data Flow Breakpoints00:50
      • 10.11 Debugging Control Flow00:05
      • 10.12 Debugging Control Flow Demo 0102:40
      • 10.13 Debugging Data Flow00:05
      • 10.14 Debugging Data Flow Demo 0202:46
      • 10.15 Package Security00:10
      • 10.16 SSIS Security01:07
      • 10.17 SSIS Security Roles01:23
      • 10.18 Package Protection Levels01:52
      • 10.19 Securing sensitive data in a package00:08
      • 10.20 Securing sensitive data in a package Demo 0303:16
      • 10.21 Quiz
      • 10.22 Summary00:42
      • 10.23 Conclusion00: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.

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