goldstone.david (2/16/2014)
HiI have done a basic 'writing SQL' training a couple of years ago. I use SSMS 12 at work and play with it at home. I can write basic SQL statements, and can go as far as creating joins, inner, left and so on. I find it difficult to explain what these are, but I kind of get it. I struggle writing with Cases, counts etc
I would like to increase my knowledge so I can write more complex queries, such as these and stored procedures, and use SSRS, case statements etc.
Can anyone recommend an SQL course either classroom based in Manchester England, or online. Not to expensive as my funds are limited for this?
Many Thanks
David
You've already had a basic introduction to SQL Server. Just open up SSMS and press the {f1} key to get to "Books Online" and lookup things like "CASE". "Books Online" (also referred to simply as "BOL" for short) usually has some examples for each item, as well. If you search for "tutorial" in BOL, you'll find an introduction tutorial for SSRS and a couple of other things, as well.
Between BOL, Google, and your imagination, you'll do well and it's all free. There are also some free tutorials online although some of them are for ANSI SQL (ww3schools.com) and others are for T-SQL (the lanugage of SQL Server and Sybase).
--Jeff Moden
Change is inevitable... Change for the better is not.