INT-2081 Introduction to Oracle

Credits: 3
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.

Prerequisite(s): INT-2080

Course Outcomes

Install Oracle software.
Explain the major tasks of database design.
Compare and contrast the relational database model vs. the object-oriented model.
Develop a database to the third normal form.
Create database tables/views using Data Definition Language (DDL).
Formulate database constraints.
Develop database records using Data Manipulation Language (DML).
Create SQL queries and scripts.
Construct nested queries.
Implement the Data Control Language (DCL).