Module 11: Update Data

Markdown

View as Markdown

Module Overview

This module introduces data modification operations in MySQL and explains how to update existing records within database tables.

Learners will understand how to use the UPDATE statement to modify stored information and apply conditions to ensure that the correct records are updated.

The module also covers UPDATE JOIN, which allows learners to update records in one table using related information from another table.

These concepts help learners maintain accurate database records and manage changing business information through SQL operations.

What Will Be Covered

11.1 UPDATE

  • Understanding the purpose of the UPDATE statement in MySQL.

  • Exploring the basic syntax of UPDATE.

  • Modifying existing values in database table columns.

  • Using SET to assign new values to columns.

  • Applying WHERE conditions to update specific records.

  • Updating multiple columns within a single statement.

  • Understanding the importance of using appropriate conditions to avoid unintended changes.

  • Verifying updated records using SELECT queries.

11.2 UPDATE JOIN

  • Understanding the purpose of UPDATE JOIN in MySQL.

  • Exploring how UPDATE JOIN connects related tables during an update operation.

  • Using INNER JOIN with UPDATE statements.

  • Updating records based on matching values between tables.

  • Applying table aliases in UPDATE JOIN queries.

  • Understanding how related table information can be used to modify existing records.

  • Applying UPDATE JOIN to manage related business information across multiple tables.

Skills You Will Gain

  • Understanding MySQL data modification operations.

  • Updating existing records using SQL statements.

  • Modifying single and multiple columns using UPDATE.

  • Applying WHERE conditions to target specific records.

  • Working with UPDATE JOIN to modify related table information.

  • Using table aliases in update queries.

  • Verifying changes made to database records.

  • Managing changing business information through SQL operations.

Learning Outcomes

By the end of this module, learners will be able to:

  • Modify existing business records such as customer details, employee information, product prices and transaction statuses.

  • Update specific database records using appropriate WHERE conditions.

  • Modify multiple column values within a single UPDATE statement.

  • Use UPDATE JOIN to update records based on related information stored in other database tables.

  • Maintain accurate and consistent information across related database tables.

  • Identify the impact of update operations before applying changes to important business records.

  • Develop SQL update queries to support routine database maintenance and changing business requirements.

Certification Alignment

This module develops MySQL data modification knowledge that supports the broader learning pathway towards the Oracle Certified Professional, MySQL 5.6 Database Administrator certification referenced in the course brochure.

The topics covered help learners understand UPDATE statements, conditional record modification and joined table update operations within MySQL databases.

Continue to the Next Module

Continue to Module 12: Delete Data to learn how to remove records using DELETE JOIN, manage related records using ON DELETE CASCADE and remove all records from tables using TRUNCATE TABLE.

Was this article helpful?

Still need help?

Contact us