IUPUI

This workshop lasts 3 hours.

Building on what was covered in SQL: Data Retrieval, this workshop is intended for anyone wants to learn how to use SQL to add, update, and delete data and learn advanced data retrieval techniques. In addition, participants will learn basic concepts of database transaction processing.

What You'll learn

Available Downloads

• use UNION to select similar types of information from unrelated tables

• use HAVING to filter results when doing grouping

• use SELF-JOINs to create a relationship between a table and itself

• use INSERT to add data to a table

• use UPDATE to modify existing records in a table

• use DELETE to delete existing records from a table

• work with transactions to control data modification operations

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• retrieve records from a single table

• use joins to retrieve records from multiple related tables

• use WHERE to search for or limit records returned by a query

• use aggregate functions and field operations

• work with null values in queries

If you don't have those skills, consider first taking the workshop:

• SQL: Data Retrieval