Rajesh: So SQL Server is available for me to download?
Pinal: Yes, sure check the link here.
Rajesh: It is trial do you know when it will be available for everybody?
Pinal: I think you mean General Availability (GA) which is on April 1st, 2012.
Rajesh: I want to have head start with SQL Server 2012 examination and I want to know every single
Exam 70-461: Querying Microsoft SQL Server 2012
This exam is intended for SQL Server database administrators, implementers, system engineers, and developers with two or more years of experience who are seeking to prove their skills and knowledge in writing queries.
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
This exam is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently.
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
The primary audience for this exam is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation.
Exam 70-464: Developing Microsoft SQL Server 2012 Databases
This exam is intended for database professionals who build and implement databases across an organization while ensuring high levels of data availability. They perform tasks including creating database files, creating data types and tables, planning, creating, and optimizing indexes, implementing data integrity, implementing views, stored procedures, and functions, and managing transactions and locks.
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
This exam is intended for database professionals who design and build database solutions in an organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers.
Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
The primary audience for this exam is BI Developers. They are most likely to focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
The primary audience for this exam is the BI Architect. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use.
Looking at Rajesh’s passion, I am motivated too! I may want to start attempting the exams in near future.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Do you have any info about the MCITP for SQL Server 2012? In particular, what exam paths exist and if there are any exams that allow SQL 2008 DBAs to upgrade their certification to SQL 2012 DBA?
Thanks for your blog. It’s a very valuable resource when solving “real world” problems.