I am looking forward to working with you in this course over this term.
Success in this class can be attained by following some simple steps: Do all of
the lab assignments and turn them in on time. View all of the videos
during the term. Take all of the examinations. You are expected to spend about
10-15 hours per week for this course.
Be an active learner- which means watch the lecture attend, attend weekly
review sessions and try to understand all the concepts. Call me if you need help
or if you feel you are lost on getting started with the subject matter.
Course Topics
Week 1 Oracle Server Architecture. - Role of Databases. Introduction to the language. Foundation
Week 2 Selecting Restricting and Sorting Data - Set Theory, Query Processor and Oracle
Optimizer.
Week 3 Single Row Functions and Joins.
Week 4 Multiple Row Functions, Subqueries, Formatted Output.
Week 5 DML Statements Transaction Mgmt. Database Locking and Read Consistency.
Week 6 DDL Statements (Create, Alter) – Midterm - Constraints, Partitioned Objects, IOTs,
Clusters,
Week 8 Views, Sequences, Indexes, Synonyms - Direct Load Insert
Week 9 DDL Statements (Rename, Truncate, Drop)
Week 10 Users, Roles and Privileges - Oracle Security
Week 11 Database Recovery. Distributed Computing and Oracle, Advanced Queuing.
Week 12 Final
Be prepared to spend a minimum of 12 hours per week using and studying the course materials.
