Lab COSC 3480 Fall 2000

1
Lab COSC 3480Fall 2000
2
Oracle 8 Object- Relational features
ODL/OQL basics
Database Design
Embedded SQL PROC
Learn how to load an Oracle database from files
Learn how to define user views
Learn how to update a database
VMS
Learn how to access Oracle
Generate SQL Plus reports
Learn how to write SQL Queries
Developer 2000 reports
Learn how to define tables
Developer 2000 Datablock Forms
PL/SQL Cursors
PL/SQL Triggers
Learn PL/SQL basics
PL/SQL Functions Procedures and Packages
OLAP
3
PROJECTS FALL 2000

• Project1 Design a Relational Database, Fill it
  with Data, Write Queries --- Group Project what
  is learnt Database Design and E/R, Database
  Loading, Define Relational Schema, Write
  SQL-Queries, Define Views) T4/W3
• Projects2 Updating a Relational Database using
  PROC --- Individual project. T3/W4
• Project3 Using PL/SQL --- Individual Project
  T5/W6
• Project4 ODL/OQL --- Group Project T1/W2

4
Lab Lecture Schedule

• Sept. 11 Lab Information Account Access Oracle
  Basics Explanation of Project1
• Sept. 13 Introduction to Oracle Create Tables
  Loading Tables
• Sept. 18 Writing SQL Queries
• Sept. 20 Views
• Sept. 25 More on SQL Queries / PROC Interface
  Discussion Project2
• October 2 PROC
• October 11 PROC
• October 16 Introduction to PL/SQL
• October 23 Cursors in PL/SQL
• October 25 PL/SQL Functions and Queries
  Project3
• October 30 Writing Complex Queries in Oracle
• November 1 Constraints and Triggers in Oracle
• November 8 Constraint and Triggers in Oracle
  Project4