Career Details

Provisioning SQL Databases

Description

This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Certifying Organization

Microsoft Corporation

Details

If significant education or training is needed? Yes

If significant work experience is needed? Yes

Is an exam required? Yes

How many years until certification must be renewed? Unknown year(s)

Certification can be renewed with Continuing Education Units? Unknown

Certification can be renewed with re-examination? Unknown

Certification can be renewed with Continuing Professional Development? Unknown

Certification can be renewed in multiple ways? Unknown

Certificates

Certificate name

Cloud Services Design

Certifying Organization

Dell Corporation

Type

A - Core

Certificate name

Teradata 12 Certified Enterprise Architect

Certifying Organization

Teradata

Type

D - Product/Equipment

Certificate name

IBM Certified Solutions Expert - Red Brick Warehouse V6 System Administrator

Certifying Organization

IBM Corporation

Type

D - Product/Equipment

Related Careers

Data Scientists

Median Annual Income

$105,473

Projected Job Growth

+36 %

Career Cluster(s)

Marketing & Sales

Most Common Education Level

Bachelor's degree

Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software. Apply data mining, data modeling, natural language processing, and machine learning to extract and analyze information from large structured and unstructured datasets. Visualize, interpret, and report data findings. May create dynamic data reports.

InvestigativeConventional

Computer Systems Engineers/Architects

Median Annual Income

$112,753

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Design and develop solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions.

InvestigativeConventionalRealistic

Blockchain Engineers

Median Annual Income

$112,753

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Maintain and support distributed and decentralized blockchain-based networks or block-chain applications such as cryptocurrency exchange, payment processing, document sharing, and digital voting. Design and deploy secure block-chain design patterns and solutions over geographically distributed networks using advanced technologies. May assist with infrastructure setup and testing for application transparency and security.

ConventionalInvestigative

Information Security Engineers

Median Annual Income

$112,753

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Develop and oversee the implementation of information security procedures and policies. Build, maintain and upgrade security technology, such as firewalls, for the safe use of computer networks and the transmission and retrieval of information. Design and implement appropriate security controls to identify vulnerabilities and protect digital files and electronic infrastructures. Monitor and respond to computer security breaches, viruses, and intrusions, and perform forensic investigation. May oversee the assessment of information security systems.

ConventionalInvestigativeRealistic

Software Quality Assurance Analysts and Testers

Median Annual Income

$105,976

Projected Job Growth

+12 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Develop and execute software tests to identify software problems and their causes. Test system modifications to prepare for implementation. Document software and application defects using a bug tracking system and report defects to software or web developers. Create and maintain databases of known defects. May participate in software design reviews to provide input on functional requirements, operational characteristics, product designs, and schedules.

InvestigativeConventionalRealistic

Data Warehousing Specialists

Median Annual Income

$133,872

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

ConventionalInvestigative

Database Administrators

Median Annual Income

$107,664

Projected Job Growth

+8 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. Identify, investigate, and resolve database performance issues, database capacity, and database scalability. May plan, coordinate, and implement security measures to safeguard computer databases.

ConventionalInvestigative

Software Developers

Median Annual Income

$124,170

Projected Job Growth

+18 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Research, design, and develop computer and network software or specialized utility programs. Analyze user needs and develop software solutions, applying principles and techniques of computer science, engineering, and mathematical analysis. Update software or enhance existing software capabilities. May work with computer hardware engineers to integrate hardware and software systems, and develop specifications and performance requirements. May maintain databases within an application area, working individually or coordinating database development as part of a team.

InvestigativeConventionalRealistic

Computer Systems Analysts

Median Annual Income

$103,044

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Analyze science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions, improve existing computer systems, and review computer system capabilities, workflow, and schedule limitations. May analyze or recommend commercially available software.

InvestigativeConventional

Network and Computer Systems Administrators

Median Annual Income

$102,217

Projected Job Growth

-3 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Install, configure, and maintain an organization's local area network (LAN), wide area network (WAN), data communications network, operating systems, and physical and virtual servers. Perform system monitoring and verify the integrity and availability of hardware, network, and server resources and systems. Review system and application logs and verify completion of scheduled jobs, including system backups. Analyze network and server resource consumption and control user access. Install and upgrade software and maintain software licenses. May assist in network modeling, analysis, planning, and coordination between network and data communications hardware and software.

ConventionalRealisticInvestigative

Database Architects

Median Annual Income

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.

ConventionalInvestigative

Data Warehousing Specialists

Median Annual Income

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

ConventionalInvestigative

Network and Computer Systems Administrators

Median Annual Income

Projected Job Growth

-3 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

ConventionalRealisticInvestigative

Computer Systems Engineers/Architects

Median Annual Income

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Design and develop solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions.

InvestigativeConventionalRealistic

Your One Stop Shop For All Career Resources

Whether you are exploring new career paths, building your resume, or preparing for your next opportunity, our tools, templates, and guidance are designed to help you navigate your career journey with clarity and confidence.