Good Book or Training material

[Cpreston]

Hi

I have posted a few things lately which clearly as made it evident I need training in specific areas.

I know some SQL but not enough so do not want to spend a lot of money of expensive course that cover areas I already have an idea about. So my plan really is to try and source a good book that is a step by step tutorial with source code and examples (perhaps 2012) for beginners. I have googled this a lot but cannot seem to find a book with code and examples and step by step.

The I want to learn specifics in more details. For example one thing I struggle with are date formats. Also if I want dates in certain periods, or from today back 2 months etc....
I have been blessed with some good code on here but I really want to start understanding it better.

So if anyone as some good links to good books and also tutorials on specific areas that would be great.

Many thanks

 

[johnherman]

Since date formats are something that is somewhat distinctive to each database, I suggest a Transact SQL book. I used "Teach Yourself Transact-SQL in 21 Days" to get up to speed on T-SQL when I switched to a SQL Server company from an Oracle company.





==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than cognitive innovative agile big data clouds)

 

[Cpreston]

Hi

Thanks for the reply. I have found an online version of this book but cannot see what database it uses or find any links for source code etc....
Any ideas if these are available on the web or did the book come with a CD

Thanks

 

[philhege]

Transact-SQL, or T-SQL, is Microsoft's dialect of the SQL language. So you should be able to run any of the exercises on an instance of MS SQL Server (be careful of version-specific stuff, though).

A quick Google of any of the statements in the book should bring back a wealth of information.

-----------
With business clients like mine, you'd be better off herding cats.