• This field is for validation purposes and should be left unchanged.

SQL – Intermediate/Advanced Concepts

This course is for people who know how to write SQL statements, but want to master joins. Learn all the different ways you can use sub-queries.  Try your hand at some very tough problems and think outside the box! This course starts where the SQL Introduction course leaves off.

Who Should Attend

Students who have taken the SQL Introduction class or the equivalent and are looking to solve very complicated problems

Benefits and Learning Outcomes

After completing this course you will be able to solve more complicated problems, beyond the introductory level, through hands-on experience.  You will have considerably more experience and understanding of joins.

Course Outline/Topics

SQL Joins – Topics Include:

  • Extensive review of Inner and Outer Joins
  • Using the same table more than once in a join
  • Full outer joins
  • Subqueries using IN
  • Subqueries with All, Some and Any
  • Subqueries with Exists
  • Subqueries as Columns
  • Not and And Problems
  • Condition Testing
  • Unlinked Data and Driver Tables


SQL Introduction or the equivalent

Firstly, a big thank you and a great job working with our group! The size of the class was really beneficial for individual attention. The course work was extremely challenging (in a good way) and I think the exercises in the book will be perfect for keeping my skills sharp.

— Student, 2014

Tue.-Wed., Apr. 26-27, 2016


Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $599

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5070-8448

Registration Deadline: Mon., Apr. 25, 2016

Register Now