Introduction to SQL

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.

Course length: One month
Number of Hours: 16
Cost: $245
Course start dates: this course is offered every month, starting the first Monday

You may also take this course as part of the SQL Certificate.

Additional Course Information

Agenda

Unit 1

The Relational Database and Structured Query Language

The relational database structure
Structured Query Language
Table creation and data insertion
Defining datatypes and constraints
Creating Indexes

Unit 2

Table Management

Table management
Adding columns to a table
Deleting columns from a table
Deleting a table

Unit 3

Selecting and Retrieving Data

Creating a SELECT statement to retrieve data
Using DISTINCT to display unique values in a column
Using the AS keyword to create an alternate name for a column
Merging columns

Unit 4

Filtering Data

Creating a WHERE clause
Using comparison, character, and logical operators to match conditions
Using the IN operator to match a condition
Using the BETWEEN operator to match a condition

Cancellation Policy

Continuing Education Classes:

We understand that sometimes life happens. If you are unable to attend your class, please email Continuing-ed@uwm.edu. We will be happy to contact your instructor to let them know and provide you with any material missed.

If you cancel 8 days prior to the start of your class, we are happy to issue an account credit/voucher to you. If you do not provide an 8 day cancellation notice, you will not be eligible to receive a credit/voucher*. Unfortunately, no refunds will be provided.

*Please remember, vouchers are not issued for and cannot be used towards trips, online, or credit courses.*

In order for Continuing Education to continue to provide the community with the outreach programming that we have, all cancellations will be assessed a 6% administrative fee. If you would like to provide a donation or contribute to our scholarship fund, you can do so at check-out by adding any dollar amount to your order! You can also contact our department at continuing-ed@uwm.edu. Continuing Education is cost-recovery and relies on community donations to help support its programs.

Thank you for your continued support!

Course Detail