Course Syllabus

1. Lectures
   1. Normal forms and normalization process.
   2. Introduction to the environment.
   3. Tables: creating, modifying, dropping. Constraints.
   4. Inserting data into tables. Part I.
   5. Retrieving data from tables.
   6. Single-row functions.
   7. Aggregate functions.
   8. Selecting from multiple tables. Joins and subqueries.
   9. Inserting data into tables. Part II.
   10. Views.
   11. Sequences, synonyms, and indexes.
   12. User privileges, roles, and profiles..
2. Projects
   1. In class project: Company database
   2. University database part I - due by 11:59pm Sep 22, 2006.
   3. University database part II - due by 11:59pm Oct 1, 2006.
   4. In-class project
   5. Retrieveing data from database - due by 11:59pm on Sunday, Nov 12, 2006.
3. References
   • OCA/CPA Introduction to Oracle9i SQL Study Guide by Chip Dawes and Biju Thomas
   • Oracle9i: SQL with an Introduction to PL/SQL by Lannes L. Morris-Murphy

Database programming: Oracle SQL by Daniel Dementiev, Marshall University
If you have any questions or comments e-mail me