90 likes | 226 Views
Microsoft Certifications. The hows , whys , whats , wheres , whens etc. Titles. MCP – Microsoft Certified Professional One exam , doesn’t matter which MCTS – Microsoft Certified Technology Specialist 70-433 – TS: SQL Server 2008, Database Development
E N D
Microsoft Certifications The hows, whys, whats, wheres, whens etc.
Titles • MCP – Microsoft Certified Professional • One exam, doesn’t matter which • MCTS – Microsoft Certified Technology Specialist • 70-433 – TS: SQL Server 2008, Database Development • 70-432 – TS: SQL Server 2008, Implementation and Maintenance • MCITP – Microsoft Certified IT Professional • Database Developer – 70-451 – PRO: Designing Database Solutions and Data Access Using SQL Server 2008 • Prerequisites MCTS – 70-433 • Database Administrator – 70-450 – PRO: Designing, Optimizing and Maintaining a Database Server Infrastructureusing SQL Server 2008 • Prerequisites MCTS – 70-432
Titles • MCPD – Microsoft Certified Professional Developer • MCA – Microsoft Certified Architect • MCITP SQL – Administrator, Developer and BI • MCPD – Windows, Web, Enterprise Apps • MCM – Microsoft Certified Master
Microsoft CertifiedTrainer • Hold official Microsoft Courses • 999 Partner Training Course • 2778 Writing Queries Using Microsoft® SQL Server™ 2008 Transact-SQL • 6156 What's New in SQL Server 2008 • 6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008 • 6231 Maintaining a Microsoft® SQL Server® 2008 Database • 6232 Implementing a Microsoft® SQL Server® 2008 Database • 10262 Developing Windows® Applications with Microsoft® Visual Studio® 2010 • 10266 Programming in C# with Microsoft® Visual Studio® 2010 • 10267 Introduction to Web Development with Microsoft® Visual Studio® 2010 • 10325 Automating Administration with Windows PowerShell® 2.0
Benefits • MCP • The titlesare nice on your CV • MCPeStore • MCPMag • Procentage on TechEd • MCT • TechNet Pro Subscription • Access to Microsoft LearninigCourseWare Library • MCT Flash • Invitations to MCP beta exams • Discount on books (up to 60%) and exams (up to 65%)
Omega Benefits • Per passedexam • 10.000,- (beforetaxes) • Examfee is returned • Hours on theexaminationday and travel expencesarecovered by Omega • After passing 3 exams (70-451,70-526,70-528) • One yearextraseniority on salary ladder • AppFrame Certified Developer
ExampleQuestion Youwork in an International companynamed TAKEEN. And you’re in charge ofthe database of your company. Youintend to use SQL Server 2008 to create a database. A database includes a tablenamedSelling. Client order summaryinformation is contained in theSellingtable. A storedprocedure is created and it uses a SELECT statement and it must return a precisesummationofthe total sales for thecurrentdaywhenexecuting. Whenthestoredprocedure is being executed, you have to preventany data modification in theSellingtable by using a query hint. Whichquery hint shouldyouuse? • TABLOCKX • READPAST • HOLDLOCK • READCOMMITTED