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.
"Hannah Goodman did a wonderful job explaining such an in depth process. She was pleasant, personable, funny, and very knowledgeable." — Student, 2015
"Fabulous instructor!!! Her teaching techniques are amazing!" — Student, 2016