There are 3 MCTS Certifications Categories for SQL Server, MCTS: SQL Server 2008 (Admin Track), Implementation and Maintenance - Exam 70-432 MCTS: SQL Server 2008 (Developer Track), Database DevelopmentDeveloper track - Exam 70-433 MCTS: SQL Server 2008 (BI Track) , Business Intelligence Development and Maintenance - Exam 70-448 [Ref] Selecting the exam really depends on your area of interest and before giving exam you should feel how the real world of SQL Server looks. So a good start is to learning T-SQL, Once you are done with it, find a SQL Developer job get some real world experience mean while you can prepare for your exam by reading the Microsoft Press release books, blogs, Forms and Community. In market there are so many dumps available for the exam, don't go for any of these, that is unethical and will really make u DUMP! :
I myself am a relative newbie in the 'business' but let me tell you how I went about the certifications and learning SQL Server in general. As Cyborg stated, most important is your angle towards SQL Server. Are you a developer or did your company just assign to you the 'honour' of managing their SQL Servers? I started using SQL Server from a reporting perspective, writing queries to satisfy diverse operational and management questions. I had a broad view of SQL from university so querying was no problem, but I liked to get a better view as to how SQL Server worked so I got my 70-432, first. This exam, to me, was the easiest of the 3 exams listed above. When you're a (dotNet, or anything) developer expanding your working knowledge to SQL Server, go for exam 70-433. This will teach you a lot about SQL Server development though you might abstain from using specific exam topics in your real life situation such as using SQL Server for shredding XML documents (hey, it's a relational database and should be regarded as such). XML is always handled better by applications servers as they are much more scalable on that topic. Back to SQL Server: The 70-448 (BI) certification exam was the most challenging exam I took, and I frowned upon a lot of the questions, I just couldn't believe the questions they asked were real as they were all too far off the real life experience, to put it mildly. I work with SSIS and SSRS on a day to day basis, to put things into perspective, and have extensive knowledge about working with SSAS as well. In short, when you 'just don't know', go with 70-432 (Database Administration) as it provides you with a broad knowledge of SQL Server. If you're a developer, go with 70-433 (Database Development). I would not advise anyone to go with 70-448 if this is your first MCTS, unless you already have extensive experience using all of SSIS, SSRS and SSAS. BTW, I don't know if it's allowed to plug anyone's books on this forum, but I really recommend anyone to read Itzik Ben-Gan's book on [T-SQL Fundamentals]. This book is great in making difficult concepts seem easy. (In my experience, any book with Itzik's name on it can be bought without hesitation.) :
Your last comment was you are leaning towards development. I would start by purchasing a few development books. Probably by Louis Davidson to start with. As for dumps, you won't find anyone here to recommend ANY dumps. They are a form of cheating in many peoples eyes. They degrade the meaning of certifications as you state you have no real world experience but yet you want the certification. How can you expect a company to give any weight to the fact you studied and passed a test but yet haven't done any relevant work. If you read the necessary books and gain the knowledge to pass the test kudo's to you, but seriously do yourself a favor and put in the time and study time to get the cert on your own merit.
Personally, I got my first certification because I was transitioning from the military to a civilian job and needed a way to help get interviews. More than one of the several companies I did interview with said they weighed the certification at least in deciding who to interview, one of them even told me it was a direct factor in how much of a starting salary they could offer me. The pragmatic value of certifications for some people is to help them get interviews when they are just entering the job market or moving from one field to another. For that reason, I must respectfully disagree with Cyborg's advice to get the job first and then the certification (though I agree with everything else he said). If you already have the job and are gaining experience, the certification is a lot less important. Beyond that, as Cyborg said, the first step is which track you want to start down first. It may well be worth getting all 3 of the options, but you need to focus on one to start with. I got my certification through a combination of book study, self practice on the Express edition (it is free, the developer edition is also quite affordable at roughly $50), and some guidance from a friend already in the industry. I cannot overstate the importance getting some practice, even if it is just practicing by yourself ont he express edition like I did. It will really help you understand what you are learning.
I'm not going to rehash what everyone else has already said on the certifications and all... With doing development work (which I do not do) you have the opportunity of gaining experience through volunteer work. Call or look around your area for companies that may need a small database built to hold data for their branch offices or something. Even if you just have SQL Express in the backend and use MS Access for the form access, it still gaining that experience with databases. If they like what you gave them ask them for a reference letter or something to verify that you did the work.