Database and Programming Certificate (ORACLE)

18 Hours

Semester I

Course Description

This course is a study of basic computer components and peripherals, basic computer functions, i/o concepts, storage concepts, data communications, distributed processing, and programming language concepts.

Classroom Hours: 3


XE1
Credits: 3

Course Description

Elective

Classroom Hours: 3


*Elective should be chosen from CPT 167 or CPT 236

Semester II

CPT 200
Credits: 3

Course Description

This course introduces the concepts of entities, attributes, and relationships to create
data models that represent the “ideal database system” by generating ER Diagrams,
Business rules, and Normalization.

Classroom Hours: 3

Course Prerequisites

CPT 104 with a grade of “C” or better


CPT 201
Credits: 3

Course Description

This course includes the transformation of a conceptual data modal into a logical database model by mapping the ER Model into the Software Development Life Cycle (SDLC) to create a Database.

Classroom Hours: 3

Course Prerequisites

CPT 200 with a grade of “C” or better


CPT 202
Credits: 3

Course Description

This course is an introduction to writing basic Structured Query Language (SQL) used in creating tables, inserting data, retrieving data, and manipulating data from a database.

Classroom Hours: 3

Course Prerequisites

CPT 201 with a grade of “C” or better


CPT 203
Credits: 3

Course Description

This course focuses on advanced SQL programming by creating constraints, views, indexes, synonyms, and/or data security by creating SQL projects.

Classroom Hours: 3

Course Prerequisites

CPT 202 with a grade of “C” or better