JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
CertPREP Courseware: IT Specialist Databases - Self-Paced

CertPREP Courseware: IT Specialist Databases - Self-Paced

Be the first to review this product

The CertPREP IT Specialist Databases course offers a self-paced learning experience for individuals aiming to master the fundamentals of database design, querying, and management. Learners start with programming concepts and progress through object-oriented programming, SDLC principles, and secure coding practices—laying a strong foundation for database-centric development.

With in-depth coverage of relational and NoSQL databases, students learn how to normalize databases, write optimized ANSI SQL queries, manage transactions, and understand access methods. The course also integrates modern web application principles, hosting, and architectural patterns, making it ideal for future software developers, data analysts, and database administrators seeking a comprehensive entry-level certification.

Description

This self-paced CertPREP IT Specialist Databases course serves 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
how to create, update and delete records and tables
how to filter and aggregate data
how to automate certain procedures

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

Course components:

Lessons
MeasureUp Practice Test for IT Specialist Databases. Practice Mode with remediation and Certification mode to simulate the test day experience.
Labs

Duration: Approximately 36 hours of primary course content. Each learner will progress at their own rate.

Audience:

Designed for any learner 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

Required course materials: Self-paced CertPREP IT Specialist Databases Courseware.

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

Course Code: E025

Fee

$200.00 (GST-exclusive)

$218.00 (GST-inclusive)

Post-Course Support

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Course Cancellation/Reschedule Policy

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commerce.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom

Course Details

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

Lesson 3: Data Retrieval

Skill 3.1: Construct and analyze queries that select data
Skill 3.2: Construct and analyze queries that sort and filter data
Skill 3.3: Construct and analyze queries that aggregate data

Lesson 4: Data Manipulation using DML

Skill 4.1: Construct and analyze INSERT statements
Skill 4.2: Construct and analyze UPDATE statements
Skill 4.3: Construct and analyze DELETE statements

Lesson 5: Troubleshooting

Skill 5.1: Troubleshoot data object management query failures
Skill 5.2: Troubleshoot data retrieval query failures
Skill 5.3: Troubleshoot data manipulation query failures

Job Roles

Database Support Technician
Junior Database Developer
SQL Analyst
Data Entry and Reporting Assistant
NoSQL Support Assistant
Application Support Technician
Junior Web Developer
Software Development Intern
QA/Data Tester
Entry-Level Data Engineer
IT Operations Support (Data Focus)
Technical Documentation Assistant
Junior Business Intelligence Analyst
Systems Analyst Trainee
Database Design Assistant
Web Application Tester
Version Control Coordinator
Entry-Level Programmer
Functional Programming Intern
IT Specialist (Databases Track)

Write Your Own Review

You're reviewing: CertPREP Courseware: IT Specialist Databases - Self-Paced

How do you rate this product? *

	1 star	2 stars	3 stars	4 stars	5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

*Nickname
*Summary of Your Review
*Review
*Please type the letters below

You May Be Interested In These Courses

WSQ - SQL Fundamental for Beginners

236 Review(s)

$350.00 (GST-exclusive)

$381.50 (GST-inclusive)

WSQ - Vibe Coding a Full Stack NoSQL Web Apps

4 Review(s)

$350.00 (GST-exclusive)

$381.50 (GST-inclusive)

WSQ - Mastering Notion for Content, Project, and Database Management

$800.00 (GST-exclusive)

$872.00 (GST-inclusive)

WSQ - Neo4j Professional Graph Database Course

14 Review(s)

$800.00 (GST-exclusive)

$872.00 (GST-inclusive)

WSQ - Administering Microsoft Azure SQL Solutions (DP-300)

$2,000.00 (GST-exclusive)

$2,180.00 (GST-inclusive)

About Us

Tertiary Infotech Academy, established in 2012, is a leading skills-based training provider dedicated to supporting Singapore’s Industry 4.0 transformation. We are a registered Private Education Institute (PEI), offering Diploma and Advanced Certificate programs in Cyber Security and Artificial Intelligence.

As a strong advocate for professional and lifelong learning, we are a WSQ and IBF Approved Training Organisation (ATO). We also serve as an Authorized Training Partner for major global technology and certification bodies, including Microsoft, CompTIA, AWS, Pearson VUE, Autodesk, Linux Foundation.

In addition, our academy is both a Pearson VUE, Kryterion, PSI Authorized Test Centers enabling learners to access industry-recognized examinations in a convenient and professional environment.

Training Grants and Subsidies

WSQ: Company and Singaporeans/PR can apply WSQ 70-90% funding depending on eligibility
SkillsFuture Enterprise Credit (SFEC) - Eligible Singapore-registered companies can tap on $10000 SFEC to cover up to 90% of out-of-pocket expense
SkillsFuture Credit: All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses.
IBF-STS Companies and Singaporeans/PR can apply IBF-STS 70-90% funding depending on eligibility
UTAP: NTUC members enjoy 50% subsidy for unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP
PSEA: Individual can pay using using their Post Secondary Education Account

Authorised Training Partners

Microsoft Learning Partner

CompTIA Authorised Delivery Partner

Linux Foundations Authorised Training Partner

AWS Authorised Training Partner (Reseller)

Autodesk Authorised Training Center

Pearson Vue Authorised Training Partner

Authorized Testing Centers

Pearson VUE Authorised Test Center

Kryterion Authorized Testing Center

PSI Authorized Testing Center

Approved Training Organizations

WSQ Approved Training Organization

Institute of Banking & Finance (IBF) Approved Training Provider

Singapore Chartered Accountant (SAC) Accredited Training Organisation

Approved Private Educational Insitutes (PEI)

Approved Suppliers

GeBiz Registered Supplier

Regional Training Centers

Singapore (Headquarter)

Malaysia Kuala Lumpur and Penang

Contact Us Information

+65 6100 0613

https://wa.me/6588666375

AI Chatbot

Tertiary Courses SG GPT

enquiry@tertiaryinfotech.com

Training Centers venue :
12 Woodlands Square, #07-85/86/87, Woods Square Tower 1, Singapore 737715 (Disabled-Friendly) .

Mailing address:
12 Woodlands Square, #07-86, Woods Square Tower 1, Singapore 737715

CertPREP Courseware: IT Specialist Databases - Self-Paced

Description

Course components:

Audience:

Course objectives: