1 / 23

NEW HORIZONS COMPUTER LEARNING CENTERS

NEW HORIZONS COMPUTER LEARNING CENTERS. SQL Server 2012 Courseware & Certification Briefing. Agenda. General Changes & Trends with SQL Server Courses & Exams List of Course & Exam Titles Specific Changes Relative to SQL 2008 Courses SQL 2012 Course & Exam Availability Final Comments.

clodia
Download Presentation

NEW HORIZONS COMPUTER LEARNING CENTERS

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. NEW HORIZONSCOMPUTER LEARNING CENTERS SQL Server 2012 Courseware & Certification Briefing

  2. Agenda • General Changes & Trendswith SQL Server Courses & Exams • List of Course & Exam Titles • Specific Changes Relative to SQL 2008 Courses • SQL 2012 Course & Exam Availability • Final Comments Much of the content for this presentation was derived or directly taken from a presentation to Microsoft Certified Trainers (MCTs) in November 2011 as presented by Pete Harris, Learning Product Partner at Microsoft Learning (MSL).

  3. General Changes & Trends • More Challenging Exams • Increases the Value of Certification • One-to-one Mapping of Courses to Exams! • Major Philosophical Switch • As Usual, Additional Study and Exam Prep Are Required to Pass Exams • Closer Mapping of Course Topics to Skills Required in the Industry • All the Courseware Will Be One Volume • Only One “Book” Instead of Two • Elimination of Three Day Courses; All SQL Courses will be Five Days Long • The Courses Were Designed Modularlyto More Easily Facilitate Custom Deliveries • Example 1: T-SQL for Report Authors (First Four Days of 10774) • Example 2: Building Reports & Visualizations (Portions of 10778)

  4. Target Learning Product Audience • Audience 1, Core Skills • “Accidental DBA” & Beyond • Products that Require Some Form of SQL Server • Microsoft Accounting Products (Dynamics) • SharePoint • System Center Configuration Manager • System Center Virtual Machine Manager • System Center Operations Manager • System Center Data Protection Manager (I think) • Windows Server Update Service (WSUS) • Audience 2, Traditional Database Professionals (those working with data full time) • Administrators • Developers • Audience 3, Business Intelligence Professionals • Reporting • ETL • OLAP • Data Mining The Point: When designing the new SQL 2012 courseware Microsoft aimed at these three audiences.

  5. SQL 2012 Exam & Certification Details • Seven Certification Exams (Up from Six) • Two Certification Paths (Down from Three) • Re-Certification Will Be Required After Three Years See diagram: SQL 2008 Certification Paths

  6. List of Course & Exam Titles • Course 10774A / Exam 70-461 • Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL • Course 10775A / Exam 70-462 (Maps Closely to the Current 6231B) • Maintaining a Microsoft® SQL Server® 2012 Database • Course 10776A / Exam 70-464(Maps Closely to the Current 6232B) • Implementing a Microsoft® SQL Server® 2012 Database • Course 10777A / Exam 70-463 • Implementing a Data Warehouse with Microsoft® SQL Server® 2012 • Course 10778A / Exam 70-466 • Implementing Reports and Data Models with Microsoft® SQL Server® 2012 • Exam 70-465 (Notice, no corresponding course exists) • Designing Database Solutions with Microsoft® SQL Server® 2012 • Exam 70-467(Notice, no corresponding course exists) • Designing Business Intelligence Solutions for Microsoft® SQL Server® 2012

  7. Specific Changes from SQL Server 2008 Courses • The Querying Course Became Five Days • It Is Suitable for Beginners • It Should Represent a Great Improvement Over the (Poor) 2778 Course • There Are Two, Five Day Business Intelligence (BI) Courses Instead of Three, Three Day Courses • So, there are Ten Total Days of BI Training Rather than Nine • The BI Courses are Scenario-oriented Rather than Tool-oriented • Use a Screwdriver or Saw v. Becoming a Carpenter

  8. Curiously Absent… • No SQL 2012 Upgrade Courses from Microsoft are Planned! • This Segment of Learning (& Other Gaps) Will Ideally Be Addressed Through theCourseware Library • No SQL Azure – Specific Courses • SQL Azure Content Exists, However, in Relevant Places within the SQL Courseware Portfolio

  9. Courseware & Exam Availability • (Microsoft Internal) Course Beta Delivery: ~February 2012 • Beta MOC: ~February 2012 (after Beta Course Delivery), Based off of SQL Server 2012 “RC0” • For the First Time Beta MOC is Orderable and Saleable • CTP v. RC • Define: .ISO File • Release to Market (RTM): Q2 CY 2012, Up to 90 Days after the SQL 2012 Product Release • Exams: Q2 CY 2012

  10. Course10774: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL • Maps to Exam 70-461 • An Evolution of 2778, Not the Same Design • Simplified Sample Database • The 2778 Sample Has Over 70 Tables • Increased to 5 days • Primary Audience is Junior Database Developers/Everyone • Secondary Audience is Report Developers • Designed for Alternate 4 Day SELECT Focused Delivery.

  11. SQL Statement Categories Language (i.e., SQL) Statement Category (i.e., (DML) Statement (i.e. SELECT)

  12. Courses10775 & 10776 • Course 10775A -> Exam 70-462 • Maintaining a Microsoft® SQL Server® 2012 Database • Course 10776A -> Exam70-464 • Implementing a Microsoft® SQL Server® 2012 Database • Leveraged the Design of the “B” Courses • Far Superior than the “A” Courses • Same Database & Objects

  13. Courses 10777 & 10778 • Course 10777A -> Exam 70-463 • Implementing a Data Warehouse with Microsoft® SQL Server® 2012 • Course 10778A -> Exam 70-466 • Implementing Reports and Data Models with Microsoft® SQL Server® 2012 • Designed together, Single lab scenario. • Five Days Each • Again, Scenario-focused Rather than Tool-focused

  14. Exam 70-465: DesigningDatabase Solutions with Microsoft® SQL Server® 2012 • Exam Functional Groups: • Design Database Structure • Design Databases and Database Objects • Design Database Security • Design a Troubleshooting and Optimization Solution No Course Exists to Directly Prepare for this Exam

  15. Exam 70-467: Designing Business Intelligence Solutions for Microsoft® SQL Server® 2012 • Exam Functional Groups • Plan BI Infrastructure • Design BI Infrastructure • Design an ETL Solution • Design BI Data Models • Design a Reporting Solution No Course Exists to Directly Prepare for this Exam

  16. Final Comments • Many Changes are Coming to the SQL Server 2012 Product • Many Changes are Coming to the SQL Server 2012 Courseware and Exams • In All the Areas of I.T. Organizations Change Their Database Platform the Slowest • …But They Can’t Stay with SQL 2000 and SQL 2005 Forever! This Mean$ • Opportunitie$

  17. Appendices • List of Module Titles per Course • SQL Resources on my Website

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

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

  20. Course 10776A: Implementing 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

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

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

  23. Resources (for you and your clients) • Microsoft SQL Server homepage • www.microsoft.com/sql • Microsoft Learning homepage • www.microsoft.com/learning • My Website Resources • Homepage • www.e-Squillace.com(Search button, Test taking tips link) • Diagrams • www.e-Squillace.com/tech/techdiagrams(several SQL and SQL BI diagrams) • Screenshot Gallery • www.e-Squillace.com/tech/screenshotgallery(look in the SQL screenshot category; a SQL BI category exists too) • SQL Server reference homepage • www.e-Squillace.com/tech/techreference/sql(a huuuuge amount of links) • SQL Server BI reference homepage • www.e-Squillace.com/tech/techreference/sqlbi/sqlbi.htm(also a huuuuge amount of links) • My Library Books (click on this link) • User Groups (see SQLPASS.org for a larger listing) • West Michigan SQL Server User Group  (WMSSUG) • Detroit Area SQL ServerUser Group(Detroit SSUG)

More Related