1 / 9

Microsoft Certifications

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

kaiyo
Download Presentation

Microsoft Certifications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related