School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted
 

Connect With Us

 
HomeCourses & ProgramsCertificate ProgramsFaculty & Staff
 

SQL - Joins

 

This course is for people who know how to write SQL statements, but want to master the concept of Joins. The class covers inner and outer Joins as well as self Joins.

Course Outline/Topics

Topics Include:

  • Understanding Table Relationships
  • Venn Diagrams
  • Inner Joins - two ways
  • Outer Join
  • Mixed Joins
  • Self Joins
  • Subqueries as Joins

Close ▲

Prerequisites
SQL Introduction OR equivalent experience. Previous knowledge with writing expressions in SQL and how to write a WHERE statement.

"The instructor was very engaging and the subject material is very helpful in performing one of my key functions at work. Structure was very cohesive."
student, 2013

"The SQL Joins class was very beneficial in reinforcing the concept of Joins. Hannah takes the time to make sure that the concepts presented are understood. Thanks for the great class!"
student, 2013

  Sessions  
Thu., May 7, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$324
Enrollment Limit: 20
Program No. 5070-7378
Register Now
 
  Related Courses  
SQL - Introduction
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Fall 2014 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf

In Partnership with
American Marketing Association


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>