Nov 22, 2024  
2019-2020 Catalog 
    
2019-2020 Catalog [PAST CATALOG]

CTP 145 - Relational Databases and SQL

4 credit hours - Four hours of lecture / directed laboratory weekly; one term.
Formerly CSI 172 - Relational Databases and SQL

Learn the fundamental concepts of database systems including design, implementation, and security using Oracle. Learn to create a database, build various database objects, and manipulate data using the structured query language (SQL). Use this universal database programming language to write simple and complex queries to retrieve, insert, update, delete, and filter information in the database. This course is the first in the series of Oracle database administration courses and addresses the core material of both the SQL Fundamentals and the SQL Expert certification exams needed to become an Oracle Certified Associate. Lab fees reduced for this course. Refer to Course Fees .

Prerequisite(s): CTP 103  or permission of the CTP department chair.