Exam participants for Databases are seeking to prove introductory knowledge of how to design, create, and query relational databases, such as MySQL, Microsoft SQL Server, or Oracle.

Examinees should have at least 150 hours of instruction or hands-on experience with database design and object management, data retrieval and manipulation, and related troubleshooting. Examinees should be able to write ANSI SQL statements and troubleshoot syntax errors and runtime errors. The syntax in the exam is provided in ANSI SQL.

.

General Exam Objectives:

1. Database Design

1. Given a scenario, design tables for storing data

2. Given a scenario, identify the appropriate primary key

3. Given a scenario, choose data types to meet requirements

4. Given a scenario, design relationships between tables

5. Normalize a database

6. Given a scenario, identify data protection measures

2. Database Object Management using DDL

1. Construct and analyze queries that create, alter, and drop tables

2. Construct and analyze queries that create, alter, and drop views

3. Construct and analyze stored procedures and functions

4. Given a scenario, choose between clustered and non-clustered indexes

3. Data Retrieval

1. Construct and analyze queries that select data

2. Construct and analyze queries that sort and filter data

3. Construct and analyze queries that aggregate data

4. Data Manipulation using DML

1. Construct and analyze INSERT statements

2. Construct and analyze UPDATE statements

3. Construct and analyze DELETE statements

5. Troubleshooting

1. Troubleshoot data object management query failures

2. Troubleshoot data retrieval query failures

3. Troubleshoot data manipulation query failures

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to demonstrate that they can structure a webpage using HTML elements and create and apply styles using CSS.

They should also be able to analyze and write syntactically correct HTML and CSS, structure data using HTML elements, and create and apply styles using CSS.

Candidates are expected to have at least 150 hours of instruction or hands-on experience with HTML and CSS, be familiar with their features and capabilities, and understand how to write, debug, and maintain well-formed HTML and CSS code.

 

For this exam,  please expect  35-45  questions to complete within 50 minutes.

 

General Exam Objectives:

1. HTML Fundamentals

1. Construct markup that uses metadata elements

2. Construct well-formed page markup

2. CSS Fundamentals

1. Analyze and implement inline styles, internal (embedded) style sheets, and external style sheets

2. Construct and analyze rule sets

3. Document Structure using HTML

1. Construct and analyze markup to structure content and organize data

2. Construct and analyze markup that uses HTML5 semantic elements

3. Construct and analyze markup that implements navigation

4. Construct and analyze markup that uses form elements

4. Multimedia Presentation using HTML

1. Construct and analyze markup that displays images

2. Construct and analyze markup that plays video and audio

5. Webpage Styling using CSS

1. Construct and analyze styles that position content

2. Construct and analyze styles that format text

3. Construct and analyze styles that format backgrounds and borders

4. Construct and analyze styles that create a simple responsive layout

6. Accessibility, Readability, and Testing

1. Construct well-formed HTML and CSS markup that conforms to industry best practices

2. Apply accessibility principles and evaluate content accessibility

3. Evaluate the structural integrity of HTML and CSS markup

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to demonstrate that they can structure a webpage using HTML elements and create and apply styles using CSS.

Examinees will also be required demonstrate their ability to use HTML5, CSS, and JavaScript to build responsive web applications that will run on a variety of touch-enabled devices, including PCs, tablets, and phones.

This exam focuses on using HTML5, CSS3, and JavaScript ES6 to develop client applications. Examinees should have at least 150 hours of instruction or hands-on experience withHTML5, CSS3, and JavaScript ES6 and be familiar with the foundational concepts of those technologies.

 

For this test, please expect  33-44 questions to complete within 50 minutes

 

General Exam Objectives:

1. Application Lifecycle Management

1. Describe the application lifecycle management stages

2. Debug and test web apps

2. Graphics and Animation

1. Use the canvas element to create graphics and animations

2. Use the svg element to create and display graphics

3. Advantages, inline vs. referenced XML, shapes, color, SVG filter effects

4. Transform, style, and enhance text and graphics

5. Apply CSS filters to images

3. Forms

1. Construct and analyze markup that uses form elements

2. Configure input validation

4. Layouts

1. Manage content layout, positioning, and flow by using CSS

2. Construct layouts by using responsive design

3. Construct flexible responsive layouts by using CSS flexbox

4. Construct grid-based layouts by using CSS grid

5. JavaScript Coding

1. Create and use custom classes

2. Perform data access by using JavaScript

3. Construct code that responds to events by using event listeners and handlers

4. Construct code that uses JavaScript APIs

5. Manage the state of an application

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to demonstrate that they can recognize, write, and debug Java code that will logically solve a problem.

Examinees should be application developers working with Java 6 SE or later, secondary and immediate-post-secondary students of software development, or entry-level software developers. Examinees should have at least 150 hours of instruction or hands-on experience with Java,be familiar with its features and capabilities, and understand how to write, debug and  maintain well-formed, well-documented Java code.

 

For this test, please expect  35-45 questions to complete within 50 minutes.

​

General Exam Objectives:

1. Java Fundamentals

1. Describe the use of main in a Java application

2. Perform basic input and output using standard packages

3. Evaluate the scope of a variable

4. Comment and document programs

2. Data Types, Variables, and Expressions

1. Declare and use primitive data type variables

2. Construct and evaluate code that manipulates strings

3. Construct and evaluate code that creates, iterates, and manipulates arrays and array lists

4. traversing the list

5. Construct and evaluate code that performs parsing, casting, and conversion

6. Construct and evaluate arithmetic expressions

3. Flow Control Implementation

1. Construct and evaluate code that uses branching statements

2. Construct and evaluate code that uses loops

4. Object-Oriented Programming

1. Construct and evaluate class definitions

2. Declare, implement, and access data members in classes

3. Declare, implement, and access methods

4. Instantiate and use class objects in programs

5. Code Compilation and Debugging

1. Troubleshoot syntax errors, logic errors, and runtime errors

2. Implement exception handling

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to demonstrate that they can recognize, write, and debug JavaScript code that will logically solve a problem. Examinees should also be able to recognize and write syntactically correct JavaScript code that will logically solve a given problem and use data types supported by JavaScript.

​

For this exam, please expect  35-45 questions to complete within 50 minutes.

​

General Exam Objectives:

1. JavaScript Operators, Methods, and Keywords

1. Complete and debug code that uses assignment and arithmetic operators

2. Apply JavaScript best practices

3. Evaluate the use of internal and external scripts

4. Implement exception handling

5. Complete and debug code that interacts with the Browser Object Model (BOM)

2. Variables, Data Types, and Functions

1. Declare and use variables of primitive data types

2. Declare and use arrays

3. Complete and debug code that uses objects

4. Complete and debug code that uses built-in Math functions

5. 5 Complete and debug functions that accept parameters and return values

3. Decisions and Loops

1. Evaluate expressions that use logical and comparison operators

2. Complete and debug decision statements

3. Complete and debug loops

4. Document Object Model

1. Identify and construct the Document Object Model (DOM) tree

2. Identify and handle document, form, keyboard, and mouse events

3. Complete and debug code that outputs to an HTML document

4. Complete and debug code that locates, modifies, and adds HTML elements and attributes to documents

5. Create events using event handlers and listeners

5. HTML Forms

1. Complete and debug code that retrieves form input and sets form

2. Complete and debug code that performs input validation

3. Describe the form submission process

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to recognize and write syntactically correct well-documented Python 3 code that will logically solve a given problem, correctly use data types supported by Python, and use common libraries to write a program that solves a complex problem.

Examinees are expected to have had at least 150 hours of instruction and/or hands-on experience with the Python programming language, be familiar with its features and capa-bilities, and understand how to write, debug, and maintain well-formed, well-documented Python code.

 

For this exam, please expect  33-43 questions to complete within 50 minutes.

​

General Exam Objectives:

1. Operations using Data Types and Operators

1. Evaluate expressions to identify the data types Python assigns to variables

2. Perform and analyze data and data type operations

3. Determine the sequence of execution based on operator precedence

4. Select operators to achieve the intended results

2. Flow Control with Decisions and Loops

1. Construct and analyze code segments that use branching statements

2. Construct and analyze code segments that perform iteration

3. Input and Output Operations

1. Construct and analyze code segments that perform file input and output operations

2. Construct and analyze code segments that perform console input and output operations

4.Code Documentation and Structure

1. Document code segments

2. Construct and analyze code segments that include function definitions

5. Troubleshooting and Error Handling

1. Analyze, detect, and fix code segments that have errors

2. Analyze and construct code segments that handle exceptions

3. Perform unit testing

6. Operations using Modules and Tools

1. Perform basic file system and command-line operations by using built-in modules

2. Solve complex computing problems by using built-in modules

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Examinees will be required to demonstrate core software development skills, including object-oriented programming, web applications, and databases. Candidates are For this test, please expect ed to have some experience with C# and ANSI SQL.

Candidates should have at least 150 hours of instruction or hands-on experience with concepts related to programming, software development, object-oriented programming, web applications, and databases .To be successful on the test, the candidate is also expected to have the following prerequisite knowledge and skills:

• HTML

• CSS

• JavaScript

• At least one object-oriented language (C#, Java, C++)

• SQL queries, XML, JSON

 

For this exam, please expect  35-40 questions to complete within 50 minutes.

 

General Exam Objectives:

1. Core Programming Concepts

1. Describe computer storage and data types

2. Construct and analyze algorithms and flowcharts to solve programming problems

3. Incorporate error handling into applications or modules

4. Construct and analyze code based on functional programming patterns

2. Software Development Principles

1. Describe software development lifecycle (SDLC) management

2. Construct and analyze code that uses algorithms and data structures

3. Describe the purpose of version control systems

4. Describe secure coding concepts

3. Object-Oriented Programming

1. Construct, analyze, and use classes

2. Construct and analyze code that uses inheritance

3. Construct and analyze code that uses polymorphism

4. Web Applications

1. Construct and analyze web applications

2. Describe and configure web hosting

3. Describe and configure web services

4. Describe and identify architectural patterns

5. Databases

1. Design and normalize a database

2. Construct, analyze, and optimize ANSI SQL queries

3. Manage transactions

4. Describe database access methods

5. Describe types of NoSQL databases

​​

Specific Exam Objectives: Certiport - Marketing Resource Library

Full Stack certifications can be grouped into pathways to validate highly demanded technical skills sought after by employers. With a broad range of technical certifications, pathways will open the door to opportunities in the technical industry and throughout the IT field.  Pathways include:

​

Application Developer

• Required exams include: HTML and CSS, JavaScript, Software Development, HTML5 Application Development

​​

Assistant IT Project Manager 

• Required exams include: Software Development, Project Management Ready and Professional Communication (see Career Skills)

​

Web Development Freelancer

• Required exams include: HTML and CSS, JavaScript, Photoshop and Entrepreneurships and Small Business (see Career Skills and Adobe)

​

App Development Freelancer 

• Required exams include: HTML5 Application Development, App Development with Swift, ,Entrepreneurships and Small Business (see Career Skills and IT/Web pages)

​

​