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.
What You Will You Learn:
• 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.
No prerequisites required.
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. The minimum for the loans must be $500.00. Some service charges may apply.
Please email firstname.lastname@example.org once you have been approved by your loan provider so we may certify your loan.
Edinburg Course Information
Edinburg CESS Building
- More of What You're Looking For -
This course introduces learners to basic artificial intelligence concepts and trends.
This hybrid certificate program will provide managers with the basic foundation they need to become competent Agile practitioners.
Bring to your Office skills to a whole new level by diving into a suite set of powerful instructional courses.
This program prepares students for a role in supporting computer users by installing, configuring, troubleshooting, and managing computers, hardware, wired and wireless networks.
Cybersecurity, also known as Information Security is the protection of data and personally identifiable information from malicious attacks, theft, and destruction.
This program will introduce you to data analytics and its increasing use in today's professional landscape.
This Certificate in Emerging Technology for Managers addresses blockchain, artificial intelligence, and robotics.