SQL – Introduction

Learning how to retrieve information from a database can be perplexing. It requires an understanding of how to query a database properly and effectively, and how to translate the question or task into the correct query. Without these skills, incorrect data and ineffective queries can result.

Learn how to properly query a database and translate questions or tasks into the correct query.

The UWM-SCE 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

Hannah Goodman

Hannah Goodman

Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more

Who Should Attend

Anyone who needs to extract data from a database. No experience necessary.

Course Outline/Topics

  • Relational Databases
  • Select Statement
  • Column Aliases
  • Derived Columns
  • Conditional Operators
  • Logical Operators
  • Nulls
  • Where Clause
  • Order by Clause
  • Expressions
  • Inner, Outer, Mixed and Self Joins
  • Aggregate Functions
  • Grouping
  • Having Clause
  • Subqueries
  • Unions
  • Append, Delete and Edit Queries

Prerequisites

Experience using Windows and a web browser.

Testimonials

"I thought the course was really informative and comprehensive. Hannah was very knowledgeable and helpful."  —  Alex Kurtz, Product Data Specialist, 2017

"This was an incredible class. I had a lot of fun learning SQL. Hannah was an excellent instructor."  —  Kristin Walters, Assistant Director, 2017

All sessions are Face-to-Face unless otherwise noted.

Date: Mon.-Wed., Oct 15-17

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee:

$724 by Mon., Oct. 1.
$749 after Mon., Oct. 1.

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5070-11024

Registration Deadline: Mon., Oct. 15

Register Now

Date: Mon.-Wed., Apr 8-10, 2019

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee:

$724 by Mon., Mar. 25, 2019.
$749 after Mon., Mar. 25, 2019.

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5070-11403

Registration Deadline: Mon., Apr. 8, 2019

Register Now

Share