National CAE Designated Institution
  • Classroom
Course Description

This course examines relational database management systems using a typical, commercial DBMS, such as Microsoft Access and/or MySQL and Oracle. Topics include data modeling, database design, implementation, forms and reports, and remote access to databases. The goal of this course is to provide students with a basic understanding of database design, implementation, and management concepts and techniques.

Learning Objectives

  1. Explain the operation of Database Management Systems,
  2. Demonstrate a basic understanding of relational data modeling, using Entity-Relationship diagrams,
  3. Design a relational database,
  4. Implement a database, using a database management system,
  5. Identify and use basic Data Manipulation Language (DML) such as insert, update, and delete records, using a database management system.
  6. Identify and use basic Data Definition Language (DDL) statements, such as create, drop, and alter database structures, using a database management system,
  7. Summarize a basic understanding of the Structured Query Language (SQL) through the use of database queries and other operations.

Framework Connections