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  Army eLearning resource CA Eligible
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

Attainability:    high

Eligibility Requirements (View Details)

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

Note: This credential may have multiple options for a Service member to meet eligibility requirements. Requirements listed here are 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

Exam Administration (View Details)

  • In-person exam
  • Remote proctored on-line exam
  • Third-party test vendor

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.

  • 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

Exam Preparation Resources

There are a number of resources available to help you prepare for the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 examination:

An additional resource is O'Reilly Learning Safari Books Online, a searchable digital library that provides online access to thousands of books, training videos and conference sessions. See the Educational Resources section on the Related Sites page here on COOL to learn how to get free access.

Testing Information

  • Exam Administration

    Credential exams may be administered in-person at a testing site, proctored on-line remotely, or have options for both. If an exam is administered through a test vendor, the third-party test vendor box will be checked. The following test administration options apply to the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 credential where checked:

    • In-person exam
    • Remote proctored on-line exam
    • Third-party test vendor
  • 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. The U.S. Department of Labor sponsored CareerOneStop's analysis indicates the certification is frequently mentioned in online job postings.

Click for external link to CareerOneStop's Credentials Center.

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.

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

CA Eligible

This certification is eligible for CA.

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.

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 Menu at the top of any page, then click "2 Complete Voucher and Apply" under Credentialing Steps.

CG Bucks

Current Coast Guard policy states all credentials listed on CG COOL may be reimbursed assuming the enlisted service member meets the eligibility requirements as outlined in the Coast Guard Voluntary Credentialing Program Policy (COMDTINST 1540.1(series))

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 through E9

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 through E9

Early Career

1-6 years experience; Officer O1 through O2

Mid Career

6-12 years experience; Officer O3 through O5

Late Career

12+ years experience; Officer O6 and Above

GI Bill®

Reimbursement for exam fees has been approved for payment through the GI Bill.

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 to go to the external link for GI Bill licensing and certification information.

ANAB (ANSI)

This credential has been accredited by ANAB (ANSI).

Click to go to the external ANAB web site.

ICAC

This credential has been accredited by ICAC.

Click to go to the external ICAC web site.

ABSNC

This credential has been accredited by ABSNC.

Click to go to the external ABSNC web site.

NCCA

This credentialing program has been accredited by NCCA.

Click to go to the external NCCA web site.

IAS

This credential has been accredited by IAS.

Click to go to the external IAS web site.

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: minimum 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
AOC is Area Of Concentration Officer
Functional Area
Branch

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

$$ELEARN_NKO_DESC$$

Bright Outlook – new job opportunities are very likely in the future for this job

Registered Apprenticeship

An apprenticeship program is registered with the U.S. Department of Labor. Go to the Apprenticeship Finder and enter career path or location to find apprenticeship opportunities.

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

Bright Outlook – new job opportunities are very likely in the future for this job

Click here for external link to: My Next Move for Veterans State Map for Database Architects

This is an official U.S. Army website
Updated: January 07, 2021
Top