Microsoft SQL Server 2014 And Sharepoint Server 2013 .

Microsoft SQL Server 2014and Sharepoint Server2013 Certifications andTraining

Agenda

Who is Global Knowledge Award winning Strategic GlobalLearning Partner for MS We trained over 50,000 learners in theUK in 2013 Innovative delivery platforms

Learning delivery methodsChoose when and how you want your learning Instructor-led training (ILT) Classic ILT (classroom) V&C Select Class-Connect HD e-Learning and on-demand resources Self-paced training (e-learning)Global Knowledge wins Bespoke e-learning creation2013 Gold Winner – Presentation of the Year2013 Gold Winner – Training – ExternalAudience Presentation Online, CD, e-Books & webinars Blended training Collaborative and social learningWinners Recognized for Outstanding Use ofOnline and Mobile Video Presentations –Improving Sales, Marketing and TrainingCommunications*In conjunction with Plantronics

In any economy, it's vital to make yourself more marketable bydeveloping your skills. At all stages of your career path, you can add realvalue to your professional development with Microsoft SQL ServerTraining and Certifications. Get Certified66% of managers believe that certifications improve the service and supportgiven to IT customers. Get Training75% of managers believe that certifications are important to teamperformance. Stay Current40% of workers report that Microsoft Certifications helped them find a job orled to a promotion.Find IT Jobs: bs.aspx

Why keep skillset current once achieved? So many product improvements means that without training, you will behard pushed to optimise the product you’re working with. Once youknow, business productivity improves which can only be a good thing!Top Technology Skills – Careers of the Future ProgrammerInternet SpecialistSystems AnalystNetwork and Cable EngineerWeb Designer, CopywriterSEO, Web Host ProviderTelecommunication Technicians

Changes to the Certifications and ExamsRelevanceBroader Skill eper Skill Set

MCSA: SQL Server 2014Show that you have aminimum set of skillsto hit the groundrunning.Microsoft Certified Solutions Associate: SQL Server 2014 Exam 70-463: Implementing Data Warehouses with MicrosoftSQL Server 2014 Develop and maintainthe next wave ofmission criticalenvironments andbreakthrough insights.Exam 70-462: Administering a Microsoft SQL Server 2014Database Exam 461: Querying Microsoft SQL Server 2014

MCSE: Business IntelligenceShowcase yourexpert skills atdeveloping anddeploying richbusiness intelligencesolutions.Deliver more datato more peopleacross theorganization.Microsoft Certified Solutions Expert:Business Intelligence Exam 467: Delivering Self Service BI and Big Data Solutionswith SQL Server 2014 Exam 466: Implementing Data Models and Reports with SQLServer 2014 Microsoft Certified Solutions Associate:SQL Server 2014

MCSE: Data PlatformDemonstrate yourexpertise atbuildingenterprise-scaledata solutions.Microsoft Certified Solutions Expert:Data Platform Exam 465: Designing Database Solutions for SQL Server 2014 Extend your skillsbeyond traditionaldatabasecapabilities.Exam 464: Developing SQL Server 2014 Databases Microsoft Certified Solutions Associate: SQL Server 2014

MCSE: Sharepoint Server 2013Demonstrate yourexpertiseMicrosoft Certified Solutions Expert:Sharepoint 2013 Exam 331: Core Solutions of Sharepoint Server 2013 Extend your skillsbeyond traditionaladministrationcapabilities.Exam 332: Advanced Solutions of Sharepoint Server 2013 Microsoft Certified Solutions Associate: Windows Server 2012

MCSD: Sharepoint ApplicationsDemonstrate yourexpertiseMicrosoft Certified Solutions Developer:Sharepoint Applications Exam: 489 Developing Sharepoint Server 2013 AdvancedSolutions Extend your skillsbeyond traditionaldevelopercapabilities.Exam: 488 Developing Sharepoint Server 2013 Core Solutions Exam 480: Programming in HTML5 with Javascript and CSS3ANDExam: 486 Developing ASP.NET 4.5 MVC Web Applications

Database roles convergenceOn which tools aremost DBAs and DBDsproficient?Do DBDs act as DBAs?Which tasks do amajority of both DBAsand DBDs perform? At least 60% of both DBAs and DBDs were at least minimally proficient at SSAS and PowerShell. At least 87% of both DBAs and DBDs were at least minimally proficient at SSIS, SSRS, and T-SQL. 87% of database developers indicated that they had acted as a database administrator at some point in the past. 60% of database developers indicated that they perform database administration tasks as part of their current role,though it is not their primary role. Backup and restore Create tables Installation Performance tuning Ad-hoc queries Integration services (data quality)

Recertification ensures up-to-date skillsProves latestskills in thesolution areaRecertificationProtects yourcert from beingdevaluedReplacesupgrade atexpert levelMCSEs will need In most cases,Transcript willto recertify every requirement will be show upcomingthree yearsone examinactive dateRecertifying alsoearns you the newMCSAExpert-level certnames notversioned

More challenging item typesdemoExtendingMatching itemsCode ReviewCase StudiesChooseAll That ApplyActive ScreenDrag & DropBuild ListsBest Answerexam item type

Instructor-Led Training

Microsoft Official CoursewareQuerying Microsoft SQL Server 2014Course 20461Exam 461Administering Microsoft SQL Server 2014 DatabasesCourse 20462Exam 462Developing Microsoft SQL Server 2014 DatabasesCourse 20464Exam 464Implementing a Data Warehouse withMicrosoft SQL Server 2014Course 20463Exam 463Implementing Data Models and Reportswith Microsoft SQL Server 2014Course 20466Exam 466

Further courses .Designing Database Solutions for MSSQL Server 2014Designing Business Intelligence Solutionswith MS SQL Server 2014MS End to End Business Intelligence BootCamp (SP 2013 & SQL 2012)Updating your Skillset to SQL Server2014Updating your BI / Database Skills to MSSQL Server 2012Course 20465Exam 465Course 20467Exam 467Course 550455 daysintensiveCourse 109775 daysM40009/83 days each

Microsoft Official CoursewareCore Solutions of Sharepoint Server 2013Course 20331Exam 331Advanced Solutions of Sharepoint Server2013Course 20332Exam 332Developing Core Solutions forSharepoint Server 2013Course 20488Exam 488Developing Advanced Solutions forSharepoint Server 2013Course 20489Exam 489

Additional resourcesSelf Paced with a differencefrom GK MS Official ManualMS Online LabsMS Practise ExamPrometric Exam voucherMicrosoft.com/learning SQL Server forumsSharepoint Server 2013MCT SQL Server wikiBorn to LearnLearning snacksMicrosoftvirtualacademy.comTechNet.com Jump Starts for Developing Sharepoint Core and Advanced Tuning SQL Server 2012 for Sharepoint 2013 Faster Insights to Data with Power BI Jumpstart Download trial versionVirtual labsTutorialsDemos

Current PromotionsIt’s back! Second shot is now available for MCP or MTA exams takenbefore the end of May 2014.AND .Heard about the 180 day Certification /p/certchallenge.aspxBetween February and July of 2014, we’re providingaccess to all the tools you need to quickly ramp upearn your Microsoft Certification. That includes examprep videos, study guides, expert guidance, and even . a checklist to help you stay on track!

Reinvented for the CloudMicrosoft has reinvented its certifications by building cloud related skills validation into the industry’s most recognized and respectedcertification program. Microsoft Certifications remains the method by which IT Pros and Developers stand out from their peers and foremployers to recognize candidates/employees who have the skills required to be productive. To ensure Microsoft Certifications remainrelevant, they now validate a broader and deeper set of cloud skills and experience across a technology solution.IT Pro & Developer benefitsGet RecognizedGet hiredGet recognized by peers andhiring managers. MicrosoftCertification distinguishes theability of professionals todeploy, design, optimize andoperate technologies for criticalIT roles.Get a job building the future.Microsoft ensures itscertifications are on the cuttingedge of technology and arevalued by businesses, helpingprofessionals get hired in today’shighly competitive market.A 2011 study showed 86% ofhiring managers indicate ITcertifications are a high ormedium priority during thecandidate evaluation process– CompTIA Feb, 2011 PressReleaseIn a survey of 700 IT professionals,60% said certification led to a newjob– Network World, 11/14/2011Hiring Manager benefitsGet qualified candidatesGet verification employeeknowledge is current.A certification research report, 64 % ofIT hiring managers rate certificationsas having extremely high or high valuein validating the skills and expertise ofjob candidates– Channelinsider.com,2011-10-19A certification research report, 89%of IT hiring managers say that ITcertifications help confirm subjectmatter knowledge and expertise–Channelinsider.com, 2011-10-19

Linda.smith@globalknowledge.co.uk

MICROSOFT APPRENTICESHIPS6th March 2014

Tom Davis

What is your role?I currently manage all internal IT systems and requirements whilstworking on Client Projects as a Business Intelligence Consultant withAdatis. I also get to go out to schools and events to raise awarenessof the Microsoft Apprenticeship Scheme.What’s your background?I’ve always loved IT and business so started my own YoungEnterprise firm at 14 which I ran for a number of years whilst atSchool. After achieving 10 GCSE’s at Collingwood College I spent ayear at Farnborough 6th Form College whilst managing an O2 store inmy local town, I then found out about the Apprenticeship Schemeand haven’t looked back since!

Based in Farnham,Surrey.Privately OwnedBusiness IntelligenceFirm.Specialising in DataWarehousing, SelfService BI, Reportingand Visualisation,Master DataManagementHiring across alllevels fromApprentices toPrincipal Consultants,Get in Touch to findout more!

Apprenticeship OverviewWhat is an Apprenticeship?Microsoft’s commitment to increase UK ICT Skills12 Months based at a Microsoft Partner whilstreceiving Qualifications and Training from a learningproviderProvide alternative pathway into the industry insteadof the University RouteDesigned tofast trackapprenticeproductivityLevel 3AdvancedApprenticeshipNew era.New skills.Training providers chosenprovide national scale andqualityEarn while you learn!MarshalPartnerNetwork asemployersConsult withPartners toensurecontinuedrelevanceNew workforce.

What's on esNew era.New skills.JobFunctionSampleRoleTroubleshooting& supportingapplicationsHelpdesk;Desktop SupportEngineerDatabase,Dynamics, indows Serverand NetworkAdministrationHelpdesk;Server SupportEngineerDevelopingWindows, Web,or MobileApplicationsSelling Microsoftand Partnerproducts,solutions ment;LicensingSpecialist; PresalesNew workforce.

What do the Apprentices get at the end?New era.MCP Status as wellas a number ofLevel 3Qualifications.12 MonthsExperience at an ITcompany with a 3year head start onGraduates.An Average Salaryof 20,000 and 0University Debt.A 90% chance ofcontinued FullEmployment withyour ApprenticeEmployer.New skills.New workforce.

The Apprentices’ view ‘This opportunity has provided me with a fantastic stepping stoneinto a career that I now love’‘I study for my accreditations but also obtain on the job trainingfrom the company and learn directly from them’‘I always knew I wanted to work in IT, but didn’t know how to doit that’s when I applied for an apprenticeship’

What has it meant for me personally?

Questions

CONTACT DETAILS For more information about the programme, please go to: get-a-job.aspx To find out more information about each course or to apply, please go to: QA - http://apprenticeships.qa.com/ Firebrand - /programmesFor more information regarding Adatis and our available positions please visit:http://www.Adatis.co.ukemail us at enquiries@Adatis.co.ukTwitter @AdatisBI

My JourneyBE INSPIREDSTEVE SMITH