SQL Blog of Zach Stagers

www.scratchbox.co.uk

MCITP: Database Developer 2008

1 Comment »

Following on from my previous post, I took the next exam (70-451) in the Database Development 2008 MCITP series on the 2nd of August and passed with 93.5%!

 

Zach Stagers - MCITP Database Development 2008

 

This means that I am now a “Technology Specialist in SQL Server Developement (2008)” and a “Microsoft Certified IT Professional in Database Development (2008)”.

The 70-451 exam was pretty different to the 70-433. The questions were more focused on database design and data access, rather than remembering syntax.

The exam is also a little trickier to study for, as there aren’t any Microsoft Publications based around it. I would recommend getting hold of some practice test (I used Transcenders), studying them hard, and googling any terms you haven’t come across before or don’t feel you know well enough.

Next I plan on taking a break from certifications, and broadening my horizons by learning some C#! Wish me luck…

TS: Microsoft SQL Server 2008, Database Development (70-433)

4 Comments »

Yesterday, I took the 70-433 Microsoft exam, and I’m pleased to announce that I passed with 92% on my first attempt! This gives me the certification of Microsoft Certified Technology Specialist in SQL Server 2008 Database Development.

MCTS - Database Developer 2008

I’ve been meaning to take one of these exams for a long time now, and I’ve finally managed to do it. I spent a lot of time reading and practicing, and I’m glad that it’s all payed off!

A big thank you to a man named Niall Merrigan, as achieving this without his blog and 70-433 study guide would have been a lot more difficult! I recomend you check his site out if you’re going to take this exam.

Another resources I used was the MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 – Database Development Book/DVD Package:

The informartion in this book was good, and gave a very good understanding of most things covered in the exam. I found the practice tests to be fairly similar to the real deal, and gave decent examples and links to other resources (such as MSDN and Microsoft TechNet) when reviewing the answers. Overall – I would recommend using this book whilst studying for your 70-433 exam, but you will need to top your knowledge up with the links given in the answer reviews – and maybe a few visits to Niall’s blog mentioned above.

Many of my own blog posts are also focused on the topics covered in this exam, so be sure to check back here if you need a little help.

The next exam I’ll be tackling is the 70-451, this is the next exam in the series to achieve the certification of MCITP: Database Developer 2008. I’m sure that this will require much more reading. I’ll be sure to post back with more tips once I’ve finished this one too!

Learning SQL

2 Comments »

Inspired by Chris Sparshott’s post on Learning CSS, I decided to write about how I first got involved with SQL, how I learned, and how I continue to learn about its features.

First, a bit about the language. SQL stands for Structured Query Language, and it’s used to query databases to get the information you want and need from them.

Microsoft SQL, also known as “Sequel”, is my langauge of choice, and will be the main feature of my blog. There are several other database technologies which I may also touch on from time to time, they are Oracle, MySQL, Sysbase, and DB2 to name a few.

I first started to learn the language and syntax when I joined One2Create in November 2008. Previous to this I had very little experience in any development languages. I had learned bits and pieces of HTML, CSS and C#, but had never before used SQL.

The first thing I did was buy a book, this one in fact: Sams Teach Yourself SQL in 10 Minutes

I read through this book, and completed the examples as I went. It’s a complete novice’s book, and the author (Ben Forta) has done a very good job intoducing the language. It gives you more than enough to get an understanding in the basic syntax, features, and uses.

After about a year and a half of using Ben’s book as a reference, and gaining experiance in the industry, I decided I wanted to study for the Microsoft 70-433 SQL Developer 2008 exam.

My work purchased the 70-433 Self-Paced Training Kit Book to allow me to study the more advanced features of SQL in the hope that I could pass the exam. I’ve yet to attempt the test, but hope to in the near future.

Development languages, including SQL, are ever growing. There will always be more to learn, new features introduced with new versions, as well as keeping up with all of the old stuff! And this is why I love what I do!