INT 2081Introduction to Oracle

Prince George's Community College · 3 credits

Catalog

In this course, students learn the fundamentals of SQL using Oracle database technology. They explore the architecture and installation of Oracle systems and key concepts of relational database design, including normalization to the third normal form and comparisons with the object-oriented model. Using SQL, students write queries for metadata, create database objects with Data Definition Language (DDL), manage data with Data Manipulation Language (DML) for backups, and apply Data Control Language (DCL) for permission in managing, securing, and monitoring databases (MySQL). Additionally, they construct nested queries for optimization/high availability, formulate constraints, and develop SQL scripts for various actions used in storage engines and data-types.The content in this course provides students with the foundational knowledge and skills to prepare for Oracle Database 12c: SQL Fundamentals Exam, 1Z0-071, which is part of the Oracle Database 12c Administrator Certified Associate Certification. However, adequate preparation for this certification exam will require additional independent study.

Recent sections

Spring 2027 · 1 section

Jan 19 – Mar 8

SectionDays & timeLocationInstructor
RE01Class #437770Tu Th · 6:00 – 9:00 PMRemote REMOTENot published