The following fields are required:
Error has occurred. Please reload this page and try the operation again.
University of Milwaukee School of Continuing Education
Login Menu
Student Login Parent/Youth Login
  • Student Login
  • Parent/Youth Login
  • Home
  • Courses
  • Credentials
  • Program Areas
  • Request Information
  • Make a Payment
Search Results New Search

DTBS 0018 - SQL – Intermediate/Advanced Concepts

1033585
Facebook Twitter Instagram YouTube LinkedIn
Loading...

Course Description

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.

Course Outline/Topics

  • 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

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

Prerequisites

SQL Introduction or the equivalent experience

Who Should Attend

Individuals who have taken the SQL Introduction class or have 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

Applies Towards the Following Credentials

  • Business Analysis Certificate : Elective
  • Data Analysis Certificate : Elective
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .
University of Wisconsin - Milwaukee, School of Continuing Education

Contact Us

161 W Wisconsin Ave., Suite 6000 Milwaukee, WI 53203
sceinfo@uwm.edu

Site

  • Courses
  • Credentials
  • Program Areas

Follow Us

Facebook Twitter Instagram YouTube LinkedIn
Powered by Lifelong Learning EE
The School of Continuing Education uses cookies to help give you the best experience with our registration system. By continuing without changing your cookie settings, we assume you agree to this. Please read our cookie policy. UWM collects information from website visitors. For information on what information is collected, how this information is used, and with whom the information is shared please review UWM’s website privacy statement.

Session Time-Out

For security reasons and the protection of your personal information, your session will time out due to a period of inactivity in minute(s) and second(s). Click Extend My Session to continue. For security reasons and the protection of your personal information, your session timed out after a period of inactivity. You will be redirected to the home page.

Confirm

Alert

Processing...

Privacy Policy

Cancellation Policy

To cancel, log into your student portal, go to "Enrollment History," and select "Request Drop" next to the course. Refund eligibility depends on notice, course type, and fee:

  • 30+ days prior to start of course: Full refund.
  • 15-29 days prior to start of course: Refund minus a 25% administrative fee.
  • Less than 15 days prior to start of course: No refund.

Exceptions (No Refunds):

  • Osher Educational Travel/Go Explore and College for Kids & Teens courses.
  • Courses with a fee of $35 or less.
  • On-demand online courses after the student has accessed the learning environment.
  • Conferences/Special Events (specific policy will be in registration terms).
  • Special requests and non-course fee items (e.g., memberships, textbooks) are non-refundable.

If the School of Continuing Education cancels a course, a full refund will be issued.

Invoicing Policy

  • If "invoice full amount" is selected, payment is due 14 days before the course start.
  • Failure to pay by the due date may result in cancellation of your registration.
  • For Agency payments (AmeriCorps, DVR, MyCAA, etc.), contact sceinfo@uwm.edu for next steps.
  • Automated payment reminders will be sent until the balance is paid.

Third Party Expenses

The School of Continuing Education does not provide refunds for any expenses (such as travel, accommodations, or materials) incurred by students due to a course cancellation or a student's self-cancellation. We strongly recommend booking refundable/transferable travel and accommodations, and purchasing materials with a return window extending beyond the course start date.

Collections Policy

Participants who fail to make timely payments agree to pay all collection costs incurred by UWM (agency fees, legal fees, etc.) and any late fees. UWM may also certify the past-due balance to the Wisconsin Department of Revenue and claim the total due against any refunds or payments owed to the participant.

Photography and Media Usage

The School of Continuing Education may take photographs, video, and other media during courses and events for educational, promotional, and advertising purposes. Virtual programs may be recorded for marketing and content sharing.

Conduct Information and Disciplinary Measures

No firearms or weapons are allowed on UWM property.

Participant conduct policies are based on the following UW System Administrative Codes, which may result in probation, suspension, or dismissal from all UWM functions:

  • UWS Chapter 14 – Student Academic Disciplinary Procedures
  • UWS Chapter 17 – Student Nonacademic Disciplinary Procedures
  • UWS Chapter 18 – Conduct on University Lands

Cookie Policy

Cookie policy

This statement explains how we use cookies on our website. For information about what types of personal information will be gathered when you visit the website, and how this information will be used, please see our privacy policy.

How we use cookies

All of our web pages use "cookies". A cookie is a small file of letters and numbers that we place on your computer or mobile device if you agree. These cookies allow us to distinguish you from other users of our website, which helps us to provide you with a good experience when you browse our website and enables us to improve our website.

Types of cookies we use

We use the following types of cookies:

  • Strictly necessary cookies- these are essential in to enable you to move around the websites and use their features. Without these cookies the services you have asked for, such as signing in to your account, cannot be provided.
  • Performance cookies- these cookies collect information about how visitors use a website, for instance which pages visitors go to most often. We use this information to improve our websites and to aid us in investigating problems raised by visitors. These cookies do not collect information that identifies a visitor.
  • Functionality cookies- these cookies allow the website to remember choices you make and provide more personal features. For instance, a functional cookie can be used to remember the items that you have placed in your shopping cart. The information these cookies collect may be anonymized and they cannot track your browsing activity on other websites.

Most web browsers allow some control of most cookies through the browser settings. To find out more about cookies, including how to see what cookies have been set and how to manage and delete them please visit http://www.allaboutcookies.org/.

Specific cookies we use

The list below identify the cookies we use and explain the purposes for which they are used. We may update the information contained in this section from time to time.

  • JSESSIONID: This cookie is used by the application server to identify a unique user's session.
  • registrarToken: This cookie is used to remember items that you have added to your shopping cart
  • locale: This cookie is used to remember your locale and language settings.
  • cookieconsent_status: This cookie is used to remember if you've already dismissed the cookie consent notice.
  • _ga_UA-########: These cookies are used to collect information about how visitors use our site. We use the information to compile reports and to help us improve the website. The cookies collect information in an anonymous form, including the number of visitors to the website, where visitors have come to the site from and the pages they visited. This anonymized visitor and browsing information is stored in Google Analytics.

Changes to our Cookie Statement

Any changes we may make to our Cookie Policy in the future will be posted on this page.