This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cert to show knowledge of SQL?

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I am basically wondering if there are any certs which will show a basic knowledge of SQL, as in, enough to get by or principles etc.

We currently use SQL Server 2000 at work to carry out a number of duties as part of the change management process, i.e. Stored Procedures, updating db jobs and then the usual monitoring of things like database replication and adhoc db quries using Query Analyser etc.

I want some way of "cementing" some basic knowledge, rather then fumbling blindy doing these things when people ask - and to also show a future employer that although I may not be a specialist in SQL Server, I have the aptitude to take it on, and some form of understanding of the workings, albeit at a basic level etc. Also, doesnt hurt to add an extra bow to the CV....

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

thanks for the reply. I have indeed seen the above exams on Microsofts website, but was unsure as to which one would be best suited to my needs as outlined in my initial post. Its a hard one for me to call - I use SQL Server maybe 7 or 8 times a week for a manner of things (as above) so just really want to get a cert and knowledge which will help with those tasks.

I am a System Admin really for the most part of my job, I would just like to have a bit of a base I could potentially build on in SQL Server, and possibly bring something more to the team if and when needed.

thanks for the reply. I have indeed seen the above exams on Microsofts website, but was unsure as to which one would be best suited to my needs as outlined in my initial post. Its a hard one for me to call - I use SQL Server maybe 7 or 8 times a week for a manner of things (as above) so just really want to get a cert and knowledge which will help with those tasks.

I am a System Admin really for the most part of my job, I would just like to have a bit of a base I could potentially build on in SQL Server, and possibly bring something more to the team if and when needed.

Click to expand...

Since you're familiar with SQL 2000, I'd probably suggest getting the MCDBA, then upgrading to the SQL 2003 stuff if you want it.

Thanks for all the info guys. I would guess then its 228 that I look into then.

Do you think it will be pointless doing a 2000 cert now when there is 2005 being used in a lot of places? I know its relevant to my current role, but part of the reason I want to get the cert to begin with is to be more appealing to another prospective employer.

A lot of new VS 2005 development going on with SQL Server 2005. But because of radical changes to the database engine many shops aren't upgrading this time around. Looks like most will be sticking with 2000 until the end of their existing application's lifecycle. Then the non-MS developers (Cold Fusion/Java shops in particular) will probably just move to Sybase or Oracle instead.

So to answer your question: SQL Server 2000 will still be in use (in production) for many years to come. If you're a dot-net developer (or asipre to be one) however, definitely go with SQL Server 2005.

CertForums.com is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA™, CCDP™, CCNP™, CCIE™, CCSI™; the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc. All other trademarks, including those of Microsoft, CompTIA, VMware, Juniper ISC(2), and CWNP are trademarks of their respective owners.