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 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

Scott Lovy

Scott Lovy

Scott Lovy is a life-long resident of the Milwaukee area. He received his B.S. in electrical engineering from UW-Platteville in 1988. He is currently employed at a benefit management solutions company, where he is able to utilize all of his ... 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.

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

Date: Mon-Wed, Sept 23-25

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Scott Lovy

Fee:

$724 by Mon., Sept. 9.
$749 after Mon., Sept. 9.

CEUs: 2.1

Enrollment Limit: 15

Program Number: 5070-12269

Registration Deadline: Mon., Sept. 23

Register Now

Share