Module 5: Structured Query Language II

CMPS 160: Databases

Introduction

In the previous module we saw how a relational database allows one to store data in a consistent manner. In this module, we will look at how the relational structure is created in practical terms and how data is inserted, removed, updated, and queried. All of these operations are performed by using one ubiquitous tool: the Structured Query Language (SQL). This (mostly) declarative programming language has been around since the seventies and is used in virtually all relational databases (and even NoSQL databases). Over the years, many changes have been made to the language that have been captured in the different versions of the SQL standard. After studying this module, you should be able to use SQL and have a good idea of its capabilities.

Module Objectives

  • Learn basic SQL statements for creating database structures
  • Learn basic SQL statements for adding data to a database
  • Learn basic SQL SELECT statements and options for processing a single table
  • Learn basic SQL SELECT statements for processing multiple tables with subqueries
  • Learn basic SQL SELECT statements for processing multiple tables with joins
  • Learn basic SQL statements for modifying and deleting data from a database
  • Learn basic SQL statements for modifying and deleting database tables and constraints

Learning Resources

  • Module 5 Readings: Chapter 3
  • Module 5 Slides: Chapter 3

Learning Activities

  • Module 5 Assignment: Chapter 3 Heather Sweeney Case Questions

For Further Study

It is highly recommended to work through the exercises at the end of the chapter, specifically:

  • 3.19 – 3.51

Leave A Reply

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