Introduction
CompTIA DataSys+ is a foundational level data management certification that focuses on the logistics of data administration and security. It proves your competency to build, support and secure growing data systems.
DataSys+ is the only vendor-neutral Database Certification Option which allows you to develop and validate data administrator skills regardless of vendor tools. DataSys+ defines and confirms a consistent skill set appropriate for certified database administrators. This an ever-growing need, the constant acquisition of big data demands qualified administrators to manage and secure those assets.
Audience profile
Database Administrator
Pre-requisites
CompTIA recommends 18–24 months of experience in a report/business analyst job role, exposure to databases and analytical tools, a basic understanding of statistics, and data visualization experience.
Course objectives
- Database Fundamentals
- Database Development
- Database Management and Maintenance
- Data and Database Security
- Business Continuity
After completing the CompTIA DataSys+ course, delegates will have the skills and knowledge to:
- Compare and contrast database structure types.
- Compare and contrast aspects of database planning and design.
- Given a scenario, implement data management tasks.
- Given a scenario develop, modify, and run SQL code.
- Compare and contrast scripting methods and scripting environments.
- Explain the impact of programming on database operations.
- Given a scenario, produce documentation and use relevant tools.
- Explain database implementation, testing, and deployment phases.
- Explain the purpose of monitoring and reporting for database management and performance.
- Explain common database maintenance processes.
- Explain the purpose of governance and regulatory compliance.
- Explain data security concepts.
- Given a scenario, implement policies and best practice related to authentication and authorization.
- Explain the purpose of database infrastructure security.
- Describe types of attacks and their effects on data systems.
- Explain the purpose of monitoring and reporting for database management and performance.
- Explain the importance of disaster recovery and relevant techniques.
- Explain backup and restore best practices and processes
Course content
| Lesson 1: Understanding Database Types and Structures |
- Identify Relational and Non-Relational Databases
|
- Understand several types of NoSQL Databases and Tools
|
- Understand Relational Database Design
|
- Identity Other Data Systems
|
| Lesson 2: Recognising Standards and Commands |
- Understanding Standards and Principles
|
- Examine Operating Systems and Command Line Scripting
|
| Lesson 3: Running Scripts for Data and Data Systems |
- Create and Alter Objects Using Data Definition Language
|
- Manipulate Data using Data Manipulation Language
|
|
|
- Perform Data Management Tasks
|
| Lesson 4: Explaining the Impact of Programming on Database Operations |
|
|
|
- Understand Object Relational Mapping
|
|
| Lesson 5: Understanding Database Planning and Design |
- Understand Types of Architecture
|
- Review Documentation Requirements
|
- Gather Data Systems Requirements
|
|
| Lesson 6: Implementing, Testing, and Deploying Databases |
|
|
- Understand Validation Techniques and Methods
|
- Conduct Testing and Other Quality Measures
|
|
| Lesson 7: Monitoring and Reporting on Database Performance |
- Consider Database Connectivity Needs
|
- Understand and Address Deadlocks
|
|
|
|
| Lesson 8: Understanding Common Data Maintenance Processes |
|
|
- Ensure Database Performance
|
- Ensure Database Integrity
|
|
| Lesson 9: Understanding Governance and Regulatory Compliance |
- Understand the importance of Protecting Data and Preventing Data Loss
|
- Understand Data Retention Policies
|
|
|
- Consider Global Jurisdiction and Regional Regulations
|
- Understand Third-Party Agreements and Release Approvals
|
|
| Lesson 10: Securing Data |
- Understand Data Encryption
|
|
- Describe Data Destruction Techniques
|
|
|
|
|
| Lesson 11: Securing Data Access |
- Understand Identity and Access Management
|
- Understand Access Controls
|
- Understand Password Policies
|
- Work with Service Accounts
|
| Lesson 12: Securing the Database and Server |
- Utilize Physical Security
|
|
| Lesson 13: Classifying Types of Attacks |
- Mitigate the SQL Injection Attack
|
- Mitigate the Denial of Service (DoS) Attack
|
- Mitigate the On-Path Attack
|
- Mitigate the Brute Force Attack
|
- Mitigate Social Engineering Attacks
|
|
| Lesson 14: Planning for Disaster Recovery |
- Plan for Disaster Recovery
|
|
- Transition/ Failback to Normal Operations
|
|
| Lesson 15: Implementing Backup and Restore Best Practices |
- Identify Types of Backups
|
- Implement a Backup Strategy
|
|
|
|
Associated certifications and exam
This course will prepare delegates to write the CompTIA DataSys+ (DS0-001) exam.
Successfully passing this exam counts as a credit to attaining the Official CompTIA DataSys+ certification.
The CompTIA DataSys+ exam 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.
| Exam Details |
CompTIA DataSys+ |
| Exam Title |
CompTIA DataSys+ |
| Number of Questions/Practical Challenges |
90 Questions |
| Recommended Experience |
No prerequisites, but 2-3 years of experience in a database administrator role is recommended. |
| Test Duration |
1 Hour 30 Minutes |
| Test Format |
Multiple choice questions and performance-based questions. |
| Test Delivery |
Pearson VUE
Testing Centres
Online Testing |
| Availability |
Pearson VUE |
| Exam Prefix |
DS0-001 |
| Passing Score |
700 (on a scale of 100-900) |
| Retirement |
Three years after date of launch. |
