Implementing a SQL Data Warehouse [Class in Nashville] @ New Horizons Nashville

Implementing a SQL Data Warehouse is unfortunately unavailable

Start Dates (0)

$2,975
40 hours over 5 sessions

Showing 1 – 0 of 0

Description

What you'll learn in this sql class:

Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services.

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.

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 columnstore 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

Prerequisite: In addition to their professional experience, students who attend this training should already have the following technical knowledge: 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.

Refund Policy

If it becomes necessary to reschedule or cancel a registered class, students must provide advance notice in writing to the Educational Consultant five business days prior to the start of the class. For rescheduling purposes, this action will allow the student to select an alternate class without penalty.

If a student withdraws from the institution on or before the first class day, or fails to begin a class, the refund shall equal the sum of all amounts paid or to be paid by or on behalf of the student for the program, less an administrative fee of $100.00.
If after a class has begun and before the expiration of 10% of their program for which he or she was charged, a student withdraws, drops out, or otherwise fails to attend classes, the refund shall equal 75% of all amounts paid or to be paid by or on behalf of the student for the program, less a $100 administrative fee per course.
If after expiration of 10% of the program for which he or she was charged, and before expiration of 25% of the period, a student withdraws, drops out or otherwise fails to attend classes, the refund shall equal 25% of all amounts paid or to be paid on behalf of the student for the program, less administrative fee of $100 per course. If after expiration of 25% of the program for which he or she was charged, a student withdraws, drops out or otherwise fails to attend classes, the student may be deemed obligated for 100% of the tuition, fees and other charges assessed by the institution.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Nashville

With a convenient location in Nashville, New Horizons provides classes on a variety of technical and business applications. We offer an extensive selection of vendor-authorized training classes for top technology providers like Adobe, Cisco, Citrix, Microsoft, and VMware.

New Horizons of Nashville understands...

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