Download
microsoft certifications n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Certifications PowerPoint Presentation
Download Presentation
Microsoft Certifications

Microsoft Certifications

124 Vues Download Presentation
Télécharger la présentation

Microsoft Certifications

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft Certifications The hows, whys, whats, wheres, whens etc.

  2. 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

  3. 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

  4. 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

  5. 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%)

  6. 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

  7. 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