OCL1 Oracle 8i 10g: SQL and PL/SQL
CUNY Institute of Software Design and Development
The City University of New York
Fall 2004
WF 1:30-5:30
Baruch College
17 Lexington Avenue @ 23rd Street, Room 1104
Announcements |
Labs |
Handouts |
Course Description |
Textbook |
Staff |
Schedule
- As of Monday the 18th, the class will be moving across the hall, to room 1104.
- Welcome!
This course will cover Oracle SQL, including an introduction to data server
technology. Topics covered will include the concepts of both relational and
object relational databases and the SQL and PL/SQL programming languages.
Participants will learn how to create and maintain database objects and to store
retrieve and manipulate data. In addition, they will learn to create PL/SQL blocks
of application code that can be shared by multiple data management applications.
|
Mastering Oracle SQL
by Sanjay Mishra & Alan Beaulieu
Hardcover: 492 pages
Publisher: O'Reilly
ISBN: 0596006322
2nd Edition June 2004
Distributed in class.
|
We would like the course to run smoothly, enjoyably and profitably. Feel free to let us know what you find good, interesting and fun about the course. Let us know sooner about the opposite. See us, leave us a note, or send us email. We want your feedback!
Reading assingments appear on the days for which they should be done. Descriptions of sessions
which have not yet occurred should be considered tentative.
|
DATE |
LECTURE |
SLIDES |
READING |
|
1 - W 10/13/04 |
- DBMS Overview: motivation
- The E/R model
|
PPT |
|
|
2 - F 10/15/04 |
- Database design
- The relational model
- Normalization
|
PPT |
|
| 3 - M 10/18/04 |
- Installing Oracle
- Complete Normalization
- Basic Oracle SQL
- Simple statements: SELECT, INSERT, UPDATE, DELETE
|
PPT |
Chapters 1 & 2 |
| 4 - W 10/20/04 |
- Creating and dropping tables and indices
- Join statements
- More complex SQL statements
- Subqueries
- Outer Joins
- Set-theoretic operations
|
PPT |
Chapter 3 |
| 5 - F 10/22/04 |
- Grouping/aggregation
- Referential Integrity
- Primary Keys and Foreign Keys
- Basic Oracle Security
- Transactions
|
PPT |
Chapter 4 |
| 6 - M 10/25/04 |
- Accessing Oracle in applications
- C and Pro*C
- Java and JDBC
|
PPT |
Chapter 11 |
| 7 - W 10/27/04 |
- PL/SQL: procedures and functions on the server
- Blocks
- Stored Procedures
- Functions
- Cursors
|
PPT |
"PL/SQL Language Fundamentals" |
| 8 - F 10/29/04 |
|
PPT |
|
| 9 - M 11/1/04 |
- Enforcing data restrictions: constraints & triggers
- Defining triggers in PL/SQL
- Row- and table-based constraints
- SQL and XML
|
PPT |
|
| 10 - W 11/3/04 |
- Oracle-backed web applications
- Communicating with Oracle from CGI, PHP, & Perl
- Regular Expressions
|
PPT |
Chapters 16 and 17 |
|