While not Oracle specific Introduction to SQL: Mastering the Relational Database Language by Rick Van Der Lans is the gold standard in SQL books. While it does not assume much knowledge beforehand, it is absolutely brilliant if you have a working know-how of the basics.
SQL syntax is not all that difficult, if you complete those courses you are ready to start on what I consider intermediate level SQL topics. Thus, I would reccomend this book for the person who knows the general syntax but wants to get into more complicated query's:
If you have the basics down it would behove you to find out what DBMS your new job will be using and then glance through the functions they have built in. At my job I use Oracle and MSSQL and jumping from one to the other is still annoying because the functions behave differently and are sometimes called something completely different.
From there, it really is about working in a production environment. A database like Northwind is completely different from anything you will experience at your job. Knowing the data you are working with is just as important as knowing SQL syntax IMHO. If your company keeps a metadata repository go look through that so you know what columns are and how they tie into other tables.