October 20, 2005 at 5:07 am
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
October 20, 2005 at 5:11 am
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
October 20, 2005 at 5:52 am
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
October 24, 2005 at 9:00 am
ms 2723
ms sql server 2000 for experienced pros (3 days).
October 27, 2005 at 12:07 am
i can only take 1 of the 2
October 27, 2005 at 10:34 am
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.
October 27, 2005 at 10:36 am
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.
October 30, 2005 at 1:17 am
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
October 31, 2005 at 9:59 pm
>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
November 1, 2005 at 9:51 am
ill take that into consideration
thx 🙂
November 2, 2005 at 11:02 am
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).
November 8, 2005 at 3:17 am
If you can only take one take the first and try to get the books for the second!
November 10, 2005 at 12:39 pm
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
November 12, 2005 at 9:36 am
programming it is then
November 14, 2005 at 8:05 am
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