Institute of Business and Technology

iBtech Logo | Institute of Business & Technology

Business & Technology

Institute of Business & Technology

Course Status
Availability
Course Duration
Timing
Course ID
Exam Number
Registration Open
Weekdays – Weekends
7 Days, 49 Hours
9:00 AM – 04:00 PM
20767
70-767

Implementing a SQL Data Warehouse

After completing this course, students will be able to:

  • Describe the key elements of a data warehousing solution
  • Create column store 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
  • Deploy SSIS projects
  • Describe BI and common BI scenarios
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Experience in basic programming constructs (such as looping and branching).

You have made the
best choice!

Students | IT Health, and Business Courses | iBtech Toronto & Mississauga

Book Your Seat Today

Request Information

Request Information