OCL4 Oracle 10g: SQL and PL/SQL
CUNY Institute of Software Design and Development
The City University of New York
September 20-23, 2005, 9am-5pm
Baruch College
17 Lexington Avenue @ 23rd Street, Room 1104
Announcements |
Course Description |
Textbook |
Staff |
Schedule |
Handouts
This course will cover Oracle SQL, including an introduction to data
server technology. Topics covered will include the concepts of relational
database model and the SQL and PL/SQL 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 functions and
stored procedures in PL/SQL, which can be shared by multiple data
management applications.
Reading assingments (except for Monday's) appear on the days for which
they should be done. Descriptions of sessions
which have not yet occurred should be considered tentative.
|
DATE |
LECTURE |
PPTs |
Labs |
READING |
|
1 - T 9/20/05 |
- DBMS Overview: motivation
- The E/R & Relational Models
- oFunctional dependencies & anomalies
- oAvoiding redundancy through normalization
|
PPT |
Lab 1 |
Skim Ullman, Ch. 1 and
Ch. 2 -
Download
Acrobat Reader |
| 2 - T 9/20/05 |
- Installing Oracle
- Basic Oracle SQL: SELECT, INSERT, UPDATE, DELETE
- More complex SQL statements: Joins
|
PPT |
Lab 2 |
Chapters 1 |
| 3 - W 9/21/05 |
- SQL DDL: Creating and dropping tables and indices
- More complex SQL statements: subqueries, outer joins, set operators
|
PPT |
Lab 3 |
Chapters 2-3,5 |
| 4 - W 9/21/05 |
- Grouping/aggregation
- Referential Integrity
- Primary Keys & Foreign Keys
- Basic Oracle Security
- Transactions
- Pro*C and JDBC, if time permits
|
PPT |
Lab 4 |
Chapters 6,8 |
| 5 - R 9/22/05 |
- PL/SQL: procedures and functions on the server
- Blocks
- Stored Procedures
- Functions
- Cursors
|
PPT |
Lab 5 |
Chapter 9, up to page 350; see also:
Chapter
2 of
book on web
|
| 6 - W 9/22/05 |
|
PPT |
Lab 6 |
|
| 7 - F 9/23/05 |
- Enforcing data restrictions: constraints & triggers
- Defining triggers in PL/SQL
- Row- and table-based constraints
|
PPT |
Lab 7 |
Chapter 9, from p351 to end
|
| 8 - F 9/23/05 |
- Oracle-backed web applications
- Communicating with Oracle from CGI, PHP, & Perl
- Regular Expressions
- Oracle and XML
|
PPT |
Lab 8 |
|
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!
mpjohnson-at-gmail.com
|
