Week 9 Outline
- What is a Relational Database
- How to Design a Database
- How to create a Database, Table, index, and Views
- How to Retrieve Data From a Single Table
- How to Retrieve Data From two or More Tables
- How to Insert, update and Delete Data
- How to monitor your database server
- How to secure your database
Reading Materials
PowerPoint: Lecture
Extracts taken from the following Chapters
Chapter 1, 2, 3, 4, 10, 11, 12, 17 and 18
Week 9 Activity
Alternate Link: http://dev.mysql.com/downloads/installer/
Installing MySQL Workbench:Install MySQL Community Server and MySQL Workbench Guide
Activity File:Database Lab
- Create a database
- Create 4 Tables
- Modify a Tables
- Delete a table
- Add record to a table
- Using various select statements
- Using Joins
Supplemental Materials
SQL Tutorials: https://www.w3schools.com/sql/