Oracle installation: install Oracle 10g from here. You will need to register with the website. If you are a Windows or Linux user, Express Edition suffices for this course.
Oracle SQL Developer is downloadable from here for all OSes.
In CSI G12, use /usr/lib/jvm/java-6-sun-18.104.22.168 for Java path.
Oracle SQL Developer Tutorial is available here.
In SQLDeveloper, use oracle.cs.usfca.edu over port 1521, SID xe. Username is the same as your USF Connect username, and the initial password is the last 6 digits of your student ID.