locked
Which path will be the perfect in MCSD for me to deal with SQL Server Stuff ? RRS feed

  • Question

  • I intended to be a SQL Server developer and Administrator , but I planning to take MCSD before MCSA SQL Server 2012 , to help me to developing a full solutions to any database system , but I found MCSD certificate had more than one path 

    First Path
    MCSD: Windows Store Apps Using C# :
    Exam 70-483 
     - Manage program flow (25%)
     - Create and use types (24%)
     - Debug applications and implement security (25%)
     - Implement data access (26%)
    Exam 70-484
     - Design Windows Store apps (20-25%)
     - Develop Windows Store apps (15-20%)
     - Create the user interface (20-25%)
     - Program the user interaction (20-25%)
    Manage security and data (20-25%)
    Exam 70-485
     - Develop Windows Store apps (15–20%)
     - Discover and interact with devices (15–20%)
     - Program user interaction (15–20%)
     - Enhance the user interface (15–20%)
     - Manage data and security (15–20%)
     - Prepare for a solution deployment (15–20%)

    Second Path
    MCSD: Web Applications
    Exam 70-480
     - Implement and manipulate document structures and objects (24%)
     - Implement program flow (25%)
     - Access and secure data (26%)
     - Use CSS3 in applications (25%)
    Exam 70-486
     - Design the application architecture
     - Design the user experience
     - Develop the user experience
     - Troubleshoot and debug web applications
     - Design and implement security
    Exam 70-487
     - Accessing data (24%)
     - Querying and manipulating data by using the Entity Framework (20%)
     - Designing and implementing WCF Services (19%)
     - Creating and consuming Web API-based services (18%)
     - Deploying web applications and services (19%)

    The question now which path I must take before I delve into MCSA SQL Server 2012 will help me more in the database world and sharp my skills as a database developer and administrator in the future and  will help me to create or develope a full solutions to any database system in the future , and also this path will be related more to database world and more valuable in the job market

    In other words, Which path contain alot of work with databases and SQL stuff , will help me in SQL Server , Please Help

    Mohamed Ahmed Database Administrator & Developer

    Tuesday, April 8, 2014 10:28 AM

Answers

  • Hi,

    like usual, it depends. It depends on your background (have you done any Windows Store or web development before?) and your main working area. In my opinion the MSCD Web Applications track has more data access topics in it where the MCSD Windows Store Apps mainly focuses on Windows Store App specific features.

    Additionally, when working as a database administrator you will have more likely contact to web developers instead of Windows Store App developers.


    Best Regards. When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. This helps us build a healthy and positive community.

    @Horizon_Net | Blog

    Tuesday, April 8, 2014 11:05 AM
    Answerer
  • Hi, MohamedDBA.

    I agree with Horizon_Net that the MCSD: Web Applications certification would be best for your certification goals. Especially since you are concerned with becoming certified in the future of database development technologies.

    Specifically, the 70-487 certification exam covers programming with WCF (for data access over the internet/intranet), Entity Framework (for data access anywhere), Web API (REST Services for data access over the internet/intranet), and Microsoft Azure (for hosting databases, applications, and much more in the cloud). Most likely, you will be managing SQL Server databases in the cloud in your future.

    I highly recommend that you swap 70-483 for 70-480, which will still count for the MCSD: Web Applications certification. The 70-483 C# programming exam will be really useful while studying the C# language, which is used by the 70-486 and 70-487 exams. As well, just by passing this one exam, you will earn the title Specialist: Programming in C# title. Here are the details (including the ability to swap the two exams, under Additional Options) for this MCSD title:
    http://www.microsoft.com/learning/en-us/mcsd-web-apps-certification.aspx

    I must warn you that the MCSA: SQL Server certification will require you to pass the 70-643 exam. It includes content on Microsoft Business Intelligence tools. Specifically, the 70-463 exam requires you to know SQL Server Integration Services (SSIS) and SQL Server Analysis Service (SSAS). Here are the details:
    http://www.microsoft.com/learning/en-us/exam-70-463.aspx

    Please know that the MCSA: SQL Server exams are based on SQL Server 2012 and will remain about SQL Server 2012. Only the four (MCSE) exams (two for each MCSE SQL Server title) are going to be updated to SQL Server 2014 in April 24th, 2014. Here are the details from Larry Kaye (Microsoft employee):
    http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

    Good luck!


    Best wishes, Davin Mickelson

    Tuesday, April 8, 2014 4:30 PM
    Answerer

All replies

  • Hi,

    like usual, it depends. It depends on your background (have you done any Windows Store or web development before?) and your main working area. In my opinion the MSCD Web Applications track has more data access topics in it where the MCSD Windows Store Apps mainly focuses on Windows Store App specific features.

    Additionally, when working as a database administrator you will have more likely contact to web developers instead of Windows Store App developers.


    Best Regards. When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. This helps us build a healthy and positive community.

    @Horizon_Net | Blog

    Tuesday, April 8, 2014 11:05 AM
    Answerer
  • Hi, MohamedDBA.

    I agree with Horizon_Net that the MCSD: Web Applications certification would be best for your certification goals. Especially since you are concerned with becoming certified in the future of database development technologies.

    Specifically, the 70-487 certification exam covers programming with WCF (for data access over the internet/intranet), Entity Framework (for data access anywhere), Web API (REST Services for data access over the internet/intranet), and Microsoft Azure (for hosting databases, applications, and much more in the cloud). Most likely, you will be managing SQL Server databases in the cloud in your future.

    I highly recommend that you swap 70-483 for 70-480, which will still count for the MCSD: Web Applications certification. The 70-483 C# programming exam will be really useful while studying the C# language, which is used by the 70-486 and 70-487 exams. As well, just by passing this one exam, you will earn the title Specialist: Programming in C# title. Here are the details (including the ability to swap the two exams, under Additional Options) for this MCSD title:
    http://www.microsoft.com/learning/en-us/mcsd-web-apps-certification.aspx

    I must warn you that the MCSA: SQL Server certification will require you to pass the 70-643 exam. It includes content on Microsoft Business Intelligence tools. Specifically, the 70-463 exam requires you to know SQL Server Integration Services (SSIS) and SQL Server Analysis Service (SSAS). Here are the details:
    http://www.microsoft.com/learning/en-us/exam-70-463.aspx

    Please know that the MCSA: SQL Server exams are based on SQL Server 2012 and will remain about SQL Server 2012. Only the four (MCSE) exams (two for each MCSE SQL Server title) are going to be updated to SQL Server 2014 in April 24th, 2014. Here are the details from Larry Kaye (Microsoft employee):
    http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

    Good luck!


    Best wishes, Davin Mickelson

    Tuesday, April 8, 2014 4:30 PM
    Answerer