CompTIA DataSys+ Certification Course

CompTIA DataSys+ 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 date 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.
Business Continuity - Prepare for and recover from incidents by implementing best practices for disaster recovery| backup and restoration of database management systems.
1. Understanding Database Types and Structures
Identify Relational and Non-Relational Databases
Understand Different Types of NoSQL Databases and Tools
Understand Relational Database Design
Identify Other Data Systems
2. Recognizing Standards and Commands
Understand Standards and Principles
Examine Operating Systems and Command Line Scripting
3. Running Scripts for Data and Data Systems
Create and Alter Objects Using Data Definition Language
Manipulate Data using Data Manipulation Language
Work with Transactions
4. Explaining the Impact of Programming on Database Operations
Work with Views
Understand Object Relational Mapping
Program with SQL
Write Functions
5. Understanding Database Planning and Design
Understand Types of Architecture
Gather Data System Requirements
Review Documentation Requirements
6. Implementing| Testing| and Deploying Databases
Prepare for Deployment
Conduct Testing and Other Quality Measures
Understand Validation Techniques and Methods
7. Monitoring and Reporting on Database Performance
Consider Database Connectivity Needs
Monitor the Database
Understand and Address Deadlocks
8. Understanding Common Data Maintenance Processes
Explain Patch Management
Ensure Database Performance
Ensure Database Integrity
9. Understanding Governance and Regulatory Compliance
Understand the importance of Protecting Data and Preventing Data Loss
Understand Data Retention Policies
Classify Data
Consider Global Jurisdiction and Regional Regulations
Understand Third-Party Agreements and Release Approvals
10. Securing Data
Understand Data Encryption
Understand Data Masking
Describe Data Destruction Techniques
Audit Data Access
Audit Code and Changes
11. Securing Data Access
Understand Identity and Access Management
Understand Access Controls
Understand Password Policies
Work with Service Accounts
12. Securing the Database and Server
Utilize Physical Security
Utilize Logical Security
13. Classifying Types of Attacks
Mitigate the SQL Injection Attack
Mitigate the Denial of Service (DoS) Attack
Mitigate the On-Path Attack
Mitigate Brute Force Attack
Mitigate Social Engineering Attacks
Mitigate Malware
14. Planning for Disaster Recovery
Plan for Disaster Recovery
Conduct DR Plan Testing
Transition/Failback to Normal Operations
15. Implementing Backup and Restore Best Practices
Identify Types of Backups
Implement a Backup Strategy
Store and Purge Backups