Course Syllabus

1. Lectures
   1. Introduction to the environment.
   2. Tables: creating, modifying, dropping. Constraints.
   3. Inserting data into tables. Part I.
   4. Retrieving data from tables.
   5. Single-row functions.
   6. Aggregate functions.
   7. Selecting from multiple tables. Joins and subqueries.
   8. Inserting data into tables. Part II.
   9. Views.
   10. Sequences, synonyms, and indexes.
   11. User privileges, roles, and profiles..
2. Projects
   1. Company database - due by 11:59pm on Monday, Sep 2, 2004.
   2. In-class project
   3. Retrieveing data from database - due by TBA.
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