# Module 11: Update Data

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
[https://teamacademy.help.center/article/1374-module-12-advanced-mysql-features]
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.