PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
Support Personnel
Programmer
Database Administrator
System Designer
System Analyst
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Data Warehousing Basics and Hardware
Identify the key components in a data warehouse.
Design and Implement a Data Warehouse
Given the logical design documentation from the data warehouse schema, write a physical design.
ETL with SSIS: SQL Server Integration Services
Use SQL Server Integration Services to transfer data and run a transformation.
SSIS Packages: Debugging and Problem Resolution
Given a SSIS package, determine the error type and the source and cause of the error.
Change to package to contain an event handler for the package.
Incremental ETL: Extract Transform Load Process
Code an ETL with a Change Data Capture.
Data from the Cloud into a Data Warehouse
Extract data from a MS SQL Azure database; load data into a MS SQL Azure database.
If an MS SQL Azure database is not available, the instructor will provide an alternative example.
Master Data Services
Use Master Data Services to import and export data.
Deployment and Configuration of SSIS Packages
Create and deploy an SSIS project.
Schedule the SSID package using the SQL Server Schedule Agent.
Consuming Data in a Data Warehouse
Given a case study, create a BI: Business Intelligence solution.
Use Power View to utilize a report.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
