Implementing a Data Warehouse with MS SQL Server 2014 is unfortunately unavailable

Thankfully we have 2 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

Implementing a Data Warehouse with MS SQL Server 2014
Sold Out
Questions about this class?
Get help now from a knowledge expert!

Implementing a Data Warehouse with MS SQL Server 2014

at Learning Tree International - Herndon

Course Details
Price:
$3,190
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Herndon
13650 Dulles Technology Dr Ste #175
At Sunrise Valley Dr
Herndon, Virginia 20171
(Map)
Share:
Important:
Course 8465
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 16

What you'll learn in this sql server training:

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Key Features of this course:
  • Microsoft Official Course (MOC 20463) content
  • Eligible for SATV redemption
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
  • After-course computing sandbox included
You Will Learn How To:
  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.
Prerequisites:
  • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Course Outline:
  • Module 1: Introduction to Data Warehousing
  • Module 2: Data Warehouse Hardware Considerations
  • Module 3: Designing and Implementing a Data Warehouse
  • Module 4: Creating an ETL Solution with SSIS
  • Module 5: Implementing Control Flow in an SSIS Package
  • Module 6: Debugging and Troubleshooting SSIS Packages
  • Module 7: Implementing an Incremental ETL Process
  • Module 8: Enforcing Data Quality
  • Module 9: Using Master Data Services
  • Module 10: Extending SQL Server Integration Services
  • Module 11: Deploying and Configuring SSIS Packages
  • Module 12: Consuming Data in a Data Warehouse

Still have questions? Ask the community.

Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to two weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

If a customer transfers to another course prior to two weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.

If a customer needs to cancel an enrollment two weeks prior to the start of the class or within seven days of registration, we will refund 100% of any prepaid course tuition for that enrollment.

If a customer does need to transfer or cancel a course within two weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances. Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

Map

Google Map

Learning Tree International

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 31900 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: Learning Tree International

Learning Tree International

Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...

Read more about Learning Tree International

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DC educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

2 Top Choices

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.  Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which...

Monday Nov 4th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions