Visit uwm.edu/sce/coronavirus for information about spring 2021.

Share

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’s School of Continuing Education 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

Rajani Madeti

Rajani Madeti

Rajani Madeti has worked with SQL for more than 20 years and has experience in Oracle, Db2, SQL Server and MongoDB databases. She is currently an IS systems development specialist for the University of Wisconsin-Milwaukee Information Technology Services. She has ... 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

"Very good detail and knowledge of subject."  —  Pete Gnas, Network Manager, Milwaukee Police Department, 2019

"We reviewed the importance of the various joins because without having the base knowledge, the remainder of the course would have been more difficult to understand."  —  Crime Analyst, 2019

Date: Mon-Tue, May 10-11, 2021

Delivery Method: Live Online

Time: 8:30am-4pm CT

Platform: Zoom

Instructor: Rajani Madeti

Fee:

$725 by Apr 26, 2021
$750 after Apr 26, 2021

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5020-12975

Note: Participants will receive instructions and course links approximately one week prior to first class.

Registration Deadline: May 4, 2021

Register Now

Share