Study material for Advanced Databases module inc SQL, Relational Model, ERM & TM For my next module in my masters, I am planning on studying Advanced Databases. (Long story short, the masters is designed for people with NON-CS degrees, so I have never studied databases, therefore I have literally 0 knowledge). 

The lecturer mentioned that I must have an understanding on the following concepts:


The relational Model; 
Relational Algebra (and maybe Relational Calculus); 
SQL; 
Entity-Relationship Modelling (ERM) and Enhanced ERM (we are using UML notations); 
Transactions Management; 


I'm aware that questions have been asked about study resources on the subjects, particularly SQL, but, does anyone some good resource that covers a few of the subjects mentioned? Preferably online sources (so they will keep up to date).
I found the course at Standford to be helpful - if you sign up, you can view past lectures on many of these topics.

https://class.stanford.edu/courses/Engineering/db/2014_1/info