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 - Intermediate/Advanced Concepts New Class

 

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

Close ▲

Benefits and Learning Outcomes

  • After completing this course you will be able to solve complicated problems, beyond the introductory level, through hands-on experience 

Close ▲

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

Close ▲

Prerequisites
SQL Introduction or the equivalent
  Sessions  
Tue.-Wed., Nov. 11-12
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: To Be Announced
$549
CEUs: 1.4
Program No. 5070-7781
Register Now
 
Wed.-Thu., May 13-14, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: To Be Announced
$549
CEUs: 1.4
Program No. 5070-7780
Register Now
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Spring 2015 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>>