Mr. DiGi's List: SQL Server certifications

• The other two MCPs must each hold one of the following certifications or have passed the following exam:

   
  • Exam 70-464: Developing Microsoft SQL Server 2012 Databases and Exam 70-465: Designing Microsoft SQL Server 2012 Database Solutions

• Two of the MCPs must each hold one of the following certifications:

   
  • MCSE: Data Platform
• 1. Pass the qualifying exams or application tests
• employ or contract with four unique Microsoft Certified Professionals (MCPs)

• Two of the MCPs must each hold one of the following certifications:

   
  • MCSE: Data Platform

• The other two MCPs must each hold one of the following certifications or have passed the following exam:

   
  • Exam 70-464: Developing Microsoft SQL Server 2012 Databases and Exam 70-465: Designing Microsoft SQL Server 2012 Database Solutions
• 5. Provide customer evidence
• Your company must submit five unique² customer references.³
• • Showcases database migration tools and services, management tools, and services that use SQL Server technology.
   
  • Details a project that your organization has completed within the past 12 months and that can be verified with your customer.
• 6. Gather customer feedback

8 more annotations...

• Two of the MCPs must each hold one of the following certifications:
• MCSE: Business Intelligence
• The other two MCPs must each hold one of the following certifications or have passed one of the following exam options:
• Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 and Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

• Your company must submit five unique² customer references.³ Be sure that each reference showcases one of the following:

   
  • Your organization’s BI services, reporting, tools, and application solutions that use SQL Server technology, Microsoft SharePoint and Microsoft Excel technologies, or Excel Services technologies.
   
  • Development, implementation, and customization of data visualization of BI information, based on a combination of Microsoft Visio and Microsoft Bing Maps.
• Additionally, each reference must feature a project that your organization has completed within the past 12 months and that can be verified with your customer.

4 more annotations...

• Module 1: Introduction to Microsoft SQL Server 2012
• Module 2: Getting Started with SQL Azure
• Module 3: Introduction to T-SQL Querying
• • Describe the logical order of operations in SELECT statements
• Module 4: Writing SELECT Queries
• Module 5: Querying Multiple Tables
• Module 6: Sorting and Filtering Data
• Filtering with the TOP and OFFSET-FETCH Options
• Working with Unknown and Missing Values
• Module 7: Working with SQL Server 2012 Data Types
• Module 8: Using Built-In Functions
• Module 9: Grouping and Aggregating Data
• Module 10: Using Subqueries
• Writing Self-Contained Subqueries
• Writing Correlated Subqueries
• Module 11: Using Table Expressions
• Using Derived Tables
• Using Common Table Expressions
• Using Views
• Using Inline Table-Valued Functions
• Module 12: Using Set Operators
• Writing Queries with the UNION Operator
• Using EXCEPT and INTERSECT
• Using APPLY
• Module 13: Using Window Ranking, Offset and Aggregate Functions
• Module 14: Pivoting and Grouping Sets
• Module 15: Querying SQL Server Metadata
• Module 16: Executing Stored Procedures
• Module 17: Programming with T-SQL
• Module 18: Implementing Error Handling
• Module 19: Implementing Transactions
• Module 20: Improving Query Performance

30 more annotations...

• Module 1: Introduction to SQL Server 2012 and its Toolset
• Module 2: Preparing Systems for SQL Server 2012
• memory configuration options and I/O subsystem pre-installation checks using SQLIOSim and SQLIO
• 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
• Restoring System Databases and Individual Files
• Module 8: Importing and Exporting Data
• Module 9: Authenticating and Authorizing Users
• Module 10: Assigning Server and Database Roles
• Creating User-defined 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
• Investigate table lock performance
• 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

22 more annotations...

• Module 7: Implementing an Incremental ETL Process
• Module 2: Data Warehouse Hardware
• Module 10: Using Master Data Services
• SQL Server 2012 Data Quality Services (DQS)
• Module 3: Designing and Implementing a Data Warehouse
• Module 9: Enforcing Data Quality
• Module 4: Creating an ETL Solution with SSIS
• • Creating a SQL Azure Database
  • Extracting Data from a SQL Azure Database
  • Obtaining Data from the Windows Azure Marketplace
• Module 1: Introduction to Data Warehousing
• Module 6: Debugging and Troubleshooting SSIS Packages
• Module 5: Implementing Control Flow in an SSIS Package
• Module 8: Incorporating Data from the Cloud into a Data Warehouse
• Module 1: Introduction to Data Warehousing
• Module 2: Data Warehouse Hardware
• 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 into a Data Warehouse
• • Creating a SQL Azure Database
  • Extracting Data from a SQL Azure Database
  • Obtaining Data from the Windows Azure Marketplace
• Module 9: Enforcing Data Quality
• SQL Server 2012 Data Quality Services (DQS)
• Module 10: Using Master Data Services
• Master Data Services Add-in for Excel
• Master Data Services Add-in for Excel
• Module 11: Extending SQL Server Integration Services
• Module 12: Deploying and Configuring SSIS Packages
• Module 13: Consuming Data in a Data Warehouse

27 more annotations...

• This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.

• 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
• Implementing Domain Integrity
• 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 Nonclustered Indexes
• Module 9: Designing and Implementing Views
• Performance Considerations for Views
• Module 10: Designing and Implementing Stored Procedures
• Module 11: Merging Data and Passing Tables
• • Using the MERGE Statement
  • Implementing Table Types
  • Using TABLE Types As Parameters
• Module 12: Designing and Implementing User-Defined Functions
• Module 13: Creating Highly Concurrent SQL Server 2012 Applications
• • Introduction to Transactions
  • Introduction to Locks
  • Management of Locking
  • Transaction Isolation Levels
• Module 14: Handling Errors in T-SQL Code
• Module 15: Responding to Data Manipulation via Triggers
• Advanced Trigger Concepts
• Module 16: Implementing Managed Code in SQL Server 2012
• • Assessing Proposed CLR Code
  • Implementing a CLR Assembly
  • Implementing a CLR User-defined Aggregate and CLR User-defined Data Type
• Module 17: Storing XML Data in SQL Server 2012
• Module 18: Querying XML Data in SQL Server
• Module 19: Working with SQL Server 2012 Spatial Data
• Module 20: Working with Full-Text Indexes and Queries

24 more annotations...

• 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
• • Designing Server-Level Security
  • Designing Database-Level Security
  • Transparent Database Encryption
  • Auditing Database Activity
• 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
• Introduction to PowerShell
• • Exercise 1: Using PowerShell interactively
  • Exercise 2: Backing up a Database by Using PowerShell
  • Exercise 3: Creating a PowerShell Script to Standardize Database Creation
• Module 12: Replicating Data
• • SQL Server Replication
  • Planning Replication
• Module 13: Designing for High Availability
• • High Availability in SQL Server 2012
  • AlwaysOn Availability Groups

16 more annotations...