Implementing a Data Warehouse with Microsoft SQL
- Advanced
- 18 and older
- $2,695
- 1 State Street Plaza, New York, NY
- over 4 sessions
May 14th
6–9pm EDT
Meets 2 Times
Discover Classes. Earn Rewards.
Implementing a Data Warehouse with Microsoft SQL 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 @ 185 Madison Ave, New York, NY & 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.
$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 Server Bootcamp
Noble Desktop @ 185 Madison Ave, New York, NY & 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.
May 14th
6–9pm EDT
Meets 6 Times
$975
20 Seats Left
May 28th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(18 hours over 6 sessions)
Other dates (7)
SQL Level II
NYC Career Centers @ 185 Madison Ave, New York, NY & 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.
May 21st
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 29th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 21st, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level III
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
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)
SQL Bootcamp
NYC Career Centers @ 185 Madison Ave, New York, NY & 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.
Apr 30th
10am–5pm EDT
Meets 3 Times
$975
19 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 3 more dates.
Tap here to see more
Tue, Apr 30th, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (7)
Sold Out
Start Dates (0)
- $2,695
- over 4 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql server training:
Discover how to implement a data warehouse platform with SQL Server 2012 or 2014.
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.
This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.
What You'll Learn
This course is part of the following programs or tracks:
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.
This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.
What You'll Learn
- Data warehouse concepts and architecture considerations
- Select an appropriate hardware platform for a data warehouse
- Design and implement a data warehouse
- Implement data flow and control flow in a SSIS package
- Debug and troubleshoot SSIS packages
- Implement a SSIS solution that supports incremental data warehouse loads and extracting data
- Implement data cleansing using Microsoft DQS
- Implement Master Data Services (MDS) to enforce data integrity
- Extend SSIS with custom scripts and components
- Deploy and configure SSIS packages
- How Business Intelligence solutions consume data in a data warehouse
- Database professionals who need to fulfill a BI developer role focused on hands-on work, creating BI solutions included data warehouse implementation, ETL, and data cleansing
- Database professionals responsible for implementing a data warehouse, developing SSIS packages for data extraction, loading, transferring, transforming, and enforcing data integrity using MDS, and cleansing data using DQS
- Minimum two years experience working with relational databases, including designing a normalized database, creating tables and relationships
- Basic programming constructs, including looping and branching
- Focus on key business priorities, such as revenue, profitability, and financial account
- Querying Microsoft SQL Server (M20461)
- Implementing Data Models and Reports with Microsoft SQL Server (M20466)
- Designing Self-Service Business Intelligence and Big Data Solutions (M20467)
This course is part of the following programs or tracks:
- MCSA: SQL Server 2012
Refund Policy
You must cancel or reschedule your registration 17 or more business days before the start date of your scheduled class.
Failure to provide the required notification will result in full charge of the course. If a student does not attend a scheduled course without the required prior notification, the full charge of the course will be charged and rescheduling will not be allowed. Within the required notification period, only student substitutions will be permitted.
Rescheduling is permitted at any time with 17 or more business days' notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Reviews of Classes at Global Knowledge (12)
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 26950 points. Points give you money off your next class!
Global Knowledge
Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate...
Read more about Global Knowledge
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
Global Knowledge
Financial District, Manhattan
1 State Street Plaza 23rd Flr
Btwn Pearl and Water Streets
New York, New York 10004 Financial District, Manhattan
1 State Street Plaza 23rd Flr
Btwn Pearl and Water Streets
New York, New York 10004
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 Microsoft Servers
Made in NYC
© CourseHorse, Inc. 2024 Loading...