Skip to main content

My Certification Road Map of SQL Server

 

Total 7 certification is available on Microsoft SQL Server 2012/14. There is no separate certification for SQL Server 2014 you will find as of now; Only some additional content is added wherever is required to cover the feature of SQL Server 2014.

Category 1 : Common for every one: It has three certification 70-461, 70-462 and 70-463. You could appear in examination in any order.

image

Category 2: Data Platform: It has two certification 70-464 and 70-465. It’s more focused on SQL Server centric mission critical application. How you can develop, design and manage data centric application.

Category 1 + Category 2  = MCSE Data Platform (Microsoft Certified Solution Expert)

image

Category 3: Business Intelligence : It has two certification 70-466 and 70-467. It’s more focused on BI centric solution. How you can develop, design and manage DW / BI Solution.

Category 1 + Category 3  = MCSE Business Intelligence (Microsoft Certified Solution Expert)

image

My Preferred Road map of Certification: I have chosen my road map of SQL Certification based on my less level of required effort that add more value.

70-463  - > 70-461  -> 70-462  - Get the MCSA SQL Server 2012 before March 2015 end

70-467  -> 70-466  - Get the MCSE Business Intelligence before April 2015 end

70-465  -> 70-464 – Get he MCSE Data Platform before May 2015 end

Labels:

Comments

Post a Comment

Popular posts from this blog

Report Model Deployment Using Report Manager

Once you have design the report model and build the project this is the time to deploy on production environment. Similar to Report deployment if you will specify the Report Server and the folder name where your want to deploy the project and deploy; Visual studio environment deploy the project on the report server. But in case it is not possible then have to deploy the Report model through Report Manager Web application (using upload feature of web manager). Connect to the Target server -> Open Report Manager -> Locate the folder where you want to deploy the Report Model -> Click on Upload File Button of Report Manager Locate the Report Model (.smdl) file and click Ok. It will deploy the file on the server. Wait a minute are you getting a problem “ The DataSourceView is missing for the SemanticModel ” or something it just because of data source view is not available. The data source view and report model are the xml based file so you need to merge the both file (.smdl and .ds...
19 comments
Read more

Using Stored Procedure in SSIS OLEDB Source Component

Error: A rowset based on the SQL command was not returned by the OLE DB provider. Cause: Usually it happened when the usp using multiple query calls in the procedure Resolution: Write the below given code at the top of sp in OLEDB source component of SSIS and the code would be something like given below:         SET NOCOUNT ON     SET ANSI_WARNINGS OFF     EXEC <usp_Name>
Post a Comment
Read more