CSCI 276 - Advanced Databases - Fall 2003

Introduction to Oracle : SQL and PL/SQL Programming

Reading Assignments and Related Course Notes

Reading Assignment Topic from Intro. to Oracle: SQL and PL/SQL Course Manuals Oracle Course Manuals
Week 1 Writing Basic SQL Statements Lesson 1
Week 1 Restricting and Sorting Data Lesson 2
Week 2 Single-Row Functions Lesson 3
Week 2 Displaying Data from Multiple Tables Lesson 4
Week 3 Aggregating Data using Group Functions Lesson 5
Week 3 Subqueries Lesson 6
Week 4 Multiple Column Subqueries Lesson 7
Week 4 Producing Readable Output with SQL*Plus Lesson 8
Week 5 Manipulating Data Lesson 9
Week 5 Creating and Managing Tables Lesson 10
Week 6 Including Constraints Lesson 11
Week 7 Creating Views Lesson 12
Week 7 Other Database Objects Lesson 13
Week 8 Controlling User Access Lesson 14
Week 8 SQL Workshop Lesson 15
Week 9 Declaring Variables in PL/SQL Lesson 16
Week 10 Writing Executable Statements Lesson 17
Week 10 Interacting with the Oracle Server Lesson 18
Week 11 Writing Control Structures Lesson 19
Week 12 Working with Composite Datatypes Lesson 20
Week 13 Writing Explicit Cursors Lesson 21
Week 14 Advanced Explicit Cursor Concepts Lesson 22
Week 15 Handling Exceptions Lesson 23