Certification: Looking For Advise
Oct 1, 2004
Hi All
I have been working with Ms access Database the last four years and have gained a lot of experience which help me to have extensive knowledge of Jet, Dao and Ado. Since The Begining of this year i hv been migrating to SQL server server and for that i bought two books :Programming Access project file with Microsoft Sql server and Access Developers Guide to Ms sql server : Chipman & Baron ( this oner is simply a great achievement ). They help me out in the very near past to complety migrate a two database approch Jet Application to a reliable (Adp/ SQL Server client server ) where major parts of the code business logic has been transfered to run on the server as stored procedures and all forms re-built as unbound. these merely leads to a great enhancement of the applications.
My goal now is register to MCDBA and get the certification. I am not interested by classroom training from Microsoft Parterns or online training. I am looking for books that can help to get well prepared for the exams.
Have found this two books in Amazon:
1 - MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
2- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition
However their rating didn't encourage me to place directly my orders.
Does someone have any experience with them ?
Do you think they will considerably help me to add value to my knowledge of SQL Server and get ready for the exam ?
Do you know some others books you woul rather encourage me to buy ?
Any advice in this regards really appreciated.
View 2 Replies
ADVERTISEMENT
May 14, 1999
Does anyone know where to get practice tests for the new SQL 7.0 Admin exam?
TIA
View 1 Replies
View Related
Jan 12, 1999
Where can I find information on the MCSDBA certification, when the exam is coming
out, is it for SQL 7.0, etc.
View 1 Replies
View Related
Feb 11, 2008
Hi Experts,
I have a question in one of the interviews relates to MS Certification.
Is it require to have the MCDBA in SQL Server 2000 certification or required 2005 version certification?
If so, What is the main difference in having that over 2000 version.
Then it went like What the difference it makes having certification and what are the general comments about it.
I know 2005 definetely have the edge over the 2000 certification but I didnt understand what the major advantage in having and have not such certification.
Thanks in advance.
View 14 Replies
View Related
Jun 26, 2007
hi.
iam learing Ms server 2005 i want is there any MicrosoftSoft certification for Microsoft Sql server 2005 alone
View 2 Replies
View Related
Jun 19, 2002
I was thinking of doing certification from Microsoft. I was first intending to write exam 70-229 which is :
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
The Microsoft site http://www.microsoft.com/traincert/exams/70-229.asp#TOOLS has a list of topics that I need to be familiar with in order to pass the exam, but it does not have the detailed information.
Can someone guide me to a place where I can go to get the detailed information about these topics so that I can prepare better for the certification exam?
thanks
Aslam
View 1 Replies
View Related
Feb 17, 2006
Hi,
I am interested in doing SQL server certification.
I don't know any information abt this.
It would be gr8 if u ppl could give some details as to
how many levels of certification are there,
how much is the cost of certification,
is there any pre-requiste for the same and so on...
Thanks,
Vatsan
View 2 Replies
View Related
Apr 23, 2007
Anyone know of a site or company that provide good pre-tests for certification?
I don't mind paying for downloadable test either.
Peter Larsson
Helsingborg, Sweden
View 5 Replies
View Related
Nov 9, 2007
Hello everyone. This is my first post on this board. I've been working for an investment bank in London (via an IT services company) as a DBA for a year now. It's pretty much my first real job since graduating from university. I did a bit of SAP before this job but it didn't really work out.
The work has been almost entirely on SQL Server 2000. I've done a bit of 2005 such as installs, backing up/restoring databases, setting up security.
I was thinking of doing an MCITP course in SQL 2005 in India early next year (my company will not pay for training - cheapos). The bank has recently been taken over by another bank and I don't know what the future holds beyond February, it's probably likely that the DBA's from the other bank will take over.
Do you think certification is needed? Would it be hard for me to get another job with the experience I currently have?
I find it difficult to study at home and the idea of going to India and getting the certification in 2 weeks appeals to me. Has anyone else ever been to a boot camp in India or elsewhere? Just how important is certification?
If you could provide me with some advice I would be most grateful.
View 5 Replies
View Related
Aug 23, 2005
I am reading Administering SQL Server, a study guide for 70-228on page 27, it says:"INSTEAD OF triggers are useful when a DML operation is unsuccessful."I think this is nonsense. Any comments?
View 5 Replies
View Related
Dec 5, 2006
Is there a mcp certification exam for SSIS? I have been using google to find information about SSIS exam but with out success.
Please help.
View 4 Replies
View Related
Jan 17, 2007
Hi all,
I am new to Sql Server 2005
I planning to take exam MCTP exam 70-445
is the cert 70-431 a pre-requisite for certs 70-445 and 70-446?
Thanks and regards
View 1 Replies
View Related
Mar 18, 2008
Hi All,
I have planned to take up the exam 70-229 "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition" as a select exam for MCAD".
Any links to sure shot Dumps avialable for the above exams OR any good E books.
Please Help....
Thanks
View 1 Replies
View Related
Feb 13, 2008
Hi There
I know this is not the forum for this question however i dont know where else to post it.
I am about to write my MCITP DBA Admin for Sql server 2005, however now that 2008 is being released this year i was thinking about maybe waiting and just writing 2008.
But i have had little luck finding out how the certifications will work.
Does anyone know if it will still be MCITP DBA Admin and Dev certifications but for 2008. Or will it be a whole new kind of certification path ?
Bottom Line is it worth while to do 2005 MCITP right now ? Perhaps 2008 certifications will only be available in 2009 ?
If anyone has info onthis please let me know.
Appreciated, Thanx
View 6 Replies
View Related
Aug 3, 2004
Hello,
My employer has recently offered to pay for my certification exam (70-229) so I am about to start preparing/revising. Having visited numerous sites to get an idea of what is needed, I am now overwhelmed with info.
Has anyone out there successfully completed the exam and if so can you recommend any sites/resources that you found useful (or any to avoid).
Regards
Simon
View 1 Replies
View Related
Nov 1, 2004
Hello,
I am about to start revising for exam 70-229 as part of my MS certification and was wondering if anyone has any advice/tips etc on revision material.
Having visited a number of sites I am now overwhelmed with the amount of study material. There are hundreds of sites offering exam training, others offering braindumps and others selling practice tests.
Does anyone know the best place to start and what material will get me up to speed the quickest. (Time is of the essence and I cannot afford to pay for training)
Any advice would be appreciated.
Simon
View 1 Replies
View Related
Feb 6, 2004
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
View 2 Replies
View Related
May 14, 2007
Hi has anyone taken the SQL Server 2005 Certification test yet???
View 5 Replies
View Related
Jul 20, 2005
Pls Help if somebody has taken this test...70-229(MS SQL Server 2000)I want to pass this desperately.Pls suggest some good question banks.
View 1 Replies
View Related
Dec 18, 2006
I see that part of SP2 is the new CC certification -- can anyone give me some more details. What level is it at? EAL4? I can't seem to find the certificate on the CC Web site but it could be because it's not SP2 yet.
View 3 Replies
View Related
Jul 2, 2007
Hi all,
Is it any Microsoft certification is there for Sql Reporting service ,If is there means please send me the related link to me!!!
Regards,
P.Veera Vinod.
View 2 Replies
View Related
Oct 6, 2007
I am new to SQL Server 2005. What is the best certification to start with? What training resources should I use?
View 3 Replies
View Related
Jun 24, 2006
Hi all,
Is there any On-line Resource available to prepare for Microsoft SQL server Certification Exam . Or from which site i can get the Dump?
Regards
Magesh
View 1 Replies
View Related
Mar 20, 2007
I have successfully finish Oracle OCA Exam. Currently I am Microsoft Certified Database administrator(MCDBA) I would like to know there is any way I could use OCA Credit to any Microsoft Exam. If any advice will be helpful.
Thanks
Faiz Farazi
www.databasetimes.net
Best learning center for Microsoft
http://www.lascomp.com
View 3 Replies
View Related
Mar 21, 2008
hi guys,
I am joining IT industry in august,my main intrest is in database(readed some stuff of warehousing oracle 9i and sql).
However to move my career in that direction i need certification.
So here is the point,should i get MCTS(in sql server 2005) or OCP(oracle associate 10g).
My main goal is to become DBA. which of the above is more benificial.
I mean more oppurtunites.
please reply.
View 4 Replies
View Related
Aug 9, 2007
helloI have two related tabletable1cIdcDesctable2IdNamephonecIdThese two tables are relatedwhere cId in table 1 is primary key and cId in table2 is foreign keyIf I want to delete a record in table 1 which is related to table 2Which is faster and more accurateshould I write my stored procedure like thisif exists(select * from table2 where cID = @CID)delete from table1 where cID = @CIDelsereturn 0------------------------------------------or------------------------------------------delete from table1 where cID = @CIDif @@error<>0return 0
View 14 Replies
View Related
Feb 7, 2005
Hi there!!
I just want to ask one question and i am looking for advice or recommendation.
I want to make an application using windows application in .NET. this application is only to have one or two users to enter details of clients on the database using the application and it will be a search for client name or number and other search methods which is similar.
My question now, what database shall i use for this kind of application SQL server or MS Access. i am looking for a new product to use as the cleint can not afford expensive software. Please advise!! thanks!!
View 3 Replies
View Related
Jul 20, 2005
Version: SQL Server 7.0App: MS Access 2000I created DTS to move records from MySQL to SQL Server (approx over 500,000+per months dataset) for purpose of canned and adhoc reporting. The apphave a simple interface using MS Access where user will input the timeframeof the dataset they will process.Both servers are physically located in the same bldg from another state.Previous to MySQL, they send us cd in text format and my app runs the DTSusing a BAT file containing the DTSRUN command. But I would like stay awayfrom the DTSRUN since they take awhile to load to the server, plus it runson background on client pc. I wanted a functionality where it will run onthe server without user supervision, and they can go about their businessand do something else. In other words, let the server do majority of thework.Now that MySQL came into the picture, the Network Support created a filedsnwhere sqlserver sits and I use that as a reference on my DTS (using UNC,\myserverfile$sample.dsn)The problem:1) I work from home and when creating and running this DTS's, it takes awhile to process;2) When specifying the UNC path on DTS and saved, for some reason itswitches to the User/System DSN section;3) I also tested from office with the same result (i connect using cablemodem)Now the only way I can think of to solve this problem:a) save the DTS as a file and send it over to Network Support and have themload it up and manually change the source location OR have them modify theDTS and change the source locationb) then create a DTS jobThe person who will be running this DTS might be running it from home oroffice. Also, is there a way to automate the DTS job using an SP? I wantedto make it as easier as possible for the end user, where all they have to dois enable the job and run only for this time and for this package.TIA!Bob
View 1 Replies
View Related
May 20, 2006
on the 1st opening of my web page it uses the membership control of asp.net
for logging on. sometimes it takes time to logon and worse is, it will
encounter sql server error. that can be resolved by just restarting that
specific page and it will be alright, it will logon normally. this only issue happens only on the first opening of the logon page.
i have read a certain article and it says there that on the first time
you access the sql server, sometimes the sql server needs a little more
time communicating back and forth.
how can i make my log-on page wait a little longer till it communicates
or finishes communicating to the sql server?
im afraid that this may happen once i deploy my web project. i am
expecting over 100 users and they might save to the database all
together. will i encounter problem on this particular?
i am using ASP.NET 2.0 and SQLExpress for this project. pls advise me.
BIG THANKS.
View 11 Replies
View Related
Feb 14, 2007
I have been given a DB that currently stores Organizations. I need to add the ability to track multiple contacts for the Organizations. The DB has several one-to-many relationships on the Organizations table, such as Documents and Notes. I would like to track these by contact as well as the organization.
Is it possible to add a tblcontact and a one-to-many relationships to the Organizations table as well as to the tblDocuments and tblNotes?
I appreciate any suggestions.
tblOrg (OrgID)
tblDocuments (DocID, OrgID)
tblNotes (NoteID, OrgID)
tblContact ???
View 3 Replies
View Related
Dec 16, 1999
Hi there,
I would be appreciate to hear some advice regarding my mission to upgrade from SQL Server 6.5 to 7.0. The database would still be located in the same server. Do I have to do checking on the datatypes? - many thanks-
View 4 Replies
View Related
Dec 31, 2007
HiWe usae Sql2000.I'm setting up backups jobs and need advise.When I run a backup of a database, does it automatically clean out thetransaction log ? For a complete backup ? for a differential backup ?When would it be best to run a shrinkdatabase command ? Why would I wantto run the shrinkdatabase ?ThnaksDavid Greenberg
View 3 Replies
View Related
Jan 4, 2007
I am very new in SSIS. I have the Report Server set up with two dozen of the OLAP reports in it. The reports are connected to the OLAP database on a seperate computer running on Sql 2005 server and the data source for the OLAP DB is pointed to the warehouse database on another computer running on Sql 2000 server. The warehouse server updates daily from a number of "Production" Sql servers running on Sql 6.5 and Sql 7.0 with the legacy front-end data entry application. I know the update from the "Production" Sql 6.5/7.0 servers to the warehouse server complete around 9am in the morning everyday. How do I set up a package in SSIS to schedule the update of the OLAP database say 9:30am so that end-user can have the latest data to their report. The OLAP database has one fact table, half a dozen of cubes and ten dimensions. I know it is not an easy task to set up the package in SSIS. Please provide sample and step on how to do this. Thanks. One last question how to prevent/warn users from opening the report when SSIS updating the OLAP database?
View 1 Replies
View Related
