Course 2779B: Implementing a Microsoft SQL Server 2005 Database
So a couple of weeks ago now I went on Course 2779B: Implementing a Microsoft Server 2005 Database which was provided by QA-IQ and delivered by Gordon Kneller. I should say before I continue that despite the course numbering, this course logically should be completed after Course 2780B: Maintaining a Microsoft SQL Server 2005 Database! So if you're training manager is booking this course and you have never used SQL Server before, 2780B is the course for you!
Both of the courses are preparation courses for Exam 70-431 which will gain you a Microsoft Certified Technology Specialist (MCTS): SQL Server 2005. You might be thinking “why do any of these courses when SQL Server 2008 has been released”, good question, the answer is that Course 6232: Implementing a Microsoft SQL Server 2008 Database is not yet available.
If you are looking for SQL Server certification, then the 2005, Course 2779B, should be enough training/preparation for you to take Exam 70-433 which will gain you a Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development.
Anyway, less of the blurb… I did this course because I have never had any formal training for SQL Server, I have been using it for the last 4 years and taught it all myself, so really, I needed to fill the gaps in knowledge, I wasn’t expecting too much from the course, but I was pleasantly surprised since it was very good, admittedly it helped having someone who really knew what he was talking about delivering the course.
I think that as a software developer, we generally create our databases fairly quickly with not too much thought, and as long as it works that’s fine, but that’s not really the best way, espeicially if the database is to support a few thousand users and millions of rows of data! So, if you are a software developer, I’d recommend some sort of SQL Server training!
Key modules that helped me on the course are as follows:
- Module 1: Creating Databases and Database Files
- In particular: Creating Filegroups, Schamas and Snapshots
- Module 3: Using XML
- Module 4: Creating and Tuning Indexes
- Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
- Module 9: Implementing Functions
- Module 10: Implementing Managed Code in the Database
- Module 11: Managing Transactions and Locks
- Module 12: Using Service Broker