CompTIA DataSys+

• 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
• Compare and contrast aspects of database planning and design
• Explain database implementation, testing, and deployment phases
• 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
• Explain data security concepts
• Explain the purpose of governance and regulatory compliance
• Given a scenario, implement policies and best practices related to authentication and authorisation
• Explain the purpose of database infrastructure security
• Describe types of attacks and their effects on data systems
• Explain the importance of disaster recovery and relevant techniques

Explain backup and restore best practices and processes

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.