Microsoft Corporation

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

Credential: Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014  In-Demand resource  GI Bill resource
Credentialing Agency: Microsoft Corporation

Renewal Period: Lifetime

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 credentials demonstrates an individual's skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. Earning an MCSA: SQL Server certification qualifies an individual for a position as a software as a database developer or database analyst. Candidates should possess foundational IT skills and have a minimum of two years of experience to sit for the three required exams.

More information can be found on the certifying agency's website.

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

MINIMUM REQUIREMENTS

 

Eligibility Requirements (View Details)

  • Credential Prerequisite
  • Experience: 2 years
  • Education
  • Training
  • Membership
  • Other
  • Fee

Note: This credential may have multiple options for becoming eligible. Listed are the minimum requirements based on the minimum degree required. To view other options, see the Eligibility tab.

Exam Requirements (View Details)

  • Exam
  • Written Exam
  • Oral Exam
  • Practical Exam
  • Performance Assessment

RECERTIFICATION SUMMARY

Renewal Period: Lifetime

  • Continuing Education
  • Exam
  • Continuing Education OR Exam
  • Fee
  • Other

AGENCY CONTACT INFORMATION

Microsoft Corporation

One Microsoft Way
Redmond, WA  98052-6399

Phone: (800) 636-7544

Contact Page

Experience REQUIREMENTS

Candidates should have two or more years of experience as a SQL database administrator, system engineer, or developer.

Show Written Exam Requirements / Hide Written Exam Requirements

  • Create database objects (20-25%)
    • Create and alter tables using T-SQL syntax (simple statements)
    • Create and alter views (simple statements)
    • Design views
    • Create and modify constraints (simple statements)
    • Create and alter DML triggers
  • Work with data (25-30%)
    • Query data by using SELECT statements
    • Implement sub-queries
    • Implement data types
    • Implement aggregate queries
    • Query and manage XML data
  • Modify data (20-25%)
    • Create and alter stored procedures (simple statements)
    • Modify data by using INSERT, UPDATE, and DELETE statements
    • Combine datasets
    • Work with functions
  • Troubleshoot and optimize (25-30%)
    • Optimize queries
    • Manage transactions
    • Evaluate the use of row-based operations vs. set-based operations
    • Implement error handling

  • Install and configure (20-25%)
    • Plan installation
    • Install SQL Server and related services
    • Implement a migration strategy
    • Configure additional SQL Server components
    • Manage SQL Server Agent
  • Maintain instances and databases (15-20%)
    • Manage and configure databases
    • Configure SQL Server instances
    • Implement a SQL Server clustered instance
    • Manage SQL Server instances
  • Optimize and troubleshoot (15-20%)
    • Identify and resolve concurrency problems
    • Collect and analyze troubleshooting data
    • Audit SQL Server instances
  • Manage data (20-25%)
    • Configure and maintain a back-up strategy
    • Restore databases
    • Implement and maintain indexes
    • Import and export data
  • Implement security (15-20%)
    • Manage logins and server roles
    • Manage database security
    • Manage users and database roles
    • Troubleshoot security
  • Implement high availability (5-10%)
    • Implement AlwaysOn
    • Implement replication

  • Design and implement a data warehouse (10-15%)
    • Design and implement dimensions
    • Design and implement fact tables
  • Extract and transform data (20-25%)
    • Define connection managers
    • Design data flow
    • Implement data flow
    • Manage SSIS package execution
    • Implement script tasks in SSIS
  • Load data (25-30%)
    • Design control flow
    • Implement package logic by using SSIS variables and parameters
    • Implement control flow
    • Implement data load options
    • Implement script components in SSIS
  • Configure and deploy SSIS solutions (20-25%)
    • Troubleshoot data integration issues
    • Install and maintain SSIS components
    • Implement auditing, logging, and event handling
    • Deploy SSIS solutions
    • Configure SSIS security settings
  • Build data quality solutions (15-20%)
    • Install and maintain data quality services
    • Implement master data management solutions
    • Create a data quality project to clean data

Testing Information

Testing for this credential is handled by Pearson VUE. The test centers are located in the U.S. They also have some test centers on military bases.

To find out more, use the following links on the Pearson VUE website:

For more information on the Microsoft Corporation testing process, visit the agency website.

RECERTIFICATION

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

Renewal Period: Lifetime

The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 credential has the following recertification information:

  • This certification has no recertification requirements and cannot be renewed.  Once Microsoft determines that a certification no longer reflects the latest technology or is no longer relevant in the marketplace, it will be retired and will eventually transition to a Legacy status for certification holders. For the most current certification status, refer to the Retired certifications page.

In Demand

This certification is considered in demand

COOL Bucks

See your installation Education Service Officer for credential exam information and coordinating instructions.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

Some

Credential is related to some tasks associated with the duties of the military occupation (at least one critical task but less than 80%)

Most

Credential is directly related to most of the major duties associated with the military occupation (at least 80%)

Other

Credential is related to this military occupation, but is more advanced or specialized and therefore will likely require additional education, training, or experience

Promotion Points

This certification has been approved for promotion points.

Click for more information.

Star

Star credentials are MOS enhancing, as designated by the Proponent. MOS enhancing credentials are directly related to an MOS or ASI, are taught either partially or completely as part of a Program of Instruction (POI), and improves the MOS technical proficiency.

Skill Level

The Skill Level reflects the level, based on MOS training and/or experience, the Soldier should be the most prepared to successfully earn the credential. See the Table Legend for details about each level.

Proponent Funded

Indicates the credential may have funding through the MOS proponent. Some proponents offer credentialing opportunities in conjunction with military training and/or as part of MOS development beyond the training base.

Click for more information.

Navy Bucks

Credential voucher or reimbursement for credential exam, re-certification, or maintenance fee has been approved for payment through the Navy's Credential Program Office. To get a voucher request form, click 'Complete Voucher and Apply' at the top of any page.

CG Bucks

Coming Soon - Coast Guard policy regarding service member eligibility requirements to participate in the Voluntary Credentialing Program is under review with a projected release date of first quarter FY20.

Early Career

1-3 years experience; Enlisted E1 through E4

Mid Career

4-10 years experience; Enlisted E5 through E6

Late Career

10+ years experience; Enlisted E7 and Above

Early Career

1-3 years experience; Enlisted “A” School through E5

Mid Career

4-10 years experience; Enlisted E6 through E7

Late Career

10+ years experience; Enlisted E8 and Above

LaDR

This credential is recommended on the rating Learning and Development Roadmap (LaDR) for Sailors currently in the pay grade indicated on the icon, BUT MAY BE TAKEN BY SAILORS IN OTHER PAY GRADES.

Click for more information.

GI Bill®

Reimbursement for exam fees has been approved for payment through the GI Bill. Click for external link to GI Bill licensing and certification information.

Note: GI Bill approval data is updated quarterly. For the latest information, visit the WEAMS Licenses/Certifications Search page. Make sure to select "Both" in the LAC Category Type drop-down before searching.

Click here for more information.

ANSI

This credential has been accredited by ANSI. Click for external link to the ANSI web site.

Click here for more information.

ICAC

This credential has been accredited by ICAC. Click for external link to the ICAC web site.

Click here for more information.

ABSNC

This credential has been accredited by ABSNC. Click for external link to the ABSNC web site.

Click here for more information.

NCCA

This credentialing program has been accredited by NCCA. Click for external link to the NCCA web site.

Click here for more information.

IAS

This credential has been accredited by IAS. Click for external link to the IAS web site.

Click here for more information.

Low

May be difficult to attain: minimum education requirement is a Bachelor's degree, and/or minimum experience is 10 or more years.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

Medium

Moderate ease of attainment: minimum education requirement = Associate's and/or prerequisite and/or minimum experience = more than 2 years and less than 10 years of experience.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

High

Highly attainable: mimum education requirement = HS or less and/or minimum experience = 2 years or less experience and no additional requirements.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

MOS is Military Occupational Specialty
ASI is Additional Skill Identifier
WOMOS is Warrant Officer Military Occupational Specialty

Army e-learning

State-of-the art Computer Based Training available for free to the Army Workforce. Click for more information.

Click here for more information.

NKO e-learning

Credential preparation courses are provided at no cost through Navy e-Learning. Click for external link to the Navy Knowledge Online (NKO) web site, then select the “Navy e-Learning” link within the “Learning” tab to proceed to Navy e-Learning.

Bright Outlook – new job opportunities are very likely in the future for this job
Registered Apprenticeship
Click here for External link to: My Next Move for Veterans - Computer and Information Systems Managers
Click here for External link to: My Next Move salary info for Computer and Information Systems Managers
Click here for External link to: My Next Move for Veterans - Computer Network Architects
Click here for External link to: My Next Move salary info for Computer Network Architects
Click here for External link to: My Next Move for Veterans - Computer Network Support Specialists
Click here for External link to: My Next Move salary info for Computer Network Support Specialists
Click here for External link to: My Next Move for Veterans - Computer Programmers
Click here for External link to: My Next Move salary info for Computer Programmers
Click here for External link to: My Next Move for Veterans - Computer Systems Analysts
Click here for External link to: My Next Move salary info for Computer Systems Analysts
Click here for External link to: My Next Move for Veterans - Computer Systems Engineers/Architects
Click here for External link to: My Next Move salary info for Computer Systems Engineers/Architects
Click here for External link to: My Next Move for Veterans - Computer User Support Specialists
Click here for External link to: My Next Move salary info for Computer User Support Specialists
Click here for External link to: My Next Move for Veterans - Database Administrators
Click here for External link to: My Next Move salary info for Database Administrators
Click here for External link to: My Next Move for Veterans - Database Architects
Click here for External link to: My Next Move salary info for Database Architects
Click here for External link to: My Next Move for Veterans - Information Security Analysts
Click here for External link to: My Next Move salary info for Information Security Analysts
Click here for External link to: My Next Move for Veterans - Information Technology Project Managers
Click here for External link to: My Next Move salary info for Information Technology Project Managers
Click here for External link to: My Next Move for Veterans - Network and Computer Systems Administrators
Click here for External link to: My Next Move salary info for Network and Computer Systems Administrators
Click here for External link to: My Next Move for Veterans - Software Developers, Applications
Click here for External link to: My Next Move salary info for Software Developers, Applications
Click here for External link to: My Next Move for Veterans - Software Developers, Systems Software
Click here for External link to: My Next Move salary info for Software Developers, Systems Software
Click here for External link to: My Next Move for Veterans - Software Quality Assurance Engineers and Testers
Click here for External link to: My Next Move salary info for Software Quality Assurance Engineers and Testers
This is an official U.S. Navy website
Updated: October 16, 2019
Top