This course takes material from the following books:
"Understanding Relational Database Query Languages", Suzanne W. Dietrich, Prentice Hall, 2001
"Database Systems - A practical Approach to Design, Implementation and Management", 4th. Edition, Connolly and Begg, Addison Wesley, 2005
"Database Solutions - A step-by-step guide to building databases", Connolly,T., Begg, C., 2nd Ed. Pearson (Addison Wesley) 2004.
"Access Database Design and Programming", 2nd Ed. Steven Roman, O'REILLY, 1999.
"SQL Visual QuickStart Guide", Chris Fehily, Peachpit Press, 2002
Sunderraman, R. 2003. Oracle 9i programming A Primer, Boston MA: Addison Wesley
Shah, Nilesh, 2001 Database Systems using Oracle - A simplified guide to SQL and PL/SQL, Prentice Hall.
8. Bobrowski, S. 2006. Hands-on Oracle Database 10g Express Edition for Windows, Oracle Press, McGraw Hill / Osborne.
9. Abramson, I., Abbey, M., Corey, M. 2004 Oracle Database 10g A Beginner’s guide Oracle Press, McGraw Hill / Osborne
Others may be added later.
Query analyser that you can use at home SQLrunner - search for it to see if you can find it and practice at home.
To practice your SQL, try SQLZOO.NET
For certification exam 1Z0-007 Introduction to Oracle9i: SQL®, you need to know the following: SQL Requirements.pdf