Oracle:Fundamentals of Databases

Familiarizing Yourself with the Fundamentals of Database
Identify the Database Development Life Cycle
Explore the Oracle 11g RDBMS

Creating a Preliminary Database Design
Analyze Database Requirements
Identify Key Fields
Create Entity Relationship Diagrams

Applying Normalization Techniques
Normalize Tables
Denormalize Tables

Using the SQL Commands to Work with Tables
Use the Data Definition Language (DDL) Commands
Use the Data Manipulation Language (DML) Commands

Using the PL/SQL Commands to Manipulate Data
Use the PL/SQL Blocks
Work with Packages
Create Triggers

Managing Databases
Work with Tablespaces
Create Indexes
Apply Sequences
Use Views
Use Object Relational Databases

Administering a Database
Identify Database Administrator Tasks
Create a Database
Manage Memory
Manage Processes

Managing Users and Permissions
Supplemental Lesson Managing Users and Permissions
Manage Users
Manage User Permissions

After completing this course, students will know how to:

identify the fundamental concepts of databases and familiarize yourself with Oracle 11g interface elements.
create a preliminary database design.
apply normalization techniques to a database.
use the SQL commands in the Oracle 11g interface and execute simple queries.
work with the PL/SQL commands to manipulate data.
manage databases.
administer a database.

Prerequisites

The following course or equivalent experience is required: Introduction to
Programming Using C++. Familiarity with using Windows environment, Microsoft
Office applications, or similar Office productivity applications is also
desired.