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

Find related training with our partners

Pluralsight

Pluralsight is a provider of video-based online training with a focus on more technically oriented and design focused topics.

More information

Log in now (subscribers only)

Skillsoft

Skillsoft is a leading e-learning provider with a wide range of educational services and in-depth coverage of IT and other skills.

More information

Log in now (subscribers only)

Contact us to request IT Training resources in other accessible formats.