Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Training Expand / Collapse
Author
Message
Posted Sunday, February 16, 2014 12:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 4:38 AM
Points: 3, Visits: 3
Hi

I 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
Post #1541925
Posted Sunday, February 16, 2014 4:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 37,104, Visits: 31,658
goldstone.david (2/16/2014)
Hi

I 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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1541945
Posted Monday, February 17, 2014 7:35 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 15,738, Visits: 28,146
Track down a local user group and attend their meetings. There are also SQL Server events in the UK that are free. There are SQL Saturday events and SQL Relay and SQL Bits has a community day, that I think is free (not sure about that, so don't throw rocks if I'm wrong). Those are all excellent venues to continue and expand on your learning as well as start to network with others.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1542127
Posted Monday, February 17, 2014 7:52 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 3,664, Visits: 7,995
You can read the stairways in this site, as well as the articles. You can try to solve problems from the forums even if you don't post the answer but you can compare it with the others.
You could also invest and buy a book as many people like to do. I haven't bought one for T-SQL, so I'm not sure which one I could recommend.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1542137
Posted Monday, February 17, 2014 8:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 43,045, Visits: 36,205
Luis Cazares (2/17/2014)
You could also invest and buy a book as many people like to do. I haven't bought one for T-SQL, so I'm not sure which one I could recommend.


T-SQL Fundamentals by Itzik Ben-Gan



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1542145
Posted Monday, February 17, 2014 8:24 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 2:34 PM
Points: 1,458, Visits: 3,003
There is a SQl Server user group in Manchester try going to this.

http://sqlserverfaq.com/events/595/Introducing-SQL-Server-with-Martin-Bell-and-Chris-TestaONeill-Bring-a-Friend-Wednesday-night-Meeting-at-Swinton-Insurance.aspx


Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #1542155
Posted Monday, February 17, 2014 8:30 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 15,738, Visits: 28,146
Luis Cazares (2/17/2014)
You can read the stairways in this site, as well as the articles. You can try to solve problems from the forums even if you don't post the answer but you can compare it with the others.
You could also invest and buy a book as many people like to do. I haven't bought one for T-SQL, so I'm not sure which one I could recommend.


+10million


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1542161
Posted Monday, February 17, 2014 10:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 4:38 AM
Points: 3, Visits: 3
What an awesome idea for the user group. Thank you.
Post #1542227
Posted Tuesday, February 18, 2014 4:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:37 AM
Points: 299, Visits: 561
Given that you are in Manchester you should look at the surounding universtities as well. Some universities have a Microsoft IT academy which will run certain SQL server courses. These are the same as offered by corporate training companies like QA but at a much reduced price.

Depening on your current income you may also be ellidible for an Individual Learning Account (ILA) from the government which from memory pays out up to £300 per year to be used for further education.

I used this a few years ago to part fund my degree at Paisley University in Scotland, you would need to look into if this is available for you in England as well.


MCITP SQL 2005, MCSA SQL 2012
Post #1542477
Posted Tuesday, February 18, 2014 4:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 4:38 AM
Points: 3, Visits: 3
Thank you, I will look in to these.

Cheers
Post #1542479
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse