Discover Classes. Earn 10% Rewards.

Implementing a Data Warehouse with Microsoft SQL is unfortunately unavailable

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

SQL Bootcamp

SQL Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Build expertise in turning raw data into actionable insights with SQL queries. The hands-on course teaches how to filter, group, and join data, plus advanced techniques such as subqueries and aggregate functions. Develop the skills to thrive in any data-driven industry and make more informed decisions.

(452) All levels 18 and older

Oct 26th

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

Oct 27th

6–9pm ET

Meets 6 Times

$975
20 Seats Left

Nov 15th

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

Nov 23rd

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

Dec 14th

10am–5pm ET

Meets 3 Times

$975
20 Seats Left

This class has 12 more dates.

Tap here to see more
Mon. Oct 26th, 10am–5pm ET  (21 hours over 3 sessions)  
$975

3 sessions

Attend
Gift it!
SQL Certification Program

SQL Certification Program

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY

Get fluent with SQL and earn certification through our hands-on SQL Certification Program. Learn to write queries, analyze data, and draw insights from relational databases, prepping for the Oracle SQL Certified Associate exam.

(452) All levels 18 and older

Oct 26th

10am–5pm ET

Meets 3 Times

$1,699
20 Seats Left

Oct 27th

6–9pm ET

Meets 6 Times

$1,699
20 Seats Left

Nov 15th

10am–5pm ET

Meets 3 Times

$1,699
20 Seats Left

This class has 6 more dates.

Tap here to see more
Mon. Oct 26th, 10am–5pm ET  (21 hours over 3 sessions)  
$1,699

3 sessions

Attend
Gift it!
Data Analytics Technologies Bootcamp

Data Analytics Technologies Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Through this course, students build mastery in Excel, SQL, and Tableau, some of the top data analytics tools. Students develop the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(452) All levels 18 and older

Nov 2nd

10am–5pm ET

Meets 8 Times

$1,949
20 Seats Left

Nov 30th

10am–5pm ET

Meets 8 Times

$1,949
20 Seats Left

This class has 6 more dates.

Tap here to see more
Mon. Nov 2nd, 10am–5pm ET  (56 hours over 8 sessions)  
$1,949

8 sessions

Attend
Gift it!
SQL Level 2

SQL Level 2

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Sharpen your SQL skills by mastering outer joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Pull and analyze specific data from databases, turning raw information into valuable insight. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.

(452) Intermediate 18 and older

Nov 3rd

10am–5pm ET

$350
20 Seats Left

Dec 10th

10am–5pm ET

$350
20 Seats Left

This class has 6 more dates.

Tap here to see more
Tue. Nov 3rd, 10am–5pm ET  (7 hours)  
$350
Attend
Gift it!
SQL Level 1

SQL Level 1

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Unlock the power of SQL and relational databases in this comprehensive course. Learn how to write SQL queries, filter results, and join data across multiple tables, all while building a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.

(452) Beginner 18 and older

Nov 2nd

10am–5pm ET

$350
20 Seats Left

Dec 9th

10am–5pm ET

$350
20 Seats Left

This class has 6 more dates.

Tap here to see more
Mon. Nov 2nd, 10am–5pm ET  (7 hours)  
$350
Attend
Gift it!
See all SQL classes NJ

Implementing a Data Warehouse with Microsoft SQL

Corporate Training Group
3.5 4 reviews
  • Advanced
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 330 West 38th St, New York, NY
  • over 5 sessions
Implementing a Data Warehouse with Microsoft SQL
Implementing a Data Warehouse with Microsoft SQL
Implementing a Data Warehouse with Microsoft SQL
Implementing a Data Warehouse with Microsoft SQL
Implementing a Data Warehouse with Microsoft SQL
Sold Out
Book Private Class Save to WishList

1 person wishlisted

Start Dates (0) $2,475/person

No upcoming dates are currently available.

Book a Private Group Event

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

Or see all Data Analytics Group Events

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

Class Description

Description Cancellation Policy

Description

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.

Audience Profile

This course is intended for database professionals who need to create and support a data warehousing solution. Primary

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

At Course Completion

After completing this course, students will be able 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. 

Refund Policy

Cancellation acceptable prior to 10 days before class date.

Reviews of Classes at Corporate Training Group (4)

(3.5-star rating across 4 reviews)
See reviews for other classes at Corporate Training Group
loading...
Hide Reviews

Similar Classes

People who viewed this class also viewed the following classes

CourseHorse Gift Card
Pick your value!
SQL Bootcamp $975 for 3 sessions
SQL Certification Program $1,699 for 3 sessions
Data Analytics Technologies Bootcamp $1,949 for 8 sessions
View all sql 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 24750 points. Earn 10% back in reward points!

Corporate Training Group

Corporate Training Group, Inc. is a Microsoft Gold Certified Partner specializing in authorized technical training and consulting led by Microsoft Certified Instructors. As a certified Woman-Owned and Small Business Enterprise, CTG delivers expert instruction and real-world solutions that help organizations streamline processes and build staff expertise.

View school profile
Corporate Training Group
Vetted by CourseHorse

A verified NJ educator.

Give an experience worth remembering

One CourseHorse gift card. Thousands of classes to choose from.

  • Instant or scheduled delivery
  • No expiration date
  • Earn 15% reward points
Buy a Gift Card
gift card with the CourseHorse logo
Loading...