How to be a database designer.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi guys,

I have 2 years of experience in software developing. Now i want to build my career in database design and database expert.

But frankly speaking i don't know the start point of this, i have the knowledge of sql server 2005's SP, Functions, Database back up and restore, relationship, joins and database diagram, ER diagram etc..but i am average in it not master.

so please can you guide me on how to be a database designer
what are the steps,were i got the study martial, which examination i have to pass out and/or web access url which i can refer for this .

Please help me, because i am stuck right now. i really to be this.

Thanks in advance.

Posted 24-Jun-11 23:42pm

angle57

Add a Solution

2 solutions

Solution 1

You could try the Microsoft certification[^] path for becoming database administrator. They have a program for SQL2005 too and probably 2008 as well. There are plenty of books to be read on the subject. The number of exams and the exam numbers are listed here[^]. The Self-Paced Training Kits[^] for each exam can be found on sites such as Amazon.com.
When you got a number of related certificates you can call yourself a MCDBA, MCTS, MCPD or whatever, depending on what certificates you got.

Of course those certificates are only a formality and they look good on your resume. I think you can be a good database admin without having any certificates whatsoever. But they are a good way to prove yourself and show that you have put time in learning.

Posted 25-Jun-11 0:10am

Sander Rossel

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2011-06-25T04:54:00

Articles
SQLSkills - Immerse yourself in SQL server[^]

Best Practices
SQL Server Best Practices[^]
SQL Server TSQL Coding Conventions, Best Practices, and Programming Guidelines[^]
SQL Server DO's and DONT's[^]

Tools
Freeware: Sql Server Database Design[^]
Freebyte's Guide to...Free Databases[^]

Free attachment

OP wrote:
what are the steps,were i got the study martial, which examination i have to pass out and/or web access url which i can refer for this .

Found some replies regarding this.(After seen these I paused(may be stopped) certifications)
Replies by Christian Graus
I doubt certification means much, especially as there are now websites where you pay, and they take the test in your name... - 2005[^]
Sorry, I think it's a total waste of time... - 2006[^]
This is why Microsoft certification is a waste of time, and meaningless... - 2006[^]
I've totally seen certification centres that will take the test in your name, and guarentee you will pass. How this is of value to anyone, is beyond me. - 2006[^]
Certifications are a joke, they are a waste of time. They prove nothing, apart from a willingness to pay for a test over and over, until you pass it. - 2007[^]
Yes, it's overpriced. Certification is useless, IMO. Certainly any certification that's free, is useless. - 2007[^]
See, this is why I would never bother with MS certifications, or hire anyone who had one, and thought it meant anything. - 2007[^]
See, it's because of people like you that certifications are worthless. Just say I had these answers and sent them to you. Do you think you can go into an interview with that certificate, but have no idea how to pass the test ( i.e. not know how to write web apps with C# ) and get a job ? - 2007[^]
This is why certifications are useless - 2007[^]
I think all exams are a waste of time. If someone wouldn't hire me b/c I don't have one, they have failed my exam. - 2008[^]
I thnk you mean you want to pass one ? That's easy, the web is full of guides. That's why those exams are worthless. - 2008[^]
I got an email once from someone who offered any Microsoft certification. They were a testing centre, so they would sit the exam in your name. - 2008[^]
certification is a joke. I am astounded that anyone still cares, MS must spend a lot on studies and articles like this one. - 2008[^]
Certification is a joke. I would say as much in my interviews. People can buy it without knowing anything. Prove that you know your stuff, that should be all you need to do. - 2009[^]
You really think that an employer won't work out that you have no idea about ASP.NET and just used 'dumps' to cheat on the exams ? This is why exams are useless. - 2009[^]
You know, any company worth working for, knows these things are useless and can quickly tell in interviews between programmers and people who got a certification by reading dumps - 2009[^]
You're not seriously going to do these ? - 2009[^]
MS certifications are easy to buy, that part does not surprise me at all. - 2010[^]

*long exhaling*