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

Materials

Download materials

Special Note

These materials are provided for reference purposes only. The training environment that these materials use is no longer available.