Skip to main content
UTRGV
Give Apply
UTRGV Logo
  • Directory
  • myUTRGV
  • Maps
  • Give
  • Apply
  • Search
  • Home
  • Professional Education and Workforce Development
  • Language Programs
  • Campus Food Security Initiative
UTRGV
The University of Texas Rio Grande Valley

Continuing Education Office of Professional Education & Workforce Development

  • Home
  • Professional Education and Workforce Development
  • Language Programs
  • Campus Food Security Initiative
Business man looking over how the SQL database will be structured and created

Implementing a SQL Data Warehouse 


This live, online course provides students with the knowledge and skills to provision a Microsoft SQL Server database.

Subscribe
  • Programs (current)
    Business and Legal Education Executive Education Health and Fitness Information Science Leadership and Management Marketing and Creative Technology Personal Enrichment Test Preparation Online Courses
  • Scheduled Courses
  • Information

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:



• 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.

Private Loans

 



Edinburg Course Information

Days:
TBA

Dates:
TBA

Times:
TBA

Location:
Lecture:
Edinburg CESS Building

Instructor:
TBD

Cost:
$ 2,290

Subscribe

- More of What You're Looking For -


A Manager’s Guide to Artificial Intelligence

A Manager’s Guide to Artificial Intelligence

This course introduces learners to basic artificial intelligence concepts and trends.

Certificate in Agile Project Management

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

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

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

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

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

Certificate in Emerging Technology for Managers

This Certificate in Emerging Technology for Managers addresses blockchain, artificial intelligence, and robotics.

Front End Web Developer

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.

Play Stop

Contact Us - UTRGV Continuing Education


UTRGV CESS BLDG

1407 E Freddy Gonzalez 
CESS Building, Rm. 1700
Edinburg, TX 78539-2999

Phone: (956) 665-2071
continuinged@utrgv.edu

Brownsville Campus

101 St Joseph Dr, 
Brownsville, Texas 78520

Phone: (956) 882-7711

Hours

Monday - Friday
8:00 AM - 5:00 PM CST

Find us on Social Media


LIKE. FOLLOW. SUBSCRIBE. ADD.


Download the UTRGV App for Apple Download the UTRGV App for Android
UTRGV

The University of
Texas Rio Grande Valley

Connect with us:


  • CARES, CRRSAA and ARP Reporting
  • Site Policies
  • Required Links
  • Fraud Reporting
  • Senate Bill 18
  • Clery Act Reports
  • Web Accessibility
  • Mental Health Resources
  • Sexual Misconduct Policy
  • Contact UTRGV

©2022 The University of Texas Rio Grande Valley.