SQL Book(s)

[saratoga172]

I am going to be taking over the SQL work for my company beginning here in about a month. They are going to put me through a week long SQL training course and allow me some support as I get up to speed but I am looking for a book in the meantime so I can read through and get some practicing in to familiarize myself with it.

Any recommendations on SQL books that can help me learn the right way. I'll be dealing with an existing database as well as looking at building out a new one when we go through our upgrade.

I've got a bit of time to learn but I'd like to get started so I can hit the ground running.

 

[KLin]

What kind of SQL? oracle? mssql? mysql? postgresql? Details please. Thanks

 

[saratoga172]

What kind of SQL? oracle? mssql? mysql? postgresql? Details please. Thanks

Dealing mostly with mssql and Oracle.

My training course will be Microsoft.

 

[KLin]

MSSQL uses T-SQL
Oracle uses PL-SQL

There are a couple of differences between the 2.

 

[cdr]

If you need some background in SQL/database design in general - rather than details of a specific system - try Database Design for Mere Mortals. It's a pretty practical and easy to read text.

 

[saratoga172]

If you need some background in SQL/database design in general - rather than details of a specific system - try Database Design for Mere Mortals. It's a pretty practical and easy to read text.

Thanks. That's what im looking for. I'll give it a read.

Sent from my Galaxy Nexus using Tapatalk 2

 

[cdr]

Also, if you have the time and patience and interest, you may at some point want to also pick up a more academic treatment that goes deeper into the formal logic and mathematical underpinnings of SQL. It can help to understand the philosophy behind it, much like algorithmic theory can help your programming.

I don't know a good text to recommend for that unfortunately. I have 'An Introduction to Database Systems' and don't really like it, but it was what was recommended to me. (I like 'Introduction to Algorithms' a lot for algorithms.)

 

[ringtail]

Anything by Rick Van der Lans

he has several SQL books.