Wednesday, November 28, 2012

Lets Go Forward... SQL Server Series..No. 2

Life is full of challenges and twists.Before we Go Forward in this SQL Server series of Posts.

Few things to remember:
  1. Forget the Past Failures to make your Future Success.
  2. Control your life to move in positive direction.
  3. Don't run away from problems..Think twice to Solve them.
  4. 'No Procrastination"...Make a Action Plan to set your Goals.
  5. After each Completion of your goal,Appreciate your Success.  
Goal : SQL Server Certificaions



ExamCredit ForSelected Topics
70-461: Querying Microsoft SQL Server 2012
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Create/design tables and views
  • Use joins, sub-queries, new data types and query features
  • Create/design/modify stored process, aggregate functions, triggers
  • Modify data with INSERT/UPDATE/DELETE/MERGE
  • Design/apply user-defined functions
70-462: Administering Microsoft SQL Server 2012 Databases
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Install SQL Server 2012 and related services
  • Create and manage SQL Server instances, including a clustered instance
  • Diagnose and respond to blocking, locking, deadlocking
  • Backup and restore databases
  • Implement and maintain indexes
  • Contrast and compare AlwaysOn technologies
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Design/implement star vs. snowflake schemas, fact tables, dimensions, keys
  • Create/apply project level connection managers, slowly changing dimensions, fuzzy lookups
  • Execute SSIS packages with SSMS, DTEXEC, SQL Server Agent
  • Create, assign, read variables and parameters
  • Plan and implement full and incremental loads for data warehouses
  • Implement solutions with Data Quality Services
70-464: Developing Microsoft SQL Server 2012 DatabasesMCSE for SQL Server 2012 Data Platform
  • Create/implement database objects without using built-in tools
  • Apply data types: CLR, sequential GUID values, spatial
  • Understand relative advantages of database tables, temporary tables, and table variables
  • Create, assign, read variables and parameters
  • Create and alter indexes, including filtered, semantic, XML
  • Optimize queries with execution plans and DTA
70-465: Designing Database Solutions for Microsoft SQL Server 2012MCSE for SQL Server 2012 Data Platform
  • Apply physical database issues, such as filestream and file groups
  • Monitor an instance using such tools as Profiler, Perfmon and DMVs
  • Automate (setup, maintenance, monitoring) across multiple databases and multiple instances
  • Design instance-level security, such as logon triggers, transparent data encryption, DDL triggers
  • Manage maintenance administration, such as rebuild vs. defrag indexes, online vs. offline index rebuild
  • Implement high availability via clustered servers, mirroring, replication
70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012MCSE for SQL Server 2012 Business Intelligence
  • Implement cubes: build cube with SQL Server Data Tools, configure additive and non-additive measures, and implement many-to-many relationships
  • Create and debug MDX queries
  • Contrast multidimensional and tabular data models
  • Deploy SSAS databases
  • Know SSRS report and design issues, such as crosstab report, drill-down reports, report parameters
  • Configure report data sources and datasets
70-467: Designing Database Solutions for Microsoft SQL Server 2012MCSE for SQL Server 2012 Business Intelligence
  • Specify and optimize MDX and DAX queries
  • Use partitioning to speed up the loading of a fact table
  • Design a BI reporting architecture, including such features as linked reports, drill-down reports, sub reports
  • Know when to choose between UDM and BISM
  • Possess a working knowledge of how to implement MDX calculations
  • Design SSIS deployments using the project deployment model, passing values at execution time, sharing parameters between packages
Microsoft Certified Solutions Master
The MCSM level consist of two platforms (SQL Server and Intelligence):
MCSM: Data Platform
Prerequisite: MCSE: Data Platform
  • Exam 986: MCSM Data Platform Knowledge
  • Exam 986: MCSM Data Platform Lab
  • This level of certification will require the completion of Lab-based and Technical exams

MCSM: Intelligence
Prerequisite: MCSE: Business Intelligence Platform
Microsoft Certified Architect
Prerequisite: MCSM: SQL Server and MCSM: Intelligence
MCA: SQL Server
Full requirements are still being finalised.  More information can be found at http://www.microsoft.com/learning/en/us/certification/MCSM-sql-server-data-platform.aspx