Feb 15: Modifying Data

Learning Objectives

After today's class, you should be able to:

• Explain the syntax of INSERT, UPDATE, and DELETE statements.
• Use the mysql command to run scripts from the command line.

Lesson Outline

Lecture Slides: [20 min]

• SQL DML - Data Manipulation Language

CRUD Lab: [50 min]

• Soccer Database Updates

Your To-Do List

• Finish reading zyBook sections 2.8 – 2.12 and 11.4 – 11.6
• Finish working on Homework 4 (due Monday)