1 / 4

Lab COSC 3480 Fall 2000

Lab COSC 3480 Fall 2000. Oracle 8 Object- Relational features. ODL/OQL basics. Database Design. Embedded SQL PRO*C. Learn how to load an Oracle database from files. Learn how to define user views. Learn how to update a database. VMS. Generate SQL Plus reports.

aradia
Download Presentation

Lab COSC 3480 Fall 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lab COSC 3480Fall 2000

  2. Oracle 8 Object- Relational features ODL/OQL basics Database Design Embedded SQL PRO*C Learn how to load an Oracle database from files Learn how to define user views Learn how to update a database VMS Generate SQL Plus reports Learn how to access Oracle 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 OLAP PL/SQL Functions Procedures and Packages

  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) T=4/W=3 • Projects2: Updating a Relational Database using PRO*C --- Individual project. T=3/W=4 • Project3: Using PL/SQL --- Individual Project T=5/W=6 • Project4: ODL/OQL --- Group Project T=1/W=2

  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 / PRO*C Interface Discussion Project2 • October 2: PRO*C • October 11: PRO*C • 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

More Related