Capabilities Presentation - E-Squillace

Capabilities Presentation - E-Squillace

NEW HORIZONS COMPUTER LEARNING CENTERS SQL Server 2012 Courseware & Certification Briefing Delivered: December 13, 2012 The Presenter George Squillace (SQL is in the name) New Horizons Great Lakes, 20th year with the company 92 times in the exam booth Husband, Dad

MCT (since 1997) Three SQL 2012 tests down, four to go MCITP SQL 2008 Business Intelligence Development MCITP SQL 2008 Database Administration MCTS SQL 2008 Database Development MCITP Enterprise Messaging Administrator on Exchange 2007 MCITP Enterprise Administrator on Windows Server 2008 MCTS Vista Deployment MCDBA MCSE CompTIA A+, Network+ Agenda General Changes & Trends with SQL Server 2012 Courses & Exams SQL Server Courseware Portfolio Curiously Absent Final Comments Appendices Much of the content for this presentation was derived or directly taken from a presentation to Microsoft Certified Trainers (MCTs) as presented by Pete Harris, Learning Product Partner at Microsoft Learning (MSL). Part 1 General Changes & Trends with SQL Server 2012 Courses & Exams Better Quality Courseware More Challenging Exams Increases the Value of Certification Harder for Career Students

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 Still too much material for typical time allotment Part 2 General Changes & Trends with SQL Server 2012 Courses & Exams Elimination of Three Day Courses; All SQL Courses will be Five Days Long This was a concern for contract trainers Redesigned Microsoft Learning website New Database Microsoft Technology Associate (MTA) certification for the entry level The Courses Were Designed Modularly to 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) Custom courseware seems easy to put together through Arvato/ Skillpipe

SQL Courseware Learning Product Target Audiences 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) Database Administrators Database Developers

The SQL Server product is amusement park huuuge! 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. Courseware Portfolio - Querying End User Querying Courses Part 1 & Part 2 (one day each) Courseware Library 50027 (two days) MOC 2778A (SQL 2005 & SQL 2008 & R2) Lots of room for design improvement (three days)

MOC 10774A Querying a SQL Server 2012 Database Written by a great team The subject matter expert (SME) is Jedi Master Itzik Ben-Gan (five days) SQL Statement Categories Language (i.e., SQL) Statement Category (i.e., (DML) Statement (i.e. SELECT) Course Portfolio Database Administration 6231B Administering a SQL 2008 R2 Database Excellent material, albeit too much (five days) 10775A - Administering a SQL 2012 Database Nearly word-for-word identical to 6231B which means you can sell either and we could run either (five days) Interesting: Neither cover High Availability topics (other than in a brief appendix) Course Portfolio Database Development

6232B Implementing a SQL 2008 R2 Database Again, excellent material, albeit too much (five days) 10776A - Implementing a SQL 2012 Database Again, nearly word-for-word identical to 6232B which means you can sell either and we can run either (five days) 20465A - Designing Database Solutions with SQL Server 2012 (five days) Course Portfolio Business Intelligence Development 10777A Implementing a Data Warehouse with SQL Server 2012 Data Warehousing design + SSIS instruction (five days) 10778A Implementing Data Models & Reports with SQL Server 2012 Reporting Services + Analysis Services (five days) There Are Two, Five-Day Core Business Intelligence (BI) Courses Instead of Three, Three-Day Courses The BI Courses are Scenario-oriented Rather than Tool-oriented

Use a Screwdriver or Saw v. Becoming a Carpenter Issue: Some students will only want reporting; some will only want OLAP. Possibility of a solution from the Courseware Library 20467A - Designing Business Intelligence Solutions with SQL Server 2012 (five days) List of Courses Mapped to 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 Course 20465A / Exam 70-465 Designing Database Solutions with Microsoft SQL Server 2012 Course 20467A / Exam 70-467 Designing Business Intelligence Solutions for Microsoft SQL Server 2012 SQL Server 2012 Exam & Certification Summary Eight Certification Exams (Up from Six) Three Certification Paths (Totally new paths) Re-Certification Will Be Required After Three Years See diagram: SQL 2012 Certification Paths (next slide) Curiously Absent No SQL 2012 Upgrade Courses from Microsoft are Planned! No High Availability-specific courses There is (finally) HA topics in course 20465A No Report Writing-specific courses

No SQL Azure-specific Courses SQL Azure Content Exists, However, in Relevant Places within the SQL Courseware Portfolio These Segments of Learning (& Other Gaps) Will Ideally Be Addressed through the Courseware Library List of High Availability Technologies in SQL Server (For the record) SQL 2005 & 2008 HA solutions Replication Failover Clustering Log Shipping Database Mirroring SQL 2012 (same as above, plus) adds Always On technology; an extension to Database Mirroring Final Comments Many Changes came with the SQL Server 2012 Product Many Changes came with the SQL Server 2012 Courseware and Exams

In All the Areas of I.T. Organizations Change Their Database Platform the Slowest But They Cant Stay with SQL 2000 and SQL 2005 Forever! This Mean$ Opportunitie$ Appendices List of Module Titles per Course SQL Resources on my Website 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 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 Course 10776A: 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 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 Data Module 20: Working with Full-Text Indexes and Queries

via Spatial 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 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 Course 20465A - Designing Database Solutions for SQL Server 2012 Module 1: Designing a Database Server Infrastructure Module 2: Designing a Logical Database Schema

Module 3: Designing a Physical Database Implementation Module 4: Designing a Database Solution for BLOB Data Module 5: Tuning Database Performance Module 6: Designing Database Security Module 7: Using Policy-Based Management Module 8: Monitoring Server Health Module 9: Designing a Database Backup Solution Module 10: Automating Multi-Server Maintenance

Module 11: Managing SQL Server with PowerShell Module 12: Replicating Data Module 13: Designing for High Availability Course 20467A - Designing Business Intelligence Solutions with SQL Server 2012 Module 1: Planning a BI Solution Module 2: Planning a BI Infrastructure Module 3: Designing a Data Warehouse Module 4: Designing an ETL Solution

Module 5: Designing Analytical Data Models Module 6: Planning a BI Delivery Solution Module 7: Designing a Reporting Services Solution Module 8: Designing an Excel-Based Reporting Solution Module 9: Planning a SharePoint Server BI Solution Module 10: Monitoring and Optimizing a BI Solution Module 11: Planning BI Operations Resources Microsoft SQL Server homepage

www.microsoft.com/sql Microsoft Learning homepage www.microsoft.com/learning My Website Resources Homepage 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/techdiagrams (several SQL and SQL BI diagrams)

Screenshot Gallery www.e-Squillace.com (Search button, Test taking tips link) Diagrams www.e-Squillace.com/tech/techreference/sql (a huuuuge amount of links) SQL Server BI reference homepage (for you and your clients) www.e-Squillace.com/tech/techreference/sqlbi/sqlbi.htm (also a huuuuge amount of links) My Library Books User Groups (see SQLPASS.org for a larger listing) West Michigan SQL Server User Group (WMSSUG) Detroit Area SQL ServerUser Group (Detroit SSUG)

Recently Viewed Presentations

  • Obecná deformační metoda

    Obecná deformační metoda

    Nakladatelství VUT Brno, 1993. Válcová betonová nádrž (E= 27,0 kPa, m=0,2) s konstantní tloušťkou h=0,2 m o průměru 8 m a výšce 5 m je zatížená tíhou kapaliny (g=10 kNm-3). Stěna nádrže je na horním okraji volná, na spodním okraji...
  • Supported in part by Arkansas Blue Cross and

    Supported in part by Arkansas Blue Cross and

    Ms. Remy is very emotional during this visit- She is angry that because of some people addicted to opioids, she is forced to reduce dose of medications that are working for her. She asks when she can have marijuana. ......
  • Android OS by the Open Handset Alliance and Google

    Android OS by the Open Handset Alliance and Google

    Android OS by the Open Handset Alliance and Google. Android supports windows, panes, 3d graphics. Connects to Wi-Fi, Bluetooth, cellular networks
  • Association Study of Late-Onset Alzheimer's Disease Risk Variants

    Association Study of Late-Onset Alzheimer's Disease Risk Variants

    Upon review of the genotype frequencies for the tested SNPs in PCA vs. control subjects, we determined that there were significantly less heterozygote subjects for the ABCA7 SNP, rs3764650, than expected in the PCA cohort, leading to deviation from Hardy-Weinberg...
  • Meet the Coordinators - Shariel Rodriguez-Echevarria

    Meet the Coordinators - Shariel Rodriguez-Echevarria

    Meet the Mentors - Jolene Addi. Year: Class of 2021. Major(s): Physiology and Neurobiology. Involvement: WiMSE, Campus Curlz, African Student Association (ASA), National Council of Negro Women (NCNW), Medical Association of Pre-med Students (MAPS), & Nubian Dance Team
  • A4B Project Management Seminar January 14th 2010 Agenda

    A4B Project Management Seminar January 14th 2010 Agenda

    A4B Project Management Seminar January 14th 2010 Applying to A4B - the Competitive Calls Calls issued in November 2009 Deadline February 26th 2010 Projects to start June 1st 2010 KTC and CIRPS only Only 2 submissions allowed per institution Key...
  • National HIV notifications Q1 2014  Q4 2018 The

    National HIV notifications Q1 2014 Q4 2018 The

    The Kirby Institute, UNSW Sydney. Source: State and territory health authorities. HIV diagnoses, by quarter and Indigenous status. Number of diagnoses Aboriginal and Torres Strait Islander Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2...
  • MURI - Stanford University

    MURI - Stanford University

    • An overall phase develops proportional to area (topological phase), A desired phase shift of achieved with Lifetime-limited atomic linewidth: 3 MHz via Auger recombination Radiative lifetime: 2 ms via phonon assisted process Optimum regime for detuning is just off-resonance...