Implementing a SQL Data Warehouse

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)

$2,845.00

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Qty:

Download PDF of Course Details

Course Description

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 as well as installing from new and migrating from an existing install. The primary audience for this course is database professionals who need to fulfill 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.

Course Objectives

  • 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 a Data Extraction Solution
  • 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

Audience

  • For individuals who administer and maintain SQL Server databases

Inclusions

With CCS Learning Academy, you’ll receive:

  • Certified Instructor-led training
  • Official Training Seminar Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

*For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com