SQL: Advanced Data Retrieval and Data Modification

Learning Objectives

  • 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

Prerequisite Skills

  • 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

Materials and Files