1 / 32

MSL s Portfolio for Microsoft SQL Server 2012

Agenda. State of SQL Server 2008 CoursesGoals, Planning

sandra_john
Download Presentation

MSL s Portfolio for Microsoft SQL Server 2012

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. MSL’s Portfolio for Microsoft SQL Server 2012 Pete Harris Learning Product Planner Microsoft Learning

    2. Agenda State of SQL Server 2008 Courses Goals, Planning & Design for SQL Server 2012 Portfolio Details

    3. State of the 2008 Content 6231B & 6232B courses Fitting 20 modules into 5 days “The four labs a day proved to be an excellent design decision.” “They are a real pleasure to teach and are very well received by my students.” Exam refreshes: 70-432, 70-433 (December) No changes coming for BI courses for 2008 R2 NSAT progress (vsat-unsat+100)

    4. Business Goals for SQL Server 2012 Portfolio MSL Business One Book Commercial Beta MOC Time to Market Exam/Course Mapping Learning Partners Innovate to support future strength of MSL & partner businesses Build a portfolio with value from end-to-end Contribute to Certification Integrity goals

    5. Cert Integrity & Mapping Increased difficulty of exams Highly Relevant Objective Domains Alignment between Courses & Exams LP & MCTs have been asking for alignment MSL’s broad support of certification across the portfolio Simplify the portfolio story Cross-product & Community design

    6. Exam Preparation

    7. Content Planning Process & Research Partners LP PAC, MCTs, SQL TAP, SQL MVPs SQL BG Role/Persona analysis Focus groups/Surveys Early guidance from early adopters 117 skills analysis surveys (up from 8 people working on the OD) 319 individuals involved in blueprinting (up from 30) SQL Server Strategy

    8. Audience Overview DB Professionals Database professionals who administer and maintain SQL Server database solutions. IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database. BI Professionals Database professionals who need to fulfill a Business Intelligence Developer role. Core Skills Everybody…

    9. SQL Server 2012 Certification 7 exams 2 paths – DB Platform & BI There will be an upgrade path from 2008 certs Re-certification required (3 years) Re-cert means taking a re-cert exam Azure and Windows Phone certs Krista Wall’s session: “What’s Next for Certification” Read more

    10. Course/Exam List 10774A / 70-461 Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL 10775A / 70-462 Maintaining a Microsoft® SQL Server® 2012 Database 10776A / 70-464 Implementing a Microsoft® SQL Server® 2012 Database 10777A / 70-463 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 10778A / 70-466 Implementing Reports and Data Models with Microsoft® SQL Server® 2012 70-465 Designing Database Solutions with Microsoft® SQL Server® 2012 70-467 Designing Business Intelligence Solutions for Microsoft® SQL Server® 2012 * these numbers are not final and may shift a bit…

    11. Schedule Course Beta delivery: ~February 2012 Beta MOC: ~February 2012 RTM: Q2 CY 2012 Exams: Q2 CY 2012

    12. VM Plan VMs – designed to run on 8GB host machines (Hardware level 6) Windows Server 2008 R2 SP1 host machines MIA-DC (domain controller, 512MB) MIA-SQL1 (2012, no BI components) Used by 10774, 10775, 10776 MIA-SQLBI (2012, all BI components, Sharepoint, 6GB) Used by 10777, 10778 Internet access, for The Cloud…

    13. SQL Azure SQL Azure: an integrated story for off-premise data Options for existing SQL training How this appears in 2012 courseware…

    14. 10774: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL Maps to 70-461 An evolution of 2778, not the same design Increased to 5 days Primary audience is Junior Database Developers/Everyone Secondary audience is report developers Designed for alternate 4 day SELECT focused delivery.

    15. 10775/10776 10775A -> 70-462 Maintaining a Microsoft® SQL Server® 2012 Database 10776A -> 70-464 Implementing a Microsoft® SQL Server® 2012 Database Leveraged the design of “the B courses” Same database & objects

    16. 10775 New Content Discussion around servicing SQL Server (Service Packs, Cumulative Updates, Hotfixes) SQL Server use of automated update Additional CheckPoint related options Partial database containment Users with passwords (contained users) User-defined server roles In-place upgrades of data-tier applications Appendix with intro to Always On, High Availability and Replication concepts

    17. 10776 New Content Use of SC collations Use of TRY_PARSE, TRY_CONVERT Further discussion on IDENTITY constraints Working with SEQUENCES Slight course reordering to improve overall flow (in particular, constraint discussion moved directly after discussion on logical table design) Use of THROW and comparisons to RAISERROR Full-globe and arc support in spatial Customisable nearness in full-text

    18. 10777/10778 10777A -> 70-463 Implementing a Data Warehouse with Microsoft® SQL Server® 2012 10778A -> 70-466 Implementing Reports and Data Models with Microsoft® SQL Server® 2012 BI training up from 9 days over three courses to 10 days over 2 courses Scenario focused, not tool focused Designed together. Single lab scenario. Very modular to simplify custom deliveries

    19. 70-465: Designing Database Solutions with Microsoft® SQL Server® 2012 Functional groups: Design Database Structure Design Databases and Database Objects Design Database Security Design a Troubleshooting and Optimization Solution

    20. 70-467: Designing Business Intelligence Solutions for Microsoft® SQL Server® 2012 Functional Groups Plan BI Infrastructure Design BI Infrastructure Design an ETL Solution Design BI Data Models Design a Reporting Solution

    21. Custom Deliveries Many diverse audiences Modules & labs are designed with modularity as a goal to enable alternate deliveries. T-SQL for Report Developers First four days of 10774 Data Quality in SQL Server 2012 One day: Modules 7, 9, and 10 from 10777 Building Reports and Visualizations with SQL Server 2012 Two day: Modules 2, 3, 10, 11, 13 from 10778

    22. CW Library Opportunities to fill in the portfolio Upgrading to 2012 Niche BI content Other ideas? We’re listening!

    23. Call to Action Get ready… MCT SQL Forums Technical Review Trainer prep WIKI Commercial Beta MOC We will notify you about exam betas SME Database

    24. Other Sessions Liberty Munson – “What’s really behind everything in an exam?” Krista Wall – “What’s Next for Certification”

    25. Questions?

    26. Don’t forget to thank our sponsors! They made this possible! Go sponsors!!!!!Don’t forget to thank our sponsors! They made this possible! Go sponsors!!!!!

    27. Appendix All module details are subject to change prior to release…

    28. 10774A: 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

    29. 10775A: Course 10775A: Maintaining 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

    30. 10776: Implementing a Microsoft SQL Server 2012 Database Module 1: Introduction to SQL Server 2012 and its Toolset Module 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

    31. 10777A: 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

    32. 10778A: Implementing Reports and Data Models 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

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

More Related