SQL - Introduction - School of Continuing Education, University Of Wisconsin

	SQL - Introduction

	Learning how to retrieve information from a database can be quite 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. This course will teach your how to properly query a database and translate questions or tasks into the correct query.
Course Outline/Topics ▼ Topics Include: 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
	"I enjoyed how the course was set up. Goodman presents the material, then has attendees do examples as a group, and then as individuals. This is a very helpful way to learn the material." -- student, SQL Introduction, 2012



	Tue.-Thu., Nov. 12-14 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Hannah Goodman Fee: $674 CEUs: 2.1 Program No. 5071-6223 Add To Registration Form Check Registration Form

	Tue.-Thu., May 13-15, 2014 8:30am-4:30pm Location: UWM School of Continuing Education (Click link for directions) Instructor: Hannah Goodman Fee: $674 CEUs: 2.1 Program No. 5071-6253 Add To Registration Form Check Registration Form


	SQL - Joins

	For more information, contact:
		Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208

IT Certificate Programs Brochure

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