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 et 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.
What Is CertMaster Learn?
CertMaster Learn is a self-paced, comprehensive online learning experience that helps you gain the knowledge and practical skills necessary to be successful on your CompTIA certification exam, and in your IT career.
Interactive and flexible, CertMaster Learn is the ideal first step in your training journey. Instructional lessons are combined with videos, practice questions, and performance-based questions to provide hours of content aligned with the CompTIA exam objectives. A Learning Plan helps you stay on track with your studies, while robust analytics bring awareness of your strengths and weaknesses.
What is included?
- Lessons cover all exam objectives with integrated videos
- Hundreds of practice questions test your knowledge
- Performance-based questions apply what you’ve learned in a scenario
- Flashcards ensure you know the terminology and acronyms required for the exam
- The Learning Plan keeps you on track with your studies
- One CompTIA CertMaster Learn for license for the purchased course – 1 year access
- One CompTIA CertMaster LABS for the purchased course – 1 year access
- One CompTIA Exam Voucher valid for – 1 year access
- One CompTIA CertMaster Practice licence is valid – 1 year access
How to Access CertMaster Learn?
An access key and instructions will be sent via email after your purchase is complete.
You may then login anytime at https://login.comptia.org/training-products
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 |
