search3
    
    20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

    QUICK

    INFORMATION

    course-duration

    5 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    Course Information

    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.

    COURSE OUTLINE

    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.

    Lessons

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

    Lessons

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

    Lessons

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

    WHO SHOULD ATTEND

    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.

    Pre-requisites

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

    Exam

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

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.