My situation is i understand the fundamentals of SQL and am just a little rusty on stuff related to joins etc.
Id just like a book which provides coverage for relational databases(information on them etc), understanding normalisation, set theory after which more complex concepts for example saved methods, cursors and so forth.
Lessons, books, anything is nice! Clearly if there's a particular book available that covers most inside a not too complicated fashion all of the better.
I suggest SQL Antipatterns by Bill Karwin, a normal contributor on Stack Overflow. It assumes a really fundamental understanding of SQL, but describes common errors and problematic design designs in SQL databases. It is extremely simple to follow, also it would be a pleasure reading through it.
If you want a far more in-depth knowledge of the idea behind SQL and relational databases, I suggest looking at SQL and Relational Theory: How to Write Accurate SQL Code by Chris J. Date. Should you appreciate a theoretical discussion of SQL and relational theory, it ought to be a really interesting read.
I have just finished reading through "Inside SQL Server 2008 T-SQL Querying" and would completely recommend it specifically if you are thinking about using Microsoft SQL Server.
It covers an unexpected quantity of the theoretical items that you mention.
It is best to this book :
For understanding relational theory, I suggest "Introducing Database Systems" by CJ Date.