Just taken the SCWCD exam for the third time and have passed at last with a score of 76%, not great but passing is what counts.
Materials I used:
Charles Lyons book - comprehensive but lost me a few times
HFSJ - very good resource, read the parts that I didn't understand from Charles Lyons book
Enthuware exam simulator - pretty close to the exam, helped a lot
Now it's time for either the Spring or Oracle SQL Certified Expert exams.