Module 4: SQL Commands

CMPS 160: Databases

Introduction

In this module, we will learn about how to insert, update and utilize delete statements in SQL (Structured Query Language) in MySQL Workbench.

Module Objectives

  • Create a copy of the table that can be used for testing INSERT, UPDATE, and DELETE statements.
  • Learn the specifications for an action that modifies data.
  • Learn the default behavior when an INSERT, UPDATE, or DELETE statement is executed.

Learning Resources

  • Module 4 Readings: Chapter 5
  • Module 4 Slides: Chapter 5

Learning Activities

  • Module 4 Quiz: Chapter 5

For Further Study

1 comment on “Module 4: SQL Commands”

  1. Mark Voortman Reply

    I’m not claiming they are easy, so let me help you out. I’ve set up the MySQL server for you. You can continue with installing the MySQL Workbench and then follow the videos above. I will send your password by email.

Leave A Reply

Your email address will not be published. Required fields are marked *