Post reply

SQL Training

  • February 16, 2014 at 12:40 pm

    #288235

    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

  • February 16, 2014 at 4:51 pm

    #1689367

    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 17, 2014 at 7:35 am

    #1689519

    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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 17, 2014 at 7:52 am

    #1689529

    You can read the stairways[/url] 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

  • February 17, 2014 at 8:14 am

    #1689537

    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

  • February 17, 2014 at 8:24 am

    #1689547

    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[/url]

  • February 17, 2014 at 8:30 am

    #1689553

    Luis Cazares (2/17/2014)

    You can read the stairways[/url] 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 17, 2014 at 10:48 am

    #1689612

    What an awesome idea for the user group. Thank you.

  • February 18, 2014 at 4:37 am

    #1689822

    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

  • February 18, 2014 at 4:39 am

    #1689823

    Thank you, I will look in to these.

    Cheers

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply