Implementing a SQL Data Warehouse

Learn how to provision a Microsoft SQL Server database both on-premise and in Azure. Build your competency and skills in planning, designing, and implementing a data warehouse. Learn to use, configure, debug, and troubleshoot SQL Server Integration Services (SSIS). Implement data extraction solutions, enforce data quality, and use, report, and analyze data in a data warehouse.

Online Access: Access information for the Learning Management System (LMS) will be provided by email within 5 - 10 business days before class begins. Zoom session information will be provided within the LMS.

Refund Policy We ask that you notify us no less than ten (10) business days in advance of your scheduled class, should you cancel or reschedule your reservation.


Details:


• Implement an Azure SQL Data Warehouse
• Execute logical and physical design for a data warehouse
• Apply control flow by using tasks and precedence constraints
• Describe the main hardware required to build a data warehouse
• Create column store indexes and dynamic packages that include variables and parameters
• Represent the key features of SSIS
• Debug and deploy SSIS projects
• Understand the considerations to implement an ETL solution
• Enable Data Quality Services and a Master Data Services model
• Interpret how to use custom components to extend SSIS
• Define common BI scenarios

This course is targeted towards database, business intelligence, and other information technology professionals seeking to fill a business intelligence role or learn to plan, design, and build a data warehouse.


Note: PEWD program participants should be 18 years or older.

No prerequisites required.

TBD

Note: If you are applying for the Continuing Education Private Loan to cover the registration fee for a non-credit continuing education program, then please use the UTRGV Continuing Education School Code: 003599. The loan amount you note in the application cannot exceed the open enrollment fee noted on our website. Books will NOT be included in the loan amount. The minimum for the loans must be $500.00. Some service charges may apply.

*The only loan provider PEWD accepts is Sallie Mae*

Please email pewd@utrgv.edu once you have been approved so we may certify your loan.

Private Loans

 



Edinburg Course Information

Registration Deadline:
TBA

Dates:
TBA

Days/Times:
TBA

Program Modality:
In-Person

Location:
Lecture:
Edinburg CESS Building

Instructor:
TBD

Cost:
$ 2,290

Notes:
Students requiring accommodation should contact our office pewd@utrgv.edu to learn about the process.

- More of What You're Looking For -

Play Stop