20463: Implementing a Data Warehouse with Microsoft SQL Server 2014




    5 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    The Implementing a Data Warehouse with Microsoft SQL Server Certification Course 20463D is a five-day intensive training intended for professionals who seek interest in learning the Microsoft SQL Server 2012 or 2014. The participants will acquire the skills to create a data warehouse with Microsoft SQL Server 2014 by implementing the ETL as well as QSL services.

    This course helps you prepare for the exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server Certification that will qualify you for the MCSA: SQL Server 2014.

    Note: This course is designed for individuals who seek to learn SQL Server 2012 or SQL Server 2014. It displays the new features in SQL Server 2014.

    After completing this course, participants will be able to:

    • Describe the crucial database administration tasks and tools.
    • Plan and implement a backup strategy.
    • Perform ongoing database maintenance.
    • Install and configure SQL Server 2014.
    • Configure SQL Server databases and storage.
    • Trace & Manage SQL Server activity.
    • Import and export data. Monitor SQL Server.
    • Configure Database Mail, alerts and notifications.
    • Perform ongoing database maintenance.
    • Automate SQL Server maintenance with SQL Server Agent Jobs.
    • Restore databases from backups.

    Module 1: Introduction to Data Warehousing

    This module introduces the key components of a data warehousing solution and the high-level considerations on a data warehousing project.


    • Overview of Data Warehousing
    • Considerations for a Data Warehouse Solution

    Module 2: Data Warehouse Hardware Considerations

    This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers.


    • Data Warehouse Reference Architectures and Appliances
    • Considerations for building a Data Warehouse

    Module 3: Designing and Implementing a Data Warehouse

    This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation.


    • Logical Design for a Data Warehouse
    • Physical design for a data warehouse

    This Microsoft course for Implementing a Data Warehouse is intended for database professionals who need to accomplish a Business Intelligence Developer role.  They will be required to exhibit hands-on work creating BI solutions

    Primary responsibilities will include:

    • Implementing a data warehouse.
    • Enforcing data integrity by using Master Data Services.
    • Cleansing data by using Data Quality Services.
    • Developing SSIS packages for data extraction, transformation, and loading.

    This course requires professionals and learners to meet the following prerequisites:

    • At least 2 years’ experience of relevant experience with relational databases, including:
    • Designing a normalized database.
    • Querying with Transact-SQL.
    • Creating tables and relationships.
    • Some exposure to basic programming constructs (such as looping and branching).

    Name Code Fee
    Microsoft Certified Professional (MCP) - [70-463] 70-463 USD 127



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.