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

UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

This course can be applied to the Data Analysis Certificate.

Instructor

Hannah Goodman

Hannah Goodman

Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more

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

Prerequisites

SQL Introduction or the equivalent

Testimonials

"Ms. Goodman did an excellent job balancing instruction time and time to practice/work on our own. Since many adults learn by doing (not just watching/listening), I think this is very important."  —  Supervisor, 2018

"Again, Hannah was an extremely awesome teacher. Very easy to follow and learn from and very supportive."  —  Systems Analyst, 2018

All sessions are Face-to-Face unless otherwise noted.

Date: Tue.-Wed., Nov 13-14

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee:

$599 by Tue., Oct. 30.
$629 after Tue., Oct. 30.

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5070-11025

Registration Deadline: Tue., Nov. 13

Register Now

Date: Thu.-Fri., May 9-10, 2019

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee:

$599 by Thu., Apr. 25, 2019.
$629 after Thu., Apr. 25, 2019.

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5070-11411

Registration Deadline: Thu., May 9, 2019

Register Now

Share