CSCI 276 Material

Advanced Databases: Oracle 10g -  SQL Programming

 

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

CSCI 276 - Advanced Databases: Oracle 10g - Introduction to SQL Programming.  The prerequisite is either 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 
Take this link to find out how to use the machines in OCNL 241 with your course database (This needs updating!!)
Course Reading Schedule:  (needs updating)
Link to Lesson on Correlated Subqueries:
Link to Your Current Course Grades (you must know your secret number)(this will be available later):
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.