COMP105
CompTIA DataSys+ Bootcamp
Description
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 systems, including employing the fundamentals of scripting and programming in a database environment while using security and business continuity best-practices.
Objectives
By the end of this course, participants will:
- Develop an 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.
- Compare and contrast the different aspects of database planning and design.
- Explain the various phases of the 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.
- Prepare for and recover from incidents by implementing best practices for backup and restoration of data.
Key Takeaways
- Vendor-neutral data management following ANSI/ISO processes
- Foundation for vendor-specific database certifications and advanced level data science certifications
Certificate of Completion
- Certificate of Completion issued after successful completion of all chapters, hands-on exercises, and course evaluation.
- Certificate is downloadable from the Ghost Team Academy Education Portal.
Training Outline
Day 1 – Database Fundamentals & Structure
- Topics:
- Course overview, certification roadmap, exam strategy
- Introduction to database systems: relational vs non-relational, key terms, ACID principles
- SQL basics: DDL, DML, TCL, introduction to NoSQL, and scripting methods
- Labs/Exercises: Explore and compare relational and non-relational database systems; write basic SQL statements, create tables, and perform queries
- Domain 1 review
Day 2 – Database Deployment & Design
- Topics:
- Gathering requirements, designing entity relationship diagrams (ERDs), and data dictionaries
- Planning schema, deployment phases, version control, connectivity testing
- Labs/Exercises: Design a database schema based on a scenario, implement and test it; install and configure a database engine (relational or NoSQL), and provision resources
- Domain 2 review
Day 3 – Management, Maintenance, & Performance
- Topics:
- Monitoring database performance: transaction logs, alerts, resource utilization
- Maintenance tasks: query optimization, indexing, patch management, capacity planning
- Labs/Exercises: Use monitoring tools to analyze performance, identify bottlenecks, tune queries; document maintenance tasks and create SOPs/data dictionaries
- Domain 3 review
Day 4 – Security, Compliance, & Governance
- Topics:
- Data security fundamentals: encryption (in-transit/at-rest), access controls, authentication/authorization
- Governance: data masking, retention policies, regulatory compliance (GDPR, PCI DSS, etc.)
- Labs/Exercises: Implement encryption and RBAC in a database; perform a security audit, simulate threats (SQL injection, DoS, brute-force) and apply mitigation controls
- Domain 4 review
Day 5 – Business Continuity, Troubleshooting, & Exam Prep
- Topics:
- Backup and recovery strategies: snapshots, replication, clustering, failover
- High availability architecture, disaster recovery planning, risk assessment
- Labs/Exercises: Simulate a backup and restore scenario; configure clustering/replication
- Full practice exam simulation covering all domains
- Exam‐taking strategies, review of key concepts, final Q&A
- Course wrap-up and next steps for certification
