School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted
 

Connect With Us

 
HomeCourses & ProgramsCertificate ProgramsFaculty & Staff
 

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.

Course Outline/Topics

  • Relational Databases
  • Select Statement
  • Column Aliases
  • Performing Calculations
  • Conditional Operators
  • Logical Operators
  • Nulls
  • Where Clause
  • Order by Clause
  • Expressions
  • Inner and Outer Joins
  • Aggregate Functions
  • Groupings
  • Having Clause
  • Sub Queries
  • Unions

Close ▲

Prerequisites
Experience using Windows and a Web Browser.

"Fantastic class - I enjoyed it from start to finish. This will help me greatly in my professional role. I couldn't be happier with the results. Money well spent!!!"
Student, 2013

"Excellent instructor. Encouraging and very aware of the knowledge level of the participants."
Student, 2013

  Sessions  
Tue.-Thu., Apr. 21-23, 2015
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Hannah Goodman
$674
CEUs: 2.1
Enrollment Limit: 20
Program No. 5070-7380
Register Now
 
  Related Courses  
SQL - Joins
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf

In Partnership with
American Marketing Association


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>