lab cosc 3480 fall 2000 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Lab COSC 3480 Fall 2000 PowerPoint Presentation
Download Presentation
Lab COSC 3480 Fall 2000

Loading in 2 Seconds...

play fullscreen
1 / 4

Lab COSC 3480 Fall 2000 - PowerPoint PPT Presentation


  • 108 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Lab COSC 3480 Fall 2000' - aradia


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide2

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

projects fall 2000
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
lab lecture schedule
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