Discover Classes. Earn Rewards.

Implementing a Microsoft SQL 2016 Data Warehouse is unfortunately unavailable

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

SQL Level I

NYC Career Centers - Virtually Online

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

(679) Beginner 18 and older

SQL Level II

NYC Career Centers - Virtually Online

Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.

(679) Intermediate 18 and older

SQL Server Bootcamp

Noble Desktop - Virtually Online

Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

SQL Level III

NYC Career Centers - Virtually Online

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(679) Advanced 18 and older

SQL Bootcamp

NYC Career Centers - Virtually Online

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

(679) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL Server classes Online

Implementing a Microsoft SQL 2016 Data Warehouse

  • All levels
  • 18 and older
  • $2,394
  • Live, Interactive Online Classroom
  • 40 hours over 5 sessions
Implementing a Microsoft SQL 2016 Data Warehouse
Sold Out

Start Dates (0)

  • $2,394
  • Live, Interactive Online Classroom
  • 40 hours over 5 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql server training:

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution.

This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

This course also prepares the students for the Microsoft 70-767: Implementing a Data Warehouse using SQL certification exam.

Course Objectives:

After completing this course, students will be able to:
  • Describe the key elements of a data warehousing solution 
  • Describe the main hardware considerations for building a data warehouse 
  • Implement a logical design for a data warehouse 
  • Implement a physical design for a data warehouse
  • Create column store indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios
Audience:

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Prerequisites:

In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.
Course Outline:

Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
Module 7: Implementing Control Flow in an SSIS Package
Module 8: Debugging and Troubleshooting SSIS Packages
Module 9: Implementing an Incremental ETL Process
Module 10: Enforcing Data Quality
Module 11: Using Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
Module 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

We are saving your seat! In order to provide you with the highest quality training at the best price, we ask that you abide by our cancellation policy. You may cancel a class without a cancellation charge up to 10 business days prior to the class start date. If you cancel less than 10 business days prior to the class start date, then QuickStart will charge you the full amount of the class. You will have the option to reschedule the class at no additional fee - on a space available basis only. If you are unable to reschedule the class because of personal reasons or QuickStart no longer offers the class, no refund will be provided. QuickStart asks that you notify us as soon as possible if you need to reschedule a class.

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 23940 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

QuickStart

QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple modalities such as self-paced...

Read more about QuickStart

CourseHorse Approved

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

QuickStart

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...