I recommend two authors, listed below with Amazon links to their most famous books:

C. J. Date http://www.amazon.com/Introduction-Database-Systems-C-Date/d...

Joe Celko http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp...