CSCI 397C - Fall 2000
Introduction to Oracle 8: SQL and PL/SQL Programming
Reading Assignments and Related Course Notes
** Please note: This list is not complete for the entire semester. It only reflects the point we are at in the semester!
| Reading Assignment | Topic from Intro. to Oracle:SQL and PL/SQL Course Manuals | Oracle Course Manuals and Notes on Web |
| Read by August 25, 2000 | Introduction | Introduction |
| Read by August 25, 2000 | Writing Basic SQL Statements | Lesson 1 |
| Read by August 29, 2000 | Restricting and Sorting Data | Lesson 2 |
| Read by August 31, 2000 | Single-Row Functions | Lesson 3 |
| Read by September 5, 2000 | Displaying Data from Multiple Tables | Lesson 4 |
| Aggregating Data using Group Functions | Lesson 5 | |
| Subqueries | Lesson 6 | |
| Multiple Column Subqueries | Lesson 7 | |
| Producing Readable Output with SQL*Plus | Lesson 8 | |
| Manipulating Data | Lesson 9 | |
| Creating and Managing Tables | Lesson 10 | |
| Including Constraints | Lesson 11 | |
| Creating Views | Lesson 12 | |
| Other Database Objects | Lesson 13 | |
| Controlling User Access | Lesson 14 | |
| SQL Workshop | Lesson 15 | |
| Declaring Variables in PL/SQL | Lesson 16 | |
| Writing Executable Statements | Lesson 17 | |
| Interacting with the Oracle Server | Lesson 18 | |
| Writing Control Structures | Lesson 19 | |
| Working with Composite Datatypes | Lesson 20 | |
| Writing Explicit Cursors | Lesson 21 | |
| Advanced Explicit Cursor Concepts | Lesson 22 | |
| Handling Exceptions | Lesson 23 | |
| Writing Embedded SQL Applications | Dr. Callan's own presentation |