September 13, 2009 at 6:16 am
Dear All....
Greetings
Plz help me to choose...the subject for certification.I want to do DBA certification....or DATAWAREHOUSING...I'm working as WIN sys.admin since 2002..so reason beihind to switch to database side...that i was always interesetd in database side..coz i know more than enough about sql and oracle 9i.i completed all this in my 2 years diploma course...
So i need a help from you guys..that plz tell me what would be suitable for me...DBA course or Datawarehousing...
waiting for rite response.............
Thanx in advance...
September 13, 2009 at 7:52 am
m54071 (9/13/2009)
Dear All....Greetings
Plz help me to choose...the subject for certification.I want to do DBA certification....or DATAWAREHOUSING...I'm working as WIN sys.admin since 2002..so reason beihind to switch to database side...that i was always interesetd in database side..coz i know more than enough about sql and oracle 9i.i completed all this in my 2 years diploma course...
So i need a help from you guys..that plz tell me what would be suitable for me...DBA course or Datawarehousing...
waiting for rite response.............
Thanx in advance...
Download and install the trial software I think as a system admin you should start with DBA because datawarehousing is more development than admin. I think Oracle 9i is old because it is like SQL Server 2000 so you may also install Oracle 11g in your local server. The key is get books and spend time with both products.
http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx
Kind regards,
Gift Peddie
September 13, 2009 at 11:06 am
Thanx Peddie,can u tell me for DBA course from Microsoft how many exams i have to pass and what would be course title..coz i heard that M.C-DBA is discontinued.and if possible could u tell me some god books or any online training site.....
Thanx in advance..
September 13, 2009 at 12:43 pm
The first two links are for exam 70-432 the MCTS exam and the 70-450 the MCITP with the skills measured use the skilled measured page with the self prep book for each exam. You can find the books on Amazon
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-450&locale=en-us
These three links are visual installation guide for SQL Server 2008 and the use of SQL Server Management studio to perform admin tasks. When you install SQL Server it comes with the BOL(books online) in the last two links find the version in your local BOL and study SQL Server Admin with SQL Server management studio. Then you can read the book for exam 70-432 and 70-450 to get details not covered in the BOL. Then you need to buy a good practice test to prep for each exam. Good Luck.
http://sql-articles.com/index.php?page=articles/SQL2008/ins_2008.html
http://msdn.microsoft.com/en-us/library/ms188720.aspx
http://msdn.microsoft.com/en-us/library/ms174173.aspx
Kind regards,
Gift Peddie
September 14, 2009 at 7:46 am
I would go with what Gift has suggested, Datawarehouses are more specialised and it would be better for you to start with DBA first and then try datawarehousing if you want to go down that route later on.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply