Intermediate SQL

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.

Course length: One month
Number of Hours: 16
Cost: $595

Course start dates: this course is offered every month, starting the first Monday

You may also take this course as part of the SQL Certificate.

Additional Course Information

Agenda

Unit 5

Creating Calculated Fields and using Aggregate Functions

Structured Query Language Review
Creating calculated fields
Concatenating columns
Using aggregate functions

Unit 6

Using Clauses in Structured Query Language

Using the ORDER BY clause
Using the GROUP BY clause
Using the GROUP BY clause and WHERE clause
Using the HAVING clause

Unit 7

Creating Table Joins

Creating Inner joins
Creating Outer joins
Creating Self joins

Unit 8

Creating Subqueries

Creating subqueries
Creating subqueries that contain calculated fields
Creating subqueries that contain aggregate functions

Cancellation Policy

Continuing Education Classes:

We understand that sometimes life happens. If you are unable to attend your class, please email Continuing-ed@uwm.edu. We will be happy to contact your instructor to let them know and provide you with any material missed.

If you cancel 8 days prior to the start of your class, we are happy to issue an account credit/voucher to you. If you do not provide an 8 day cancellation notice, you will not be eligible to receive a credit/voucher*. Unfortunately, no refunds will be provided.

*Please remember, vouchers are not issued for and cannot be used towards trips, online, or credit courses.*

In order for Continuing Education to continue to provide the community with the outreach programming that we have, all cancellations will be assessed a 6% administrative fee. If you would like to provide a donation or contribute to our scholarship fund, you can do so at check-out by adding any dollar amount to your order! You can also contact our department at continuing-ed@uwm.edu. Continuing Education is cost-recovery and relies on community donations to help support its programs.

Thank you for your continued support!

Course Detail