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.
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.