Welcome

Welcome to the Oracle Database Administration Course home page. This is the open educational resource site for Oracle Database Administration.  Here you will find lecture notes, videos, term project and homework assignments.  Also you can download the current course syllabus. The weekly class schedule can be found here.

This course is absolutely for beginners. This is applicable for those who would want to learn Oracle Database 11g.

This course would be ideal for..

  • Students who would like to jump into the world of Database Administration.
  • Students who would like to learn about Database concepts
  • Students who would like to get into Oracle Database Administration as soon as they finish their college.

This course is mainly based on lecture slides and  video lectures. Students will develop an online airline reservation system as part of their term project. This backend system should have functional features similar to existing airline reservation systems such as Expedia, Kayak or Orbitz.

Contents

Course Description

Students in this course will develop a fundamental understanding of the tasks and issues associated with database administration including: planning, building, tuning, troubleshooting, securing and monitoring databases. Students will learn how to manage users, privileges, and resources, implement basic backup and recovery procedures and identify tuning opportunities.

Course Objectives

Upon successful completion of this course, the students will have acquired the following knowledge and skills:

  1. Understanding the problems and appropriate solutions involved in the role of database management and administration
  2. Installing, creating, configuring and maintaining an operational database
  3. Managing physical and logical database structures including users, objects and data
  4. Monitoring performance and identifying performance improvements
  5. Planning and implementing backup/recovery strategies
  6. Managing database security

Prerequisites 

Students must have successfully completed CST3604 with a grade of C or higher.

Grading Procedure

Lab Assignments 15%
Tests (2) 30%
Final 20%
Midterm 20%
Term Project 15%

 

Letter Grade A A- B+ B B- C+ C D F
Numerical Grade 93-100 90-92.9 87-89.9 83-86.9 80-82.9 77-79.9 70-76.9 60-69.9 <=59.9

Class Schedule

WEEK TOPIC HOMEWORK AND ASSIGNMENTS DUE
1 Basic Oracle Database Administration Read Slides, Download Oracle 11g
2 Oracle Storage and Settings Read Slides, Assignment 1 due, Assignment 2 posted
3 Test 1 and Review
4 SQL Review Read SQL Review, and Assignment 3 posted
5 Database Security Read handouts on Security, Assignment 3 due, Assignment 4 posted
6 Database Backup Read handouts on Backup, Assignment 4 due, Assignment 5 posted
7 Midterm and Review
8 PL/SQL introduction Assignment 5 due
9  Basic PL/SQL Commands
10  Cursors (Implicit and Explicit) Assignment 6 posted
11  Procedures
12  Review and Test 2
13  Triggers (Statement and Row level) Assignment 6 due
14  Exception Handling
15 Review and Final Exam Term project presentation