CYBER SECURITY

CT-DATASYS+ : CompTIA DataSys+

Course Duration

5 Days

Delivery

ILT

LinkButton

Overview

If you are a database professional wanting to land a database administrator role, a DBA who wants to validate their skill set or another type of IT pro seeking database management skills, you need CompTIA DataSys+. By earning this certification, you’ll prove to employers that you can identify database structure types; develop, modify and run code; and gather, store and drive data assets. You’ll also confirm your knowledge of:

The various aspects of database design and planning
The different phases of the implementation, testing and deployment of data
The purpose of monitoring and reporting database performance
Common database maintenance processes
The production of essential documentation
Best practices for backup and data restoration

CompTIA DataSys+ certified professionals demonstrate their ability to secure databases, protect against cyberattacks and control authorization. Moreover, they prove they can ensure governance and regulatory compliance.

LinkButton

Course Curriculum

Module 1: Understanding Database Types and Structures

Topic 1A: Identify Relational and Non Relational Databases

Exam objectives covered:
Compare and contrast database structure types.

Topic 1B: Understand Different Types of NoSQL Databases and Tools

Exam objectives covered:
Compare and contrast database structure types.

Topic 1C: Understand Relational Database Design

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.
4 Given a scenario, implement data management tasks.

Topic 1D: Identify Other Data Systems

Exam objectives covered:
Compare and contrast database structure types.

Module 2: Recognizing Standards and Commands

Topic 2A: Understand Standards and Principles

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code

Topic 2B: Examine Operating Systems and Command Line Scripting

Exam objectives covered:
3 Compare and contrast scripting methods and scripting environments.

Module 3: Running Scripts for Data and Data Systems

Topic 3A: Create and Alter Objects Using Data Definition Language

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks

Topic 3B: Manipulate Data using Data Manipulation Language

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks.

Topic 3C: Work with Transactions

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.

Topic 3D: Perform Data Management Tasks

Exam objectives covered:
4 Given a scenario, implement data management tasks.

Module 4: Explaining the Impact of Programming on Database Operations

Topic 4A: Work with Views

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks.

Topic 4B: Understand Object Relational Mapping

Exam objectives covered:
4 Explain the impact of programming on database operations.

Topic 4C: Program with SQL

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
2 Explain database implementation, testing, and deployment phases.

Topic 4D: Write Functions

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.

Module 5: Understanding Database Planning and Design

Topic 5A: Understand Types of Architecture

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.

Topic 5B: Gather Data System Requirements

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.

Topic 5C: Review Documentation Requirements

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.
3 Given a scenario, produce documentation and use relevant tools.

Module 6: Implementing, Testing, and Deploying Databases

Topic 6A: Prepare for Deployment

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
1 Explain the purpose of monitoring and reporting for database management and performance.

Topic 6B: Conduct Testing and Other Quality Measures

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.

Topic 6C: Understand Validation Techniques and Methods

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases

Module 7: Monitoring and Reporting on Database Performance

Topic 7A: Consider Database Connectivity Needs

Exam objectives covered:
3 Compare and contrast scripting methods and scripting environments.
2 Explain database implementation, testing, and deployment phases.

Topic 7B: Monitor the Database

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.

Topic 7C: Understand and Address Deadlocks

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.

Module 8: Understanding Common Data Maintenance Processes

Topic 8A: Explain Patch Management

Exam objectives covered:
2 Explain common database maintenance processes

Topic 8B: Ensure Database Performance

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
2 Explain common database maintenance processes

Topic 8C: Ensure Database Integrity

Exam objectives covered:

3.2 Explain common database maintenance processes

Module 9: Understanding Governance and Regulatory Compliance

Topic 9A: Understand the Importance of Protecting Data and Preventing Data Loss

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9B: Understand Data Retention Policies

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9C: Classify Data

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9D: Consider Global Jurisdiction and Regional Regulations

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9E: Understand Third-Party Agreements and Release Approvals

Exam objectives covered:
4 Given a scenario, implement data management tasks

Module 10: Securing Data

Topic 10A: Understand Data Encryption

Exam objectives covered:
1 Explain data security concepts.

Topic 10B: Understand Data Masking

Exam objectives covered:
1 Explain data security concepts

Topic 10C : Describe Data Destruction Techniques

Exam objectives covered:
1 Explain data security concepts.

Topic 10D: Audit Data Access

Exam objectives covered:
2 Explain common database maintenance processes.
1 Explain data security concepts.

Topic 10E: Audit Code and Changes

Exam objectives covered:
2 Explain common database maintenance processes.
1 Explain data security concepts.

Module 11: Securing Data Access

Topic 11A: Understand Identity and Access Management

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11B: Understand Access Controls

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11C: Understand Password Policies

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11D: Work with Service Accounts

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Module 12: Securing the Database and Server

Topic 12A: Utilize Physical Security

Exam objectives covered:
4 Explain the purpose of database infrastructure security

Topic 12B: Utilize Logical Security

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
4 Explain the purpose of database infrastructure security

Module 13: : Classifying Types of Attacks

Topic 13A: Mitigate the SQL Injection Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13B: Mitigate the Denial of Service (DoS) Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13C: Mitigate the On-Path Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13D: Mitigate the Brute Force Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13E: Mitigate Social Engineering Attacks

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13F: Mitigate Malware

Exam objectives covered:
5 Describe types of attacks and their effects on data systems

Module 14: Planning for Disaster Recovery

Topic 14A: Plan for Disaster Recovery

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.
1 Explain the importance of disaster recovery and relevant techniques.

Topic 14B: Conduct DR Plan Testing

Exam objectives covered:
1 Explain the importance of disaster recovery and relevant techniques.

Topic 14C: Transition/Failback to Normal Operations

Exam objectives covered:
1 Explain the importance of disaster recovery and relevant techniques.

Module 15: Implementing Backup and Restore Best Practices

Topic 15A: Identify Types of Backups

Exam objectives covered:
2 Explain backup and restore best practices and processes

Topic 15B: Implement a Backup Strategy

Exam objectives covered:
2 Explain backup and restore best practices and processes

Topic 15C: Store and Purge Backups

Exam objectives covered:
2 Explain backup and restore best practices and processes.

LinkButton

What You'll Learn

CompTIA DataSys+ covers the following skills:

Understanding database design and structure, including planning, implementation, testing and deployment
Comparing and contrasting scripting methods and developing, modifying and running SQL code
Explaining the impact of programming on database operations
Monitoring and maintaining the data, reporting on and documenting any incidents
Implementing critical data management tasks
Securing the data by limiting access and defending against attacks
Understanding and meeting regulation and governance requirements
Creating and saving back-ups, and preparing for restoration/disaster recovery

LinkButton

Who Should Attend

Database administrators
Database managers
Database designers
Data warehouse specialists
Data warehouse developers

LinkButton

Prerequisites

CompTIA recommend sthat you have 2-3 years of hands-on experience working as a database administrator or equivalent experience.

Although CompTIA DataSys+ is designed for those with 2-3 years of experience in a database administrator role, other professionals, such as IT support specialists, software developers, network administrators, and database developer, are well-positioned to pursue a successful career as database administrators.

LinkButton

Training Schedule

LinkButton

Exam & Certification

LinkButton

Learning Journey

LinkButton

Frequently Asked Questions

Frequently Asked Questions (FAQs)

Why get CompTIA certified?

CompTIA certifications are vendor-neutral, globally recognized credentials that validate your IT skills and knowledge.
They demonstrate your expertise in various IT areas, such as networking, security, and cloud computing, making you a valuable asset to any organization.
CompTIA certifications can open doors to new career opportunities, increase your earning potential, and provide a solid foundation for further specialization in the IT industry.
What to expect for the examination?

CompTIA certification exams are designed to assess your knowledge and skills in specific IT domains.
Exams typically consist of multiple-choice questions, performance-based questions (simulations), or a combination of both. The format and content of the exam will vary depending on the certification you choose.
Note: Certification requirements and policies may be updated by CompTIA from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is CompTIA certification valid for?

Most CompTIA certifications are valid for three years from the date of passing the exam. To maintain your certification, you will need to renew it before it expires.
There are several renewal options available, such as passing a higher-level exam, completing continuing education activities, or earning Continuing Education Units (CEUs).
Note: Certification requirements and policies may be updated by CompTIA from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 24 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

LinkButton

Browse All Courses

Overview Course Curriculum Training Schedule Exam & Certification FAQs

The various aspects of database design and planning
The different phases of the implementation, testing and deployment of data
The purpose of monitoring and reporting database performance
Common database maintenance processes
The production of essential documentation
Best practices for backup and data restoration

What You'll Learn

CompTIA DataSys+ covers the following skills:

Understanding database design and structure, including planning, implementation, testing and deployment
Comparing and contrasting scripting methods and developing, modifying and running SQL code
Explaining the impact of programming on database operations
Monitoring and maintaining the data, reporting on and documenting any incidents
Implementing critical data management tasks
Securing the data by limiting access and defending against attacks
Understanding and meeting regulation and governance requirements
Creating and saving back-ups, and preparing for restoration/disaster recovery

Who Should Attend

Database administrators
Database managers
Database designers
Data warehouse specialists
Data warehouse developers

Prerequisites

CompTIA recommend sthat you have 2-3 years of hands-on experience working as a database administrator or equivalent experience.

Learning Journey

Coming Soon...

Module 1: Understanding Database Types and Structures

Topic 1A: Identify Relational and Non Relational Databases

Exam objectives covered:
Compare and contrast database structure types.

Topic 1B: Understand Different Types of NoSQL Databases and Tools

Exam objectives covered:
Compare and contrast database structure types.

Topic 1C: Understand Relational Database Design

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.
4 Given a scenario, implement data management tasks.

Topic 1D: Identify Other Data Systems

Exam objectives covered:
Compare and contrast database structure types.

Module 2: Recognizing Standards and Commands

Topic 2A: Understand Standards and Principles

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code

Topic 2B: Examine Operating Systems and Command Line Scripting

Exam objectives covered:
3 Compare and contrast scripting methods and scripting environments.

Module 3: Running Scripts for Data and Data Systems

Topic 3A: Create and Alter Objects Using Data Definition Language

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks

Topic 3B: Manipulate Data using Data Manipulation Language

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks.

Topic 3C: Work with Transactions

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.

Topic 3D: Perform Data Management Tasks

Exam objectives covered:
4 Given a scenario, implement data management tasks.

Module 4: Explaining the Impact of Programming on Database Operations

Topic 4A: Work with Views

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
4 Given a scenario, implement data management tasks.

Topic 4B: Understand Object Relational Mapping

Exam objectives covered:
4 Explain the impact of programming on database operations.

Topic 4C: Program with SQL

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.
2 Explain database implementation, testing, and deployment phases.

Topic 4D: Write Functions

Exam objectives covered:
2 Given a scenario, develop, modify, and run SQL code.

Module 5: Understanding Database Planning and Design

Topic 5A: Understand Types of Architecture

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.

Topic 5B: Gather Data System Requirements

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.

Topic 5C: Review Documentation Requirements

Exam objectives covered:
1 Compare and contrast aspects of database planning and design.
3 Given a scenario, produce documentation and use relevant tools.

Module 6: Implementing, Testing, and Deploying Databases

Topic 6A: Prepare for Deployment

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
1 Explain the purpose of monitoring and reporting for database management and performance.

Topic 6B: Conduct Testing and Other Quality Measures

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.

Topic 6C: Understand Validation Techniques and Methods

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases

Module 7: Monitoring and Reporting on Database Performance

Topic 7A: Consider Database Connectivity Needs

Exam objectives covered:
3 Compare and contrast scripting methods and scripting environments.
2 Explain database implementation, testing, and deployment phases.

Topic 7B: Monitor the Database

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.

Topic 7C: Understand and Address Deadlocks

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.

Module 8: Understanding Common Data Maintenance Processes

Topic 8A: Explain Patch Management

Exam objectives covered:
2 Explain common database maintenance processes

Topic 8B: Ensure Database Performance

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
2 Explain common database maintenance processes

Topic 8C: Ensure Database Integrity

Exam objectives covered:

3.2 Explain common database maintenance processes

Module 9: Understanding Governance and Regulatory Compliance

Topic 9A: Understand the Importance of Protecting Data and Preventing Data Loss

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9B: Understand Data Retention Policies

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9C: Classify Data

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9D: Consider Global Jurisdiction and Regional Regulations

Exam objectives covered:
2 Explain the purpose of governance and regulatory compliance.

Topic 9E: Understand Third-Party Agreements and Release Approvals

Exam objectives covered:
4 Given a scenario, implement data management tasks

Module 10: Securing Data

Topic 10A: Understand Data Encryption

Exam objectives covered:
1 Explain data security concepts.

Topic 10B: Understand Data Masking

Exam objectives covered:
1 Explain data security concepts

Topic 10C : Describe Data Destruction Techniques

Exam objectives covered:
1 Explain data security concepts.

Topic 10D: Audit Data Access

Exam objectives covered:
2 Explain common database maintenance processes.
1 Explain data security concepts.

Topic 10E: Audit Code and Changes

Exam objectives covered:
2 Explain common database maintenance processes.
1 Explain data security concepts.

Module 11: Securing Data Access

Topic 11A: Understand Identity and Access Management

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11B: Understand Access Controls

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11C: Understand Password Policies

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Topic 11D: Work with Service Accounts

Exam objectives covered:
3 Given a scenario, implement policies and best practices related to authentication and authorization.

Module 12: Securing the Database and Server

Topic 12A: Utilize Physical Security

Exam objectives covered:
4 Explain the purpose of database infrastructure security

Topic 12B: Utilize Logical Security

Exam objectives covered:
2 Explain database implementation, testing, and deployment phases.
4 Explain the purpose of database infrastructure security

Module 13: : Classifying Types of Attacks

Topic 13A: Mitigate the SQL Injection Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13B: Mitigate the Denial of Service (DoS) Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13C: Mitigate the On-Path Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13D: Mitigate the Brute Force Attack

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13E: Mitigate Social Engineering Attacks

Exam objectives covered:
5 Describe types of attacks and their effects on data systems.

Topic 13F: Mitigate Malware

Exam objectives covered:
5 Describe types of attacks and their effects on data systems

Module 14: Planning for Disaster Recovery

Topic 14A: Plan for Disaster Recovery

Exam objectives covered:
1 Explain the purpose of monitoring and reporting for database management and performance.
1 Explain the importance of disaster recovery and relevant techniques.

Topic 14B: Conduct DR Plan Testing

Exam objectives covered:
1 Explain the importance of disaster recovery and relevant techniques.

Topic 14C: Transition/Failback to Normal Operations

Exam objectives covered:
1 Explain the importance of disaster recovery and relevant techniques.

Module 15: Implementing Backup and Restore Best Practices

Topic 15A: Identify Types of Backups

Exam objectives covered:
2 Explain backup and restore best practices and processes

Topic 15B: Implement a Backup Strategy

Exam objectives covered:
2 Explain backup and restore best practices and processes

Topic 15C: Store and Purge Backups

Exam objectives covered:
2 Explain backup and restore best practices and processes.

Frequently Asked Questions (FAQs)

Why get CompTIA certified?

CompTIA certifications are vendor-neutral, globally recognized credentials that validate your IT skills and knowledge.
They demonstrate your expertise in various IT areas, such as networking, security, and cloud computing, making you a valuable asset to any organization.
CompTIA certifications can open doors to new career opportunities, increase your earning potential, and provide a solid foundation for further specialization in the IT industry.
What to expect for the examination?

CompTIA certification exams are designed to assess your knowledge and skills in specific IT domains.
Exams typically consist of multiple-choice questions, performance-based questions (simulations), or a combination of both. The format and content of the exam will vary depending on the certification you choose.
Note: Certification requirements and policies may be updated by CompTIA from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is CompTIA certification valid for?

Most CompTIA certifications are valid for three years from the date of passing the exam. To maintain your certification, you will need to renew it before it expires.
There are several renewal options available, such as passing a higher-level exam, completing continuing education activities, or earning Continuing Education Units (CEUs).
Note: Certification requirements and policies may be updated by CompTIA from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 24 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.