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.
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.
- Relational Databases
- Select Statement
- Column Aliases
- Derived Columns
- Conditional Operators
- Logical Operators
- Where Clause
- Order by Clause
- Inner, Outer, Mixed and Self Joins
- Aggregate Functions
- Having Clause
- Append, Delete and Edit Queries
Experience using Windows and a web browser.
"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.