The Pearson VUE Certified IT Specialist Databases Prep course equips learners with essential database design and management skills needed to pass the certification exam and excel in database-related roles. Learn to design tables, choose appropriate data types and keys, establish relationships, and normalize databases for efficiency. Understand data protection measures to ensure the integrity and security of information.

Gain practical experience using SQL Data Definition Language (DDL) and Data Manipulation Language (DML) to create, modify, and manage tables, views, stored procedures, and functions. Learn how to retrieve, sort, filter, and aggregate data effectively. The course also emphasizes troubleshooting techniques for resolving common issues in query execution, making it ideal for aspiring database administrators, analysts, and IT professionals preparing for the Pearson VUE IT Specialist Databases certification.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M1821

Topic 1 Database Design

• Given a scenario, design tables for storing data

• Given a scenario, identify the appropriate primary key

• Given a scenario, choose data types to meet the requirements

• Given a scenario, design relationships between tables

• Normalize a database

• Given a scenario, identify data protection measures

Topic 2 Database Object Management using DDL

• Construct and analyze queries that create, alter, and drop tables

• Construct and analyze queries that create, alter, and drop views

• Construct and analyze stored procedures and functions

• Given a scenario, choose between clustered and non-clustered indexes

Topic 3 Data Retrieval

• Construct and analyze queries that select data

• Construct and analyze queries that sort and filter data

• Construct and analyze queries that aggregate data

Topic 4 Data Manipulation using DML

• Construct and analyze INSERT statements

• Construct and analyze UPDATE statements

• Construct and analyze DELETE statements

Topic 5 Troubleshooting

• Troubleshoot data object management query failures

• Troubleshoot data retrieval query failures

• Troubleshoot data manipulation query failures