David E. Goldschmidt, Ph.D.

course syllabus

course description

This course covers advanced topics in PL/SQL, including regular expressions, performance tuning and optimization, object-oriented programming, and integration with Java. Students are expected to have at least a general understanding of PL/SQL basics, including such topics as cursors, procedures, functions, packages, and triggers.

course schedule

Course meets for four sessions: Wednesday 10/28, Wednesday 11/4, Friday 11/13, and Wednesday 11/18 from 9:30am-12:00pm. All classes meet in EBA 664.

required software

We will use JDeveloper 10.1.3, TOAD, and SQL*Plus in the lab to develop and execute Java and PL/SQL programs. We will also use Oracle Express (XE) as our sample database. All software packages are available via free download.

topics

• Brief review of PL/SQL, Cursors, Procedures, Functions, Triggers
• Java and JDBC
• Java and PL/SQL
• PL/SQL Performance
• Tuning PL/SQL Code

Books on Java

Search for "java" using Google or visit http://java.sun.com for additional resources and tutorials on Java.

I also recommend the following books, though I'd suggest you browse Borders or Barnes & Noble to find a book you like:

• Java in a Nutshell by David Flanagan: Great resource, though it doesn't take long for it to become out-of-date.
• Java Examples in a Nutshell by David Flanagan: Lots of example code useful to learning Java and applying it to meet your needs.
• Head First Java by Kathy Sierra and Bert Bates: Highly interactive book covers Java well.

Office:	Albertus Hall 400-2
Office Hours:	Wednesdays 1-2:30pm and by appointment
Email:	goldschmidt@gmail.com
Phone:	518-485-3755 (on campus x3755)

PL/SQL and Java Resources

• Installing and using Oracle XE

• Installing and using JDeveloper
• Connecting to Oracle via JDeveloper

• Using Java/JDBC with Oracle [ppt]

• Day 1 Examples
• Day 2 Examples
• Day 3 Examples
• Day 4 Examples

Books on PL/SQL and JDBC

I recommend the following books, though I'd suggest you browse Borders or Barnes & Noble to find a book you like:

• Oracle PL/SQL Programming by Steven Feuerstein and Bill Pribyl: Comprehensive resource.
• Learning Oracle PL/SQL by Bill Pribyl: Excellent getting-started (and reference) guide.
• Oracle PL/SQL Best Practices by Steven Feuerstein: Beyond the basics, this book covers how to write robust PL/SQL code that is easier to maintain; also covers performance tuning.
• Oracle JDBC by Donald Bales: Excellent resource on how to use Java and JDBC to communicate with Oracle.