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

Share

SQL – Intermediate/Advanced Concepts

For people who know how to write SQL statements, but want to master JOINS, UNIONS and subqueries, this course is for you. Advance your skills with some challenging problems and think outside the box! SQL Intermediate/Advanced Concepts builds on where the SQL Introduction course ends.

Lecture, demonstration, hands-on practice and instructor coaching are used in this course.

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 currently works at SDI, Inc., a digital supply chain company in Pennsylvania.  Rajani has experience in enterprise ... read more

Who Should Attend

Individuals who have taken the SQL Introduction class or have the equivalent experience.

Benefits and Learning Outcomes

  • Understand advanced SQL technique concepts such as JOINS, UNIONS, subqueries, roll-ups and groupings
  • Understand advanced database structures
  • Apply advanced concepts to understanding complex SQL queries using provided samples
  • Create advanced queries using JOINS, UNIONS, subqueries and groupings

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 experience

Testimonials

"Rajani was upbeat, funny, and enjoyable to take the class with. She was also very knowledgeable about SQL and quick to answer questions."  —  Participant, May 2021

"Rajani was wonderful. She is so knowledgeable. She makes the class fun and helps with understanding the theories behind everything she teaches."  —  Participant, May 2021

"Rajani was upbeat, funny and enjoyable to take the class with. She was also very knowledgeable about SQL and quick to answer questions."  —  Participant, May 2021

"The content was a perfect build off the Beginner/Intro course we took. Rajani is a great resource for SQL. She is great at explaining and showing what the queries are doing."  —  Participant, April 2021

"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: Friday, Dec 3 and Monday, Dec 6

Delivery Method: Live Online

Platform: Zoom

Instructor: Rajani Madeti

Fee:

$725 by Nov 19
$750 after Nov 19

CEUs: 1.4

Enrollment Limit: 20

Program Number: 5020-13900

Note: Participants will receive instructions and course links prior to the first day of class.

Registration Deadline: Dec 3

Register Now

Share

Join Our Email List

Get the latest on courses and certificates in your areas of interest.

Working...