Last week I gave a database training in Switzerland. We had a look into relational databases, normalization theory, some good principles on database modelling, SQL language.
As of the used tools, we had an overview of Oracle 11g free database server, as well as Oracle SQL Developer tool to access the database systems. The E/R diagram toolkit we used to train on was TOAD data modeller. The previous versions of the tool were freeware, but the last implementations available are only evaluation for 2 weeks. You could try to find an old version that does the general work - database drawing, generation of SQL (as well as simple reverse engineering), creation of relations - identifying and non-identifying, as for one-to-one, one-to-many and many-to-many relationships.
In my training here I also extend the presentations with PL/SQL tips and tricks, Object relational mapping with Hibernate and JPA and few practical projects in classes.
I currently lead a course for Database programming with Java and Oracle. This is my third course with that subject, but there is a specific detail here - my trainees are not experienced developers. They are all adult who have experience in different areas - construction engineers, accountants, administrators, scientists. This makes it difficult to present the technology in a way for all of them to understand it correctly.
Except the variety of examples in all of the lectures, I have to decrease the technical level of explanations. I use to speak with less development terms and explain slowly and with an increased attention paid to the students that have less understanding on the subject. I try to combine the visual and audial techniques. I also left my email in order to provide further details on particular topics if there are blur aspects of the technology.
In the beginning of every lecture I summarize the content from the last training. I take notes of the hard parts from the lecture for every student and test his memory and acceptance with practical questions.
It seems to improve the course quality when working with juniors to med developers and have to keep up to a schedule for each subject.