1 / 38

70-461 Real Questions

Pass4sure provides best and outstanding preparation material for you through which you will surely pass your IT exam attain with outstanding marks!http://www.pass4sureexam.co/70-461.html

pass4sureexams
Download Presentation

70-461 Real Questions

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 SQL Server 2012 Certifications and Training Microsoft Learning

  2. Agenda MCSE: Data Platform MCSE: Business Intelligence MCSA: SQL Server 2012 Training http://www.pass4sureexam.co/70-461.html

  3. Certifications

  4. Value of Certification Recognition Differentiation Employability http://www.pass4sureexam.co/70-461.html

  5. Changes to the Certifications and Exams Broader Skill Set Certification Requirements Relevance Rigor Recertification Deeper Skill Set http://www.pass4sureexam.co/70-461.html

  6. SQL Server 2012 Certification paths MCA: SQL Server MCSM: SQL Server MCSM: Business Intelligence Master MCSE: Data Platform MCSE: Business Intelligence Recertification Recertification Destination Developing Databases (Exam 464) Designing Business Intelligence Solutions (Exam 467) Implementing Data Models and Reports (Exam 466) Designing Database Solutions (Exam 465) Expert MCSA: SQL Server 2012 Querying (Exam 461) Administering Databases (Exam 462) Implementing a Data Warehouse (Exam 463) Associate

  7. MCSA: SQL Server 2012 Microsoft Certified Solutions Associate: SQL Server 2012 Show that you have a minimum set of skills to hit the ground running. = • Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012 + Develop and maintain the next wave of mission critical environments and breakthrough insights. • Exam 70-462: Administering a Microsoft SQL Server 2012 Database + Exam 461: Querying Microsoft SQL Server 2012

  8. MCSE: Business Intelligence Microsoft Certified Solutions Expert: Business Intelligence Showcase your expert skills at developing and deploying rich business intelligence solutions. = Exam 467: Designing Business Intelligence Solutions with SQL Server 2012 + Deliver more data to more people across the organization. Exam 466: Implementing Data Models and Reports with SQL Server 2012 + Microsoft Certified Solutions Associate: SQL Server 2012

  9. MCSE: Data Platform Microsoft Certified Solutions Expert: Data Platform Demonstrate your expertise at building enterprise-scale data solutions. = Exam 465: Designing Database Solutions for SQL Server 2012 + Extend your skills beyond traditional database capabilities. Exam 464: Developing SQL Server 2012 Databases + Microsoft Certified Solutions Associate: SQL Server 2012

  10. Database roles convergence • Performance tuning • Ad-hoc queries • Integration services (data quality) http://www.pass4sureexam.co/70-461.html

  11. Recertification ensures up-to-date skills Recertification Proves latest skills in the solution area Protects your cert from being devalued Replaces upgrade at expert level Recertifying also earns you the new MCSA Expert-level cert names not versioned MCSEs will need to recertify every three years In most cases, requirement will be one exam Transcript will show upcoming inactive date http://www.pass4sureexam.co/70-461.html

  12. More challenging item types Extending Matching items Code Review Case Studies Choose All That Apply Best Answer Active Screen Drag & Drop Build Lists !Be sure to view the exam item type demo to see these item types!

  13. Upgrade paths

  14. Upgrade to MCSE: Data Platform MCITP: Database Developer 2008 or MCITP: Database Administrator 2008 MCSE: Data Platform* + + = Exam – Transition to SQL Server 2012 Part 1 Exam – Transition to SQL Server 2012 Part 2 Exam- Transition your MCITP to MCSE: Data Platform 457 458 458 + 459 NOTE: All Upgrade paths are subject to change until final release. * Requires recertification http://www.pass4sureexam.co/70-461.html

  15. Upgrade to MCSE: Business Intelligence MCSE: Business Intelligence* MCITP: Business Intelligence Developer 2008 = + Exam- Transition your MCITP to MCSE: BI Exam – Transition to SQL Server 2012 Part 1 Exam – Transition to SQL Server 2012 Part 2 457 458 + 460 NOTE: All Upgrade paths are subject to change until final release. * Requires recertification http://www.pass4sureexam.co/70-461.html

  16. Upgrade to MCSA: SQL Server 2012 MCTS on SQL Server 2008 MCSA: SQL Server 2012 + Exam – Transition to SQL Srvr 2012 Part 1 Exam – Transition to SQL Srvr 2012 Part 2 Exam – Transition to SQL Server 2012 - Part 2 Exam – Transition to SQL Server - 2012 Part 1 457 457 458 458 + = = + NOTE: All Upgrade paths are subject to change until final release. * Requires recertification http://www.pass4sureexam.co/70-461.html

  17. SQL Server Instructor-Led Training

  18. Microsoft Official Courseware Querying Microsoft® SQL Server® 2012 Course 10774 Exam 461 Administering Microsoft® SQL Server® 2012 Databases Course 10775 Exam 462 Developing Microsoft® SQL Server® 2012 Databases Course 10776 Exam 464 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Exam 463 Course 10777 Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Course 10778 Exam 466

  19. Microsoft Press—Exam prep Training Kit, Rapid Review Exam 461 Querying Microsoft SQL Server 2012 Administering Microsoft® SQL Server® 2012 Databases Training Kit, Rapid Review Exam 462 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Training Kit, Rapid Review Exam 463 Exam Ref Developing Microsoft® SQL Server® 2012 Databases Exam 464 Exam 465 Exam Ref Designing Database Solutions for Microsoft SQL Server 2012 Exam 466 Exam Ref Implementing Data Models and Reports with SQL Server 2012 Exam 467 Exam Ref Designing BI Sols with Microsoft SQL Server 2012 Platform Training Kits available mid-August 2012 Rapid Reviews available December 2012 Exam Refs available March 2013

  20. Additional resources Microsoft.com/learning • SQL Server certifications • SQL Server training • Learning snacks • Free ebook: Introducing Microsoft SQL Server 2012 Born to Learn • SQL Server forums • MCT SQL Server wiki Microsoftvirtualacademy.com • Breakthrough Insights using Microsoft SQL Server 2012 - Analysis Services • Breakthrough Insights using Microsoft SQL Server 2012 - Scalable data warehouse • Breakthrough Insights using Microsoft SQL Server 2012 - Reporting Services • Cloud on your terms with Microsoft SQL server 2012: Scale on demand TechNet.com • Download trial version • Virtual labs • Tutorials • Demos

  21. Questions

  22. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

  23. Appendix

  24. Frequently asked questions http://www.pass4sureexam.co/70-461.html

  25. More frequently asked questions

  26. MCSA: SQL Server 2008 Microsoft Certified Solutions Associate: SQL Server 2008 The MCSA: SQL Server 2008 certification shows that you have a minimum set of skills to hit the ground running. = • Exam 70-448: Implementing Data Warehouses with Microsoft SQL Server 2012 + Demonstrate your essential skills on SQL Server 2008 by earning the MCSA: SQL Server 2008 certification. • Exam 70-432: Administering a Microsoft SQL Server 2012 Database Note: MCSA: SQL Server 2008 certification does not count towards the MCSE: Data Platform or MCSE: Business Intelligence certifications. However, candidates can upgrade from MCSA: SQL Server 2008 to MCSA: SQL Server 2012 by taking two exams.

  27. Reinvented for the Cloud Microsoft has reinvented its certifications by building cloud related skills validation into the industry’s most recognized and respected certification program. Microsoft Certifications remains the method by which IT Pros and Developers stand out from their peers and for employers to recognize candidates/employees who have the skills required to be productive. To ensure Microsoft Certifications remain relevant, they now validate a broader and deeper set of cloud skills and experience across a technology solution. IT Pro & Developer benefits Hiring Manager benefits Get Recognized Get recognized by peers and hiring managers. Microsoft Certification distinguishes the ability of professionals to deploy, design, optimize and operate technologies for critical IT roles. Get hired Get a job building the future. Microsoft ensures its certifications are on the cutting-edge of technology and are valued by businesses, helping professionals get hired in today’s highly competitive market. Get verification employee knowledge is current . Get qualified candidates A 2011 study showed 86% of hiring managers indicate IT certifications are a high or medium priority during the candidate evaluation process – CompTIA Feb, 2011 Press Release In a survey of 700 IT professionals, 60% said certification led to a new job – Network World, 11/14/2011 A certification research report, 89% of IT hiring managers say that IT certifications help confirm subject matter knowledge and expertise– Channelinsider.com, 2011-10-19 A certification research report, 64 % of IT hiring managers rate certifications as having extremely high or high value in validating the skills and expertise of job candidates– Channelinsider.com, 2011-10-19

  28. New Technical Certification Names Brand recognition Hiring Manager Microsoft Certified Solutions Master (MCSM) Microsoft Certified Solutions Developer (MCSD) Easy to communicate Consistency across the stack Microsoft Certified Solutions Expert (MCSE) Master Microsoft Certified Solutions Associate (MCSA) Expert Level 2 is the destination Value of certification Associate

  29. MS Press—Planned books SQL Server 2012 Internals High Performance T-SQL Using Windows Functions Microsoft SQL Server 2012 Analysis Services: the BISM Tabular Model SQL Server 2012 Integration Services Programming Microsoft SQL Server 2012 SQL Server 2012 Administration Inside Out SQL Server 2012 Reporting Services SQL Server 2012 Step by Step Introducing Microsoft SQL Server 2012 T-SQL Fundamentals

  30. Virtual Machine Plan Hardware Level 6 Minimum level – no less than 8GB RAM, more is better Windows Server 2008 R2 SP1 host machines Base 11A (WS2008R2 + HyperV SP1) MIA-DC (domain controller, 512MB) MIA-SQL1 (SQL 2012, no BI components) Used by 10774, 10775, 10776 MIA-SQLBI (SQL 2012, all BI components, Sharepoint) Used by 10777, 10778 Internet access for SQL Azure Introducing the TMG VM…

  31. MSL Hardware Level 6 Intel 64bit Virtualization Technology (Intel VT) or AMD Virtualization (AMD-V) processor (2.8 GHz dual core or better recommended) Dual 120 GB hard disks 7200 RPM SATA or better* 4 GB RAM expandable to 8GB or higher DVD drive Network adapter Super VGA (SVGA) 17-inch monitor Microsoft Mouse or compatible pointing device Sound card with amplified speakers

  32. SQL Azure SQL Azure: an integrated story for off-premise data Options for existing SQL training In SQL 2012 Courseware Design approach Labs Student Azure Accounts

  33. Custom Deliveries Many diverse secondary audiences Modules & Labs designed for modularity Examples T-SQL for Report Developers Four day: first four days of 10774 + 10778 module 3 Data Quality in SQL Server 2012 One day: 10777 modules 7, 9, 10 Building Reports and Visualizations with SQL Server 2012 Two day: 10778 modules 2, 3, 10, 11, 13 Student Azure Accounts

  34. 10774: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL Module 1: Introduction to SQL Server 2012 Module 2: Introduction to Transact SQL Querying Module 3: Writing SELECT Statements Module 4: Combining Data from Multiple Tables Module 5: Filtering and Sorting Data Module 6: Working with SQL Server Data Types Module 7: Using Built-In Functions Module 8: Grouping and Aggregating Data Module 9: Using Subqueries Module 10: Using Table Expressions Module 11: Use Set Operators Module 12: Using Window Ranking, Offset and Aggregate Functions Module 13: Pivoting and Grouping Sets Module 14: Writing Specialized Queries Module 15: Executing Stored Procedures Module 16: Programming with T-SQL Module 17: Implementing Error Handling Module 18: Implementing Transactions Module 19: Querying SQL Server Metadata Module 20: Improving Query Performance

  35. 10775: Course 10775A: Administering a Microsoft® SQL Server® 2012 Database Module 1: Introduction to SQL Server 2012 and its Toolset Module 2: Preparing Systems for SQL Server 2012 Module 3: Installing and Configuring SQL Server 2012 Module 4: Working with Databases Module 5: Understanding SQL Server 2012 Recovery Models Module 6: Backup of SQL Server 2012 Databases Module 7: Restoring SQL Server 2012 Databases Module 8: Importing and Exporting Data Module 9: Authenticating and Authorizing Users Module 10: Assigning Server and Database Roles Module 11: Authorizing Users to Access Resources Module 12: Auditing SQL Server Environments Module 13: Automating SQL Server 2012 Management Module 14: Configuring Security for SQL Server Agent Module 15: Monitoring SQL Server 2012 with Alerts and Notifications Module 16: Performing Ongoing Database Maintenance Module 17: Tracing Access to SQL Server 2012 Module 18: Monitoring SQL Server 2012 Module 19: Managing Multiple Servers Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

  36. 10776: Developing a Microsoft SQL Server 2012 Database Module 1: Introduction to SQL Server 2012 and its ToolsetModule 2: Working with Data Types Module 3: Designing and Implementing Tables Module 4: Ensuring Data Integrity through Constraints Module 5: Planning for SQL Server 2012 Indexing Module 6: Implementing Table Structures in SQL Server 2012 Module 7: Reading SQL Server 2012 Execution Plans Module 8: Improving Performance through Non-Clustered Indexes Module 9: Designing and Implementing Views Module 10: Designing and Implementing Stored Procedures Module 11: Merging Data and Passing Tables Module 12: Designing and Implementing User-Defined Functions Module 13: Creating Highly Concurrent SQL Server 2012 Applications Module 14: Handling Errors in T-SQL Code Module 15: Responding to Data Manipulation via Triggers Module 16: Implementing Managed Code in SQL Server 2012 Module 17: Storing XML Data in SQL Server 2012 Module 18: Querying XML Data in SQL Server 2012 Module 19: Working with SQL Server 2012 Spatial Data Module 20: Working with Full-Text Indexes and Queries

  37. 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012 Module 1: Introduction to Data Warehouse Concepts Module 2: Data Warehouse Hardware Considerations Module 3: Designing and Implementing a Data Warehouse Module 4: Creating an ETL Solution with SSIS Module 5: Implementing Control Flow in an SSIS Package Module 6: Debugging and Troubleshooting SSIS Packages Module 7: Implementing an Incremental ETL Process Module 8: Incorporating Data from the Cloud in a Data Warehouse Module 9: Enforcing Data Quality Module 10: Using Master Data Services Module 11: Extending SSIS Module 12: Deploying and Configuring SSIS Packages Module 13: Consuming Data in a Data Warehouse

  38. 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012 Module 1: Overview of Reporting and Data Modeling Module 2: Implementing Reports with Reporting Services Module 3: Supporting Self-Service Reporting Module 4: Managing a Reporting Infrastructure Module 5: Creating Multidimensional Databases Module 6: Working with Cubes and Dimensions Module 7: Working with Measures and Measure Groups Module 8: Introduction to MDX Module 9: Customizing Cube Functionality Module 10: Implementing a PowerPivot for Excel Workbook Module 11: Introduction to Data Analysis Expression (DAX) Module 12: Implementing a Tabular Database Module 13: Creating Data Visualizations With Crescent Module 14: Performing Predictive Analysis with Data Mining

More Related