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.

(Description continued below)

Participants will:

• 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

The following workshops are suggested prerequisites to this workshop:

• SQL: Data Retrieval

Participants should already be able to:

• 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