×

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.

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.

Instructor was very insightful and a joy to work with! Excellent class. Nice job Hannah; you are a great teacher.

— Student, 2014

Class was great and Hannah was a great teacher. Taught the material in an easy manner and also helped us relate to our jobs. I will take away a lot of good information and skills from this class to use in my job. I learned a lot. Thank You Hannah!!!

— Student, 2014

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

Tue.-Thu., Sept. 15-17

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $724

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5070-8437

Registration Deadline: Mon., Sept. 14

Register Now

Tue.-Thu., Mar. 8-10, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $724

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5070-8447

Registration Deadline: Mon., Mar. 7, 2016

Register Now

FacebookTwitterGoogle+Share