For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA.
View 13 RepliesI've been working with SQL for close to a year now and I'm wondering if its worth the time and money to become certified. Are DBA's still on the up and rising or another job that will be outsourced to India?
View 3 Replies View RelatedHi
I am wanting to take the 70-228 and 70-229 exams. Does anyone who has already passed them have any recommendations for the best / most complete books for studying them? Opinions seem so varied on Amazon...
Thx
Des
Hi,
I have been a DBA for about 5 years now but I have never considered getting MCDBA certification until now..
Is it worth doing?
Whats the best way to revise for the exam? i.e are there any free online tests ect?
Can anyone tell me how many questions there are in the exam and what the pass rate is please.
Also can anyone tell me the nature of the questions that are asked or anything else that might help please.
Kind Regards
Rob
Is it worth studying towards an MCDBA (hopefully going to get myemployer to pay for it) ... has anyone completed it in the UK? if sowhat learning methods did you use(ie Boot Camp, elearning etc)? Andwho do you recommend for the training course?ThanksChris Longstaff
View 1 Replies View Relatedhi Everybody,
I am sitting for the Microsoft MCTS eaxm(70-528:Web Based Client Development) next week.
I have a confution regarding the question below.
THE QUESTION:
You create a Web Form. The Web Form allows users to log on to a Web site. You implement the
login logic using a Login control named Login1.
The membership data for the application is stored in a SQL Express database in the App_Data
directory.
You need to configure your application so that the membership data is stored in a local Microsoft
SQL Server database.
You add the following code segment to the Web.config file.
<membership defaultProvider="MySqlProvider">
<providers>
<add name="MySqlProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="MySqlProviderConnection"/>
</providers>
</membership>
Which two additional actions should you perform? (Each correct answer presents part of the
solution. Choose two.)
The six options are:
A. Use Aspnet_regsql.exe to create the Microsoft SQL Server database.
B. Set Login1's MembershipProvider property to MySqlProviderConnection.
C. Add the following code segment to the Web.config file. <connectionStrings> <add
name="MySqlProviderConnection" connectionString="valid connection string"
/></connectionStrings>
D. Add the following code segment to the Web.config file. <appSettings><add
key="MySqlProviderConnection" value="valid connection string" /></appSettings>
E. In the ASP.NET configuration settings within IIS, ensure that Role Management
Enabled is selected.
F. Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the
membership provider for your application.
Somewhere it is written that the two options are
A,D
Somewhere the options are:
B,D
Somewhere there are different options.
Two of my friend sat for the exam and one of them answered A,C
Another answered B,D
Both of them were incorrect.................
Can anybody please tell me which two options are correct with a brief explanation??
There confutions with 3-4 more questions.I will post them in few days.
Thanx in advance .
Hi,
Somebody can speak (tips) about exam 70-431?
Tips?
Amount Questions?
Time ?
Does anyone know of a self test area for the MCDBA exams?
View 1 Replies View RelatedHi All
I am planning to do MCDBA, whether it'd good for DBA's, is't worth of doing or not, Please send me your comments.
Thanks
Regards
Ram
Anyone take (and pass) the MCDBA exams? If so, do you feel the experience
was worth it? I'm most interested in what I can learn. Do you feel that
it's a respected certification (like an MCSE)?
Thanks.
Is MCDBA worth of the time and money one has to put into to acheive it?
I am talking in terms of getting a job.
Do you think after getting MCDBA you have gained sustantial knowledge about the subject?
I havent appeared for any of the MS exams as yet
but would like to start with 70 228 and 70 229.
I like reading BOL, but i guess for certfn exams you have to have a diff approach...
Hello chapies,
Does anyone know where I can download notes for taking the MCDBA exam?
Cheers
Hi everybody;
i'm preparing the MCTS certification for SQL Server 2005. So i need some materials which will be practical for me to get started with the engine and tool.
Thanks
Hi,
Somebody can speak (tips) about exam 70-431?
Tips?
Amount Questions?
Time ?
....
I am aspiring to do the MCTS SQL Server 2005 certification. However, since the SQL Server 2008 is released, I was wonder if doing 2005 is a right choice?. Does anyone you know if when the 2008 certification will likely replace the 2005, is it going to be in this year? or any guidance/information is appreciated.
Thanks
I'll be taking this test and was hoping for some input, please.
1. How long is it ?
2. Anything in particular I should look out for ?
3. Should you only spend a certain amount of time on each question ?
4. Any place I can find any coupons for the heavy $125 fee ?
5. What company did you sign up through ?
6. Any other input, would greatly be appreciated !!
Thank you
Hey guys,
Im wanted to know what was the best training software to pass the mcdba cert or better yet, what is best software for exam 70-228 which is the first exam to take. Classes are just too expensive right now for me=( I am open for suggestions. Thank Guys
I am looking for some good training. I do not do well just reading books on my own. How have you trained for this cert.
I am a developer and would like to start moving in the DB Admin direction a little more. thanks
Hi All,
I'm interested in doing MCTS: SQL Server 2005. Could any one please let me know any link where I can find any study material/practice tests for free for the Exam 70-431.
Your help is greatly appreicated.
Thanks,
DBSTARTER
I am studying for my MCTS sql server 2005 from home
and was just wondering how long it should take me to get through it
throughly. I am going through the Microsoft Implementation and maintainace self kit book.
Many thanks
Rob
i am considering studying for the MCTS in SQL Server 2005 - can anyone offer advice if the Elearning material is useful?
Thanks
Hi,
Does anyone have a copy of the MS SQL2000 Administrator exam...??
Can anybody answer :
Are MCDBA (SQL Server 2000) exams still available today ?
Is it worth going for this exam today, in spite of the fact SQL Server 2005 has been released ?
Hi All,I'm about to begin studying for the MCDBA certification and I'mwondering what books people would recommend?The following gets a good review, so I'm planning on purchasing it:MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000System Administration, 70-228, Second EditionHowever, I'd like to also go through a second book as well, just tomake sure my coverage is as complete as possible, and I'm wondering ifanyone has any suggestions?Many thanks in advance,Murray
View 2 Replies View Related
Hi ,
I have started gathering required materrials for MCTS 70 - 445 Certification Exam.
Up to this period, I have
1.Microsoft SQL Server 2005 Integration Services Step By Step Book
2.Microsoft SQL Server 2005 Analysis Services Step By Step Book
3. Microsoft SQL Server 2005 Reporting Services Step By Step Book
and the main text book for this exam is MCTS 70-445 Implementation and Maintainance sql server 2005 BI
Is there any need for more material for studying MCTS 70-445 exam???
If any,please inform me as early as possible.
I heard SQL Server 2008 has been released in the market..so is there any separate MCTS Exam for this edition also???
With regards,
Maruthi...
Hi Everyone,
I am looking to buy SQL Server for my home computer solely for the purpose of training for Exam 70-431 Microsoft Certified Technology Specialist: SQL Server 2005. My inclination is to buy SQL Server Developer Edition from Amazon.com for $41.99. Is this the best thing for me to do? What is the difference between Developer, Express and Standard in terms of training for the certification exam?
Thanks!
Hi, I am about to take a MCTS 70-431 exam next week.
I tried to find few information regarding this exam, but I cannot find what I need at Microsoft site.
I wonder if anyone has taken this exam or knows about any information about this exam.
My Questions:
Q1: Number of questions on the exam
Q2: Passing Score or percentange or numbers of right questions
Q3: Format of exam:
Definition, concepts, case study, or simulation?
Q4: What if I fail? Retake policy
Do I pay same amount to take it again?
Any information is really helpful and appreciated.
Thank you so much!
Hi All,
I would like take MCTS exam in Business Intelligence(Dataware Housing).For this
I want to know about the MCTS Certification Business Intelligence (SQL Server 2005 ).
Any one can suggest how to prepare for this exam and what is the CODE for this Exam?
And also is SQL Server 2008 has been released or not???
Please respond to this mail and thanks in advance.
Thanks& Regards,
Maruthi
Dear Sir/Madam
I am certified Oracle DBA/Developer/Internet Developer. Now, I am interested in Microsoft Certificated DBA (MCDBA/MCSD).
By the way, I don't want to waste money to purchase the Microsoft exam software (Self Test Software) and training material. So, I want to exchange the MCDBA exam software and training material with you by using Oracle OCP 8i, Developer 2000 Rel 2.0 and MCSE 2000 Self Test Software.
I can use Oracle 8iDBA, Oracle Developer and MCSE 2000 self test software listed below to exchange 70-228,70-229,70-215,70-216,70-175 or other MCDBA 2000 and MCSE 2000 self test software and training materials.
<Oracle 8i DBA>
1Z0-001 Introduction to Oracle: SQL and PL/SQL
1Z0-023 Oracle8i: Architecture and Administration
1Z0-024 Oracle8i: Performance Tuning
1Z0-025 Oracle8i: Backup and Recovery
1Z0-026 Oracle8i: Network Administration
<Oracle Developer>
1Z0-101 Develop PL/SQL Program Units
1Z0-121 Developer/2000: Build Forms I
1Z0-122 Developer/2000: Build Forms II
1Z0-123 Developer/2000: Build Reports
<MCSE 2000>
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-219 Designing a Windows 2000 Directory Services Infrastructure - (Includes 4 Case Studies)
By the way, if you have any one of 70-228,70-229,70-175,70-176,70-100, I can use whole set of Self test software to exchange yours.
Please provide email accounts with at least 5MB space for exchanging Self Test Software.
Thanks and Regards,
Jack
OCP DBA/Developer/Internet Developer
jacklam@tom.com
Hi
I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance.
I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system.
I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.
Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version?
I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer.
According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system
(NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?
Thanks
gifty