Description:
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:
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.
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. The minimum for the loans must be $500.00. Some service charges may apply.
Please email continuinged@utrgv.edu once you have been approved by your loan provider so we may certify your loan.
Edinburg Course Information
Days:
TBA
Dates:
TBA
Times:
TBA
Location:
Lecture:
Edinburg CESS Building
Instructor:
TBD
Cost:
$ 2,290
- More of What You're Looking For -
A Manager’s Guide to Artificial Intelligence
This course introduces learners to basic artificial intelligence concepts and trends.
Certificate in Agile Project Management
This hybrid certificate program will provide managers with the basic foundation they need to become competent Agile practitioners.
Certificate in Computer Skills for the Office
Bring to your Office skills to a whole new level by diving into a suite set of powerful instructional courses.
Computer Support Specialist Program
This program prepares students for a role in supporting computer users by installing, configuring, troubleshooting, and managing computers, hardware, wired and wireless networks.
Certificate in Cybersecurity
Cybersecurity, also known as Information Security is the protection of data and personally identifiable information from malicious attacks, theft, and destruction.
Certificate in Data Analytics
This program will introduce you to data analytics and its increasing use in today's professional landscape.
Certificate in Emerging Technology for Managers
This Certificate in Emerging Technology for Managers addresses blockchain, artificial intelligence, and robotics.
Front End Web Developer
Participants learn how to make interactive applications that run inside a web browser and can communicate with a web server running remotely.
