Visit uwm.edu/sce/coronavirus for current protocols and updates.

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 is a great instructor. I really enjoyed her overall approach and content. I think she does an excellent job explaining concepts as well as
delivering examples that she expands on. I really got a lot of value from her delivery of the course as well as the structure. Would love to take more
courses with her as an instructor related to data/sql etc. Just a wonderful job, very knowledgeable, and … does an amazing job supporting the
course subject matter with explanations that help with understanding what the most important takeaways are."  —  Participant, December 2021

"This is my second course with Rajani – she is great! So knowledgeable on SQL, the concepts and real-world applications. Would highly recommend
anyone to take an SQL course with her."  —  Participant, December 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

"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

"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: 2 Fri, Oct 28-Nov 4

Delivery Method: Live Online

Time: 8:30am-4:30pm CT

Platform: Zoom

Instructor: Rajani Madeti

Fee:

$725 by Oct 14
$750 after Oct 14

CEUs: 1.4

Enrollment Limit: 15

Program Number: 5020-14760

Note: Participants will receive instructions for logging into Canvas to access course materials and Zoom links several days prior to course start date.

Registration Deadline: Oct 28

Register Now

Date: Mon.; Apr. 17 and April 24, 2023

Delivery Method: In-person

Time: 8:30am-4:30pm CT

Location: UWM School of Continuing Education

Instructor: Rajani Madeti

Fee:

$725 by Apr 3, 2023
$750 after Apr 3, 2023

CEUs: 1.4

Enrollment Limit: 15

Program Number: 5020-14762

Registration Deadline: Apr 17, 2023

Register Now

Share

Join Our Email List

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

Working...