Implementing a Data Warehouse with Microsoft SQL
- Advanced
- 18 and older
- $2,475
- 330 West 38th St, New York, NY
- over 5 sessions
Apr 30th
10am–5pm EDT
Meets 3 Times
Discover Classes. Earn 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
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.
$975
20 Seats Left
May 20th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
Jun 10th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 4 more dates.
Tap here to see more
Tue, Apr 30th, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (8)
SQL Private Training
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform
Wed, May 29th, 10am–1pm EDT
(3 hours)
Data Analytics Technologies Bootcamp
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.
May 13th
10am–5pm EDT
Meets 8 Times
$1,949
20 Seats Left
May 14th
6–9pm EDT
Meets 16 Times
$1,949
20 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 13th, 10am–5pm EDT
(56 hours over 8 sessions)
Other dates (3)
SQL Level 1
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.
May 14th
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 28th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level 3
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.
May 28th
6–9pm EDT
Meets 2 Times
$425
20 Seats Left
May 30th
10am–5pm EDT
$425
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 28th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
Sold Out
Start Dates (0)
- $2,475
- over 5 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql class:
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:
At Course Completion
After completing this course, students will be able to:
Extend SSIS with custom scripts and components.
Deploy and Configure SSIS packages.
Describe how BI solutions can consume data from the data warehouse.
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)
See reviews for other classes at Corporate Training Group
Review Summary by CourseHorse
Students who have taken the Implementing a Data Warehouse with Microsoft SQL class have praised the instructor, Darrell Wire, for his real-world experience and ability to make the course engaging. They also appreciate the clean and comfortable training facility provided by CTG. The reviews do not specifically mention the substance of what students learned in the class or the skills they were able to walk away with.
Quotes:
1. "As always, Darrell Wire was fantastic!! His real-world experience shines through in every training."
2. "CTG has a clean quiet comfortable environment – The Best training facility that I have visited in the area."
3. "Darrell has a good real-world experience, which makes the course more interesting."
Review Summary by CourseHorse
Students who have taken the Implementing a Data Warehouse with Microsoft SQL class have praised the instructor, Darrell Wire, for his real-world experience and ability to make the course engaging. They also appreciate the clean and comfortable training facility provided by CTG. The reviews do not specifically mention the substance of what students learned in the class or the skills they were able to walk away with. Quotes: 1. "As always, Darrell Wire was fantastic!! His real-world experience shines through in every training." 2. "CTG has a clean quiet comfortable environment – The Best training facility that I have visited in the area." 3. "Darrell has a good real-world experience, which makes the course more interesting."
Similar Classes
People who viewed this class also viewed the following classes
CourseHorse Gift Card
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. Points give you money off your next class!
Corporate Training Group
Corporate Training Group, Inc. is a Microsoft Gold Certified Partner for Learning Solutions and Information Worker Solutions. CTG provides authorized training delivered by Microsoft Certified Instructors (MCT) using Microsoft Certified Courseware. CTG provides technical training and consulting services....
Read more about Corporate Training Group
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
Corporate Training Group
Hell's Kitchen, Manhattan
330 West 38th St Ste 301
Btwn 8th & 9th Avenues
New York, New York 10018 Hell's Kitchen, Manhattan
330 West 38th St Ste 301
Btwn 8th & 9th Avenues
New York, New York 10018
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™
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.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Database
Made in NYC
© CourseHorse, Inc. 2024 Loading...