+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, MS SQL Server 2008 Courses ? in Technical; Hi Does any one know of any good training providers for MS SQL Server 2008? I'm familiar with SQL 2000 ...
  1. #1
    Richard_Finnigan's Avatar
    Join Date
    Sep 2008
    Location
    Northolt
    Posts
    55
    Thank Post
    35
    Thanked 1 Time in 1 Post
    Rep Power
    0

    MS SQL Server 2008 Courses ?

    Hi

    Does any one know of any good training providers for MS SQL Server 2008? I'm familiar with SQL 2000 and I want to get to grips with 2008.

    Ideally I'm looking for a two or three day off site course, I have googled this and there are a large number of companies that offer this sort of training and I'm looking for some recommendations about these companies.

    I'm mainly interested in database administration.

    Regards

    Richard
    Last edited by Richard_Finnigan; 15th March 2011 at 03:25 PM.

  2. #2

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    45
    All you need is for 2010 to come out! do you mean 2008 r2? What do you want traning in exactly with it? programming? support?

  3. #3
    Richard_Finnigan's Avatar
    Join Date
    Sep 2008
    Location
    Northolt
    Posts
    55
    Thank Post
    35
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by irsprint84 View Post
    All you need is for 2010 to come out! do you mean 2008 r2? What do you want traning in exactly with it? programming? support?
    Errr yes pardon me 2008 r2 I currently use MS SQL 2000 in quite a basic way and I do most of the data processing in the Access apps that are clients of this server, so I'm mainly interested in support though I want to begin to get a handle on Transact SQL that is used in SQL 2008.

    I'm after the names of good training providers that people have used before so I can have a look at what they have got to offer.

  4. #4
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    88
    Thank Post
    1
    Thanked 18 Times in 17 Posts
    Rep Power
    48
    I was recently on an SQL 2008 Core Skills course run by Neos IT, and I have to say, I found it very useful. It covers the basics of database administration in SQL 2008, and covered some aspects of Transact-SQL and Reporting Services. It's more of a Jack-of-all-trades course, however, I believe the company can offer other courses that delve deeper into specific aspects of managing an SQL 2008 environment, you'd probably need to check this with them, and also whether they offer training across the country.

    The guy that ran the course I was on was an extremely knowledgeable and experienced DBA, and was even able to teach me a few new tricks, in spite of my being pretty clued up to start with in SQL. You can check them out here.

    And just to clarify, no I don't work for them or gain in any way by recommending them, I just had a very good experience of them within the last month or so!

    Edit:
    SQL 2008 / SQL 2008 R2 are, to all intents and purposes, the same product, R2 is more of a revision tweak on the base system. R2 is mostly concerned with improvements to the datacentre aspects of SQL, so for most customers wouldn't strictly be needed over and above the non-R2 version. The next version of SQL, possibly due out as SQL 2011 (it's currently still doing the rounds as the succinctly titled 'SQL Server code-named "Denali" ') will probably be a much more distinct product to SQL 2005/SQL 2008, since Microsoft tend to release their SQL products in "Pairs" in as much as SQL 6 and SQL 2000 were similar products, SQL 2005 and SQL 2008 and also similar products.
    Last edited by SkywOrca; 16th March 2011 at 05:44 PM.

  5. 2 Thanks to SkywOrca:

    Leeoakley (4th April 2011), Richard_Finnigan (16th March 2011)

  6. #5
    Richard_Finnigan's Avatar
    Join Date
    Sep 2008
    Location
    Northolt
    Posts
    55
    Thank Post
    35
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks for that.... I'll look them up, I guess I'll just learn some SQL 2008 and then maybe catch up with the latest version if it's very different and if those differences are worth having

    Richard

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I believe one of our new sponsors run IT courses. Check out Joskos. Not sure which forum they are sponsoring.

    EDIT: sorry my bad, the sponsor only does solutions, but i think another division / sister company does training : http://www.joskos.com/

    As for sql 2005 and 2008 being similar, i think 22,000+ schools would argue they weren't similar enough as the need for migration was a royal PITA!
    Last edited by vikpaw; 16th March 2011 at 11:39 PM. Reason: correction.

  8. Thanks to vikpaw from:

    Richard_Finnigan (21st March 2011)

  9. #7
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    88
    Thank Post
    1
    Thanked 18 Times in 17 Posts
    Rep Power
    48
    Did we ever get a full explanation from Capita on why we needed to migrate to 2008? I thought I'd heard that it was originally to leverage some improvements to the Reporting Services side of things, but that could have just been the rumour. Maybe they wanted to use the newer version of .Net framework that links to SQL 2008..?

    Either way, structurally, and from a look-and-feel point of view, the two products are "similar" but not identical. It's kind of like they took the Skoda bodywork off and replaced it with a VW, it looks a bit nicer and people might be willing to pay for the upgrade, but underneath it's the same car!

  10. #8

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,970
    Thank Post
    113
    Thanked 490 Times in 336 Posts
    Blog Entries
    2
    Rep Power
    283
    Quote Originally Posted by SkywOrca View Post
    Did we ever get a full explanation from Capita on why we needed to migrate to 2008? I thought I'd heard that it was originally to leverage some improvements to the Reporting Services side of things, but that could have just been the rumour. Maybe they wanted to use the newer version of .Net framework that links to SQL 2008..?

    Either way, structurally, and from a look-and-feel point of view, the two products are "similar" but not identical. It's kind of like they took the Skoda bodywork off and replaced it with a VW, it looks a bit nicer and people might be willing to pay for the upgrade, but underneath it's the same car!
    Here's a run down of the differences in the SQL levels.
    ALTER DATABASE Compatibility Level (Transact-SQL)
    SQL 2005 is level 90, SQL 2008 is level 100. Most of the differences are likely to be 'gotchas' where you app behaves weirdly if you made assumptions about the way the joins and unions are coded. It's an interesting read in any case.

  11. #9

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,040
    Thank Post
    374
    Thanked 372 Times in 303 Posts
    Blog Entries
    8
    Rep Power
    177
    Richard

    Are you looking to become certified, or do you just want the knowledge and training? I know a couple of good facilities (along the south coast though) that can offer this to you.

    Graham

  12. Thanks to GREED from:

    Richard_Finnigan (21st March 2011)

  13. #10
    Richard_Finnigan's Avatar
    Join Date
    Sep 2008
    Location
    Northolt
    Posts
    55
    Thank Post
    35
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Just the knowledge and training...

  14. #11

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,970
    Thank Post
    113
    Thanked 490 Times in 336 Posts
    Blog Entries
    2
    Rep Power
    283
    This is for DB2 rather than MS SQL, but it's a free course and it covers the fundamentals of relational databases.
    You need to enrol, but you're able to download the instructional videos and diagrams for off-line viewing.

    DB2 University

    Register for 'SQL Fundamentals'.
    Last edited by jinnantonnixx; 21st March 2011 at 09:08 AM.

  15. #12

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,970
    Thank Post
    113
    Thanked 490 Times in 336 Posts
    Blog Entries
    2
    Rep Power
    283
    Also, the Petri SQL section is worth its weight in gold*.
    Petri Microsoft SQL Server Center - MS SQL Tutorials & Help


    * it doesn't weigh anything, but you know what I mean.

  16. #13

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,970
    Thank Post
    113
    Thanked 490 Times in 336 Posts
    Blog Entries
    2
    Rep Power
    283
    Apologies, Richard. I've just reread the thread and see that you're familiar with SQL 2000, so the above may not be of any relevance. I'll leave the links there, as they are quite interesting anyway.

  17. Thanks to jinnantonnixx from:

    Richard_Finnigan (21st March 2011)

  18. #14
    Richard_Finnigan's Avatar
    Join Date
    Sep 2008
    Location
    Northolt
    Posts
    55
    Thank Post
    35
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Yes I've gone beyond the basics but it looks interesting from a teaching point of view so I'll check it out. Thanks Richard

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server 2008 - Automating DB Backup using the SQL Mgmt Console
    By bodminman in forum How do you do....it?
    Replies: 8
    Last Post: 24th January 2011, 02:55 PM
  2. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  3. Replies: 0
    Last Post: 25th October 2010, 08:23 PM
  4. Replies: 5
    Last Post: 21st June 2010, 10:46 AM
  5. Replies: 6
    Last Post: 15th February 2010, 09:21 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •