CompTIA® DataSys+
CompTIA Data Systems (DataSys+) training is suitable for anyone who has gained even a little experience in database administration. We provide an opportunity to gain new skills and knowledge for more effective database implementation, maintenance and planning to ensure the continuity of the organization’s operations.
As part of the training, there is an opportunity to fully prepare for the international certification exam.
Course target
Ensures skills:
- 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.
Audience
- 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.
At Course Completion you will be able to:
- 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.
Prerequisites
At least 2-3 years of experience in a database administrator role.
Training materials
Training materials include access to CompTIA DataSys+ CertMaster available on training environment.
Certification Exam
CompTIA DS0-001 certification exam. (The exam fee is already included in the course price).
Course outline
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.
If you want to get more information about this course, contact us by phone +371 67505091 or send us an e-mail at mrn@bda.lv.
