Pick a Course Date

CompTIA DataSys+ (Including Exam)

The CompTIA DataSys+ offers a comprehensive e-learning programme which allows you to study at your own pace.
The content provides the foundational skills and knowledge to grow, manage, maintain and secure data systems. CompTIA DataSys+ is a vendor neutral certification, which means you will learn transferable skills that are not tied to a specific system or set of hardware.

9th September - 10th March 2025

Online

12 Spaces Left

£699

Add to cart

CompTIA DataSys+ (Including Exam)

The CompTIA DataSys+ sets a unified standard of skills for the successful management and securing of data assets. It covers what database administrators need to deploy, manage, and maintain high-availability systems, including employing the fundamentals of scripting and programming in a relational database environment while using security and business continuity best-practices.

Delivery Method: Self Study via E-Learning Platform

Learning Hours: Approximately 37.5 hours

Prerequisites:
No prerequisites, but 2-3 years of experience in a database administrator role is recommended.

Course Content Summary

Database Fundamentals

Understand database structure types while developing, modifying and running structured query language (SQL) code, providing the groundwork to gather, store, and drive data assets on any operating system.

Database Deployment

Compare and contrast the different aspects of database design and planning and explain the various phases of the implementation, testing, deployment and optimisation of collected data.

Database Management and Maintenance

Learn the purpose of monitoring and reporting database performance, explain common database maintenance processes, and produce critical documentation.

Data and Database Security

Secure databases, protect against attacks, and control authorisation while ensuring governance and regulatory compliance.

Business Continuity

Prepare for and recover from incidents by implementing best practices for disaster recovery, backup and restoration of database management systems.

E-Learning Syllabus

Topics Covered

Lesson 1: Understanding Database Types and Structures

Lesson 2: Recognising Standards and Commands

Lesson 3: Running Scripts for Data and Data Systems

Lesson 4: Explaining the Impact of Programming on Database Operations

Lesson 5: Understanding Database Planning and Design

Lesson 6: Implementing, Testing, and Deploying Databases

Lesson 7: Monitoring and Reporting on Database Performance

Lesson 8: Understanding Common Data Maintenance Processes

Lesson 9: Understanding Governance and Regulatory Compliance

Lesson 10: Securing Data

Lesson 11: Securing Data Access

Lesson 12: Securing the Database and Server

Lesson 13: Classifying Types of Attacks

Lesson 14: Planning for Disaster Recovery

Lesson 15: Implementing Backup and Restore Best Practices

Labs Included

Assisted Lab: Exploring the Lab Environment

Assisted Lab: Exploring a Database Environment

Assisted Lab: Using Command Prompt and PowerShell

Assisted Lab: Using Data Definition Language (DDL)

Assisted Lab: Using Data Manipulation Language (DML)

Assisted Lab: Using Transaction Control Language (TCL)

APPLIED LAB: Creating and Manipulating Databases and Data

Assisted Lab: Using Stored Procedures and Triggers

Assisted Lab: Using GROUP BY to Group and Aggregate Data

Assisted Lab: Creating Views with Functions

APPLIED LAB: Creating Views and Building Functions

Assisted Lab: Diagramming Databases

Assisted Lab: Installing and Configuring Database Connectivity

Assisted Lab: Validating Data

Assisted Lab: Monitoring Databases

APPLIED LAB: Configuring and Monitoring Databases

Assisted Lab: Optimizing Queries

Assisted Lab: Ensuring Data Integrity with Constraints

Assisted Lab: Masking Data Using Pseudonymization and Anonymization

Assisted Lab: Using Queries to Conduct Security Audits

Assisted Lab: Using Queries for Code Review and Code Auditing

Assisted Lab: Implementing Role-Based Access

Assisted Lab: Reducing Privileges for Users

Assisted Lab: Rewriting Queries to Prevent SQL Injection

Assisted Lab: Backing Up and Restoring Databases with Backup Validation

APPLIED LAB: Creating Roles and Establishing a Backup Plan

Exam Details

Exam Voucher

You will receive an exam voucher to undertake the DataSys+ exam with Pearson Vue. The exam can be taken online or by registering to attend your nearest Pearson Vue testing centre (details available when booking with Pearson Vue)

CertMaster revision and test preparation

To prepare for your examination you will be provided access to the CompTia CertMaster platform which allows you to practice exam style questions and performance tasks and will provide insights into areas for review, revision and practice.

Exam

The exam is a combination of multiple choice and performance task based questions

A maximum of 90 questions to complete in 90 minutes

Pass mark is 700 out of a possible 900 marks