CSCI 570 Course Home Page

(note: this course was previously numbered CSI 276)

Advanced Databases: Oracle 10g -  SQL and PL/SQL Programming

 

This course is offered in Spring 2006 and is one of many offered here at CSU, Chico in Computer Science that will prepare you to become an Oracle Certified Professional. 

CSCI 570 - Advanced Databases: Oracle 10g - Introduction to SQL and PL/SQL Programming.  The prerequisite is either CSCI 470 (old number CSCI 273) or equivalent or experience with relational databases, including design, transactions, concurrency and SQL.  For this course you will need the Oracle Course Manual "Oracle 10g - Introduction to SQL Programming".  The instructor will tell you how to obtain your course manual. 

Course Teaching Assistant:

Important Course Links:
Course Syllabus:  

Take this link to join the Oracle Technology Network.

Take this link to download the Oracle 10g Enterprise Edition for your platform from the Oracle web site.  You will need to join Oracle Technet to do this.

Take this link to download Oracle 10g and other documentation.

Take this link for helpful "getting started with Oracle" materials

 
Take this link for instructions on how to install Oracle 10g Enterprise Edition on your Windows machine:
NEW!!Take this link for instructions on how to create your SQL course schema inside the ORCL database you created when you installed Oracle 10g.
 
Take this link to find out more about how to join the Oracle Academic Initiative 
Link to Lesson on Correlated Subqueries:
Link to Sample First Quiz - work this on your own by reading through the course manuals!
Link to a Sample Final with Answers!

 

 

Return to Melody's Home Page.