Only VEEAM Authorized Training Provider in Malaysia

Pearson VUE IT Specialist: Databases

Category:

Last Update:

October 7, 2025

Accredited by:

Course Description:

Databases serve as a foundation layer of many web and data applications, business reporting functions, and prediction algorithms. In this course, students will learn how to:

Design and optimize a database
Create, update, and delete records and tables
Filter and aggregate data
Automate certain procedures

Taken together, these skills will serve as an entry point into data-related careers in reporting, data engineering, and automation.

Course Objectives:
Upon successful completion of this course, students should be able to:

Translate business case into a normalized database design. • Create and maintain tables, views, and stored procedures that support business operations. • Create and maintain tables, views, and stored procedures that support reporting functions. • Optimize and troubleshoot queries.

Duration:

4 days of training

Target Audience:

Designed for high school-level students and learners interested in obtaining a working-level proficiency with databases. After completing this course, you will be able to perform the basic responsibilities of an entry-level professional in the IT field or take advanced database courses that will allow you to become a database administrator.

Prerequisites:

None

Training Content

Lesson 1: Database Design

Skill 1.1: Given a scenario, design tables for storing data.
Skill 1.2: Given a scenario, identify the appropriate primary key.
Skill 1.3: Given a scenario, choose data types to meet the requirements.
Skill 1.4: Given a scenario, design relationships between tables.
Skill 1.5: Normalize a database.
Skill 1.6: Given a scenario, identify data protection measures.

Lesson 2: Database Object Management using DDL

Skill 2.1: Construct and analyze queries that create, alter, and drop tables.
Skill 2.2: Construct and analyze queries that create, alter, and drop views.
Skill 2.3: Construct and analyze stored procedures and functions.
Skill 2.4: Given a scenario, choose between clustered and non-clustered indexes.