Title: Relational Databases and MySQL
Course: COP 2842 Internet Programming > Section: Three: Relational Databases and MySQL

Introduction

Before you can use PHP to work with a MySQL database, you need to be familiar with the concepts and terms that apply to relational database systems.  You should be able to review the structure and data in the databases that you will be working with.  After you learn the concepts and terms, you will learn how to use a web application called phpMyAdmin to work with a MySQL database.

Learning Outcomes

By the end of this section, you will be able to:

- Recognize relational database terminology
- Execute SQL statements
- Display data on a web page

Instructional Objectives

Upon completion of this module, you will be able to:

- Execute INSERT, UPDATE, and DELETE statements
- Extract data from result sets
- Implement PHP and MySQL Database

Reading / Resource

Read:

- Chapter 3: Introduction to relational databases and MySQL (Pages 94-120)