CompTIA® DataSys+

CompTIA DataSys+ course ensures learners have skills around:

• Database Fundamentals – a solid understanding of database structure types and the ability to develop, modify and run code provides the groundwork for database administrators to gather, store, and drive data assets;
• Database Deployment – compare and contrast the different aspects of database planning and design and explain the various phases of the implementation, testing, and deployment of collected data;
• Database Management and Maintenance – understand 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 authorization while ensuring governance and regulatory compliance.

• Database Administrator;
• Sr. Database Administrator;
• System Database Administrator;
• Task-Oriented Database Administrator;
• Application Database Administrator;
• Cloud Database Administrator;
• Specialist Database Administrator;
• Performance Database Administrator;
• Database Manager.

Understand database structure types and the ability to develop, modify and run code providing the groundwork for database administrators to gather, store, and drive data assets;

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

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

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

At least 2-3 years of experience in a database administrator role.

Training materials include access to CompTIA DataSys+ CertMaster training environment.

This course helps you prepare for the CompTIA DS0-001 exam. A voucher for the certification exam is included in the price of the course.

1. Database Fundamentals

•  Compare and contrast database structure types;
• 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.

2. Database Deployment

• Compare and contrast aspects of database planning and design;
• Explain database implementation, testing, and deployment phases.

3. Database Management and Maintenance

• Explain the purpose of monitoring and reporting for database management and performance;
• Explain common database maintenance processes;
• Given a scenario, produce documentation and use relevant tools;
• Given a scenario, implement data management tasks.

4. Data and Database Security

• Explain data security concepts;
• Explain the purpose of governance and regulatory compliance;
• Given a scenario, implement policies and best practices related to authentication and authorization;
• Explain the purpose of database infrastructure security;
• Describe types of attacks and their effects on data systems.

5. Business Continuity

• Explain the importance of disaster recovery and relevant techniques;
• Explain backup and restore best practices and processes.