Results 1 to 13 of 13
  1. #1
    Join Date
    May 2006
    Posts
    65

    Unanswered: Right- i need training!!

    Hi all,

    my collegue is leaving, his masters in computer science has ensured he has solved most problems we've encountered iver two years...

    now im told i need at least a few training sessions under my belt to take over parts of his job.

    Basically i need sql server traing and vb but am confused as where to start, a lot of the courses ive looked at assume you have knowledge in certain areas, my problem is i have loads of gaps as ive learnt on the job so need some recommendations- are any of the MS courses geared to people like me or do you need a foundation in the subject....ive read stuff like SAMS teachyourself SQL and found it just doesn't go deep enough....too many examples are just skimmed over....it also doesn't teach you the kind of things i learn here....

    im happy to go on a course which repeats stuff i already know whilst teaching me the fundamentals but can only seem to find course geared to specific job roles which require prior knowledge- so where did you guys start? im in the UK btw

    greg

  2. #2
    Join Date
    Jun 2004
    Posts
    50
    I found a good book called "SQL Server 2000 Programming by Example" at Half Price Books. The isbn is 0-7897-2449-9. It's a bit dated, but if you're working with SQL Server 2000, then I say T-SQL is T-SQL.

    hth and cheers.
    Monk
    The person who confesses ignorance shows it once; the person who conceals it shows it many times.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I learned on the job, and I read the manuals cover to cover, no matter how boring (or I did, way back in the day when you actually got a manual).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I read Books Online. If you read it and work through the examples, you'll have a really good understanding of T-SQL and MS SQL Server when you are done. I also like any book by Ken Henderson or Kalen Delaney.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, you have many opportunities with the latest CYBER avaiability on web such as GOOGLE and other search engines. Review the content as suggested below and keep in touch with forums, even by referring to the questions posted you will learn a lot.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    May 2006
    Posts
    65
    nice one, will look at those suggestions,.

    i also found this:
    MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 System Administration, Exam 70-228, Second Edition

    looks like it could teach me a lot.

    so are you guys dba's? or have you gone further?

    greg

  7. #7
    Join Date
    May 2006
    Posts
    65
    derrick did you buys these online books or are they available to view?

    greg

  8. #8
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Books Online is free. Start/Programs/Microsoft SQL Server/Books Online.

    The books by Kalen Delaney and Ken Henderson are available online at any bookstore website. I like bookpool.com personally.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    hey, just ask your questions here....we always like puzzles...just read the hint sticky at the top of the forum....

    as for vb...sorry...you shouldn't have to be a backend AND front end guy
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jul 2004
    Location
    Edmonton, Canada
    Posts
    72
    Quote Originally Posted by dubs
    i also found this:
    MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server™ 2000 System Administration, Exam 70-228, Second Edition
    From the sounds of things, you may want something more along the lines of database developer, as opposed to architect/dba

    If I'm wrong, then it might be what you're looking for.

    Carl

  11. #11
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can download updated Books ONline BOL from http://www.microsoft.com/downloads/d...DisplayLang=en here.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  12. #12
    Join Date
    May 2006
    Posts
    65
    Hi,

    bit of an update, my boss would like me to become a mcdba so i can handle pretty much anything that happens with the IT team(we have two mcse's here too).

    Therefore i need to understand architecture, procedures, standard practices and developing but not to a hugely in-depth level....i work at a school so alot of the coding is pretty straight forward and we dont have huge number of records:

    essentially:
    daily maintenance: backups, transactions, security, users, t-sql, server 2000/2003/2005 differences etc etc - hardware end

    database developing: our off-the-shelf doesn't work properly (no primary keys) so a new database needs to be created module by module, this has been done but now the author is leaving. need to understand the logic behind his practices- covers the coding end.

    the mcdba looks to cover all of this, may be overkill but it cant hurt to be over qualified (and they are paying!!) - so am looking to do the prerequisite course which focuses on t-sql....

    therefore i think looking through the books mentioned will help no end, ive got exam questions for the various modules to give me an idea of what they expect....guess my answer is can i expect to pass with no previous formal computer training- happy to work my arse off but am hoping the course wont be to in-depth for me to progress in it.

    cheers
    greg

  13. #13
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Congratulations. It should be an exciting time for you. Since you are studying for the official certs, check out the free training on the microsoft website right now. They are offering tons of courses now, with the ramp-up of 2005.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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