what course should i take ?

  • hi

    im new to the sql server 2000 DB

    but i finished an OCP course on oracle 9 ( a very long course )

    so i know a lot about sql , design , and the hole DBA occupation.

    the thing is - my new job is giving me a choice 2 do a sql 2000 course.

    ive got 2 options :

    1. Administering a Microsoft SQLServer 2000 Database

    Topics:

    SQL Server Overview • Planning to Install SQL Server

    • Managing Database Files

    • Managing Security

    • Performing Administrative Tasks

    • Backing Up Databases

    • Restoring Databases

    • Monitoring SQL Server for Performance

    • Transferring Data

    OR

    2. Programming a Microsoft SQL Server 2000 Database

    Topics:

    SQL Server Overview

    • Overview of Programming SQL Server

    • Creating and Managing Databases

    • Creating Data Types and Tables

    • Implementing Data Integrity

    • Planning Indexes

    • Creating and Maintaining Indexes

    • Implementing Views

    • Implementing Stored Procedures

    • Implementing User-defined Functions

    • Implementing Triggers

    Programming Across Multiple Servers

    • Optimizing Query Performance

    • Analyzing Queries

    • Managing Transactions and Locks

     

  • which course should an oracle DBA take to be a sql server 2000 DBA.

    taking into consideration that ill be the only 1 taking care of the DB

  • I would take the programming one first, have your company buy you books on SQL 2K and then convince them you need to take Admin class as well....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • ms 2723

    ms sql server 2000 for experienced pros (3 days).

  • i can only take 1 of the 2

  • I just finished the 2072 course.  It was very good and informative.  I had read many books before hand.  Books are good because you always have them.  I'd say if you need to learn about SQL server take your first option 2072.  If you want to learn about optimizing tables and databases take the second course.

  • Let me add to that...some of the items are touched on in the first course you list.  But don't go into detail.  That might be ok for you.  Depends if you are going to be building database or applications or if you are just going to be managing the server.

  • ill be doing evrything

    but i think ill pay more attension in maintenance

    because DB programming is almost the same in oracle and in sql 2000

  • >because DB programming is almost the same in oracle and in sql 2000

    Boy oh boy are you in for a surprise!  Take, for instance, that SQL Server 2000 has a FROM clause (2 in actuality) in the UPDATE statement and Oracle does not... and, if you follow the tired old saw of trying to write 100% compatiable code between the two, you'll not do much in the area of truely useful code.  AND, if you use, for example, correlated sub-queries to do the updates as you would in Oracle, your code will be extremely "performance challenged".  Of course, some will say that speed doesn't matter... yeah, right... that's why there's a thousand books on how to optimize performance for both Oracle and MS-SQL Server.

    If you think that's fun, wait until you try to find the cause of your very first deadlock or why a simple update with a join is causing a 4 cpu server with 8 Gig of ram to sometimes peg all 4 cpus for 2 hours when the update should only take seconds.

    SQL is NOT SQL... the true power is in the extensions beyond ANSI for each RDBMS.

    --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)

  • ill take that into consideration

    thx 🙂

  • Hate to say it, but I think you need both.  Both are equally important, even though you wont use the second class' info as often (probably).

  • If you can only take one take the first and try to get the books for the second!

  • Take the programming class because there are so many differences between both products.  Oracle uses Number for all numeric data types  SQL Server separated them and did not implement Double.  Oracle Number is a heart stopping 21bytes there is no data type in SQL Server that is 21bytes GUID is the biggest and it is only 16bytes.  SQL Server implemented all the string functions and some proprietry ones Oracle implemented just a few.  I just got started it will take a while Oralce documentation is confusion even for people who use it every day SQL Server BOL (books online) is better than most books I know.  I don't intend to confuse you and as always happy coding.

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • programming it is then

  • Take this for whatever you feel its worth; I’m not an Oracle DBA nor have I been, just MS…

     

    Maybe it's just me, but I look at things from a different angle.  It sounds like your primary job is to keep the server up and running as well as all the maintenance that comes with it.  What it comes down to is if your server won't start you need to know how to bring it back on line, whether it is restoring the masterDB or whatever.  The programming class probably won't help you out too much in a disaster.  And it's almost guaranteed something will happen.

    Now don't get me wrong, I think the programming side is very important as well.  Someone could have written a statement that is bringing the server to it's knees and it's your job to figure out why. Or help formulate a select statement to display the correct results.

    I think you should look at it as, "What am I going to be spending most of my time on?"  Then learn all you can about that subject.  Then move on and work on your boss for more classes.  Douglas recommended the 2723 class and I think you should go that route. Then pursue the programming side.

Viewing 15 posts - 1 through 15 (of 17 total)

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