SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Training


SQL Training

Author
Message
goldstone.david
goldstone.david
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 7
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
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)SSC Guru (378K reputation)

Group: General Forum Members
Points: 378850 Visits: 42941
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)

Group: General Forum Members
Points: 162255 Visits: 33199
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Luis Cazares
Luis Cazares
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72711 Visits: 20468
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.
General Disclaimer:
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?


How to post data/code on a forum to get the best help: Option 1 / Option 2
GilaMonster
GilaMonster
SSC Guru
SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)

Group: General Forum Members
Points: 413259 Visits: 47124
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, MVP, M.Sc (Comp Sci)
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


Carolyn Richardson
Carolyn Richardson
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4139 Visits: 3577
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
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)

Group: General Forum Members
Points: 162255 Visits: 33199
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
goldstone.david
goldstone.david
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 7
What an awesome idea for the user group. Thank you.
RTaylor2208
RTaylor2208
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5275 Visits: 1295
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
goldstone.david
goldstone.david
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 7
Thank you, I will look in to these.

Cheers
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search