Course Overview
CompTIA DataSys+ is a foundational-level data management certification that focuses on the logistics of data administration and security.
Develop and validate data administrator skills regardless of vendor tools.
DataSys+ defines and confirms a consistent skill set appropriate for certified database administrators (DBAs).
Exam Details:
Maximum of 90 questions
Multiple choice and performance-based
90 Minutes
Passing Score: 700 (on a scale of 100 to 900)
What you’ll learn
Database Fundamentals
Understand database structure types while developing, modifying, and running structured query language (SQL) code, providing the groundwork to gather, store, and drive data assets on any operating system.
Database Deployment
Compare and contrast the different aspects of database design and planning, and explain the various phases of the implementation, testing, deployment, and optimization of collected data.
Database Management and Maintenance
Learn 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.
Requirements
- No prerequisites, but 2-3 years of experience in a database administrator role is recommended.
Target audiences
- Database Administrator
Curriculum
- 2 Sections
- 19 Lessons
- 51 Weeks
- Topics Covered15
- 1.1Lesson 1: Understanding Database Types and Structures
- 1.2Lesson 2: Recognizing Standards and Commands
- 1.3Lesson 3: Running Scripts for Data and Data Systems
- 1.4Lesson 4: Explaining the Impact of Programming on Database Operations
- 1.5Lesson 5: Understanding Database Planning and Design
- 1.6Lesson 6: Implementing, Testing, and Deploying Databases
- 1.7Lesson 7: Monitoring and Reporting on Database Performance
- 1.8Lesson 8: Understanding Common Data Maintenance Processes
- 1.9Lesson 9: Understanding Governance and Regulatory Compliance
- 1.10Lesson 10: Securing Data
- 1.11Lesson 11: Securing Data Access
- 1.12Lesson 12: Securing the Database and Server
- 1.13Lesson 13: Classifying Types of Attacks
- 1.14Lesson 14: Planning for Disaster Recovery
- 1.15Lesson 15: Implementing Backup and Restore Best Practices
- Labs Available4
- 2.1Assisted Lab: Exploring the Lab Environment Assisted Lab: Exploring a Database Environment Assisted Lab: Using Command Prompt and PowerShell Assisted Lab: Using Data Definition Language (DDL) Assisted Lab: Using Data Manipulation Language (DML) Assisted Lab: Using Transaction Control Language (TCL) Applied Lab: Creating and Manipulating Databases and Data
- 2.2Assisted Lab: Using Stored Procedures and Triggers Assisted Lab: Using GROUP BY to Group and Aggregate Data Assisted Lab: Creating Views with Functions Applied Lab: Creating Views and Building Functions Assisted Lab: Diagramming Databases Assisted Lab: Installing and Configuring Database Connectivity
- 2.3Assisted Lab: Validating Data Assisted Lab: Monitoring Databases Applied Lab: Configuring and Monitoring Databases Assisted Lab: Optimizing Queries Assisted Lab: Ensuring Data Integrity with Constraints
- 2.4Assisted Lab: Masking Data Using Pseudonymization and Anonymization Assisted Lab: Using Queries to Conduct Security Audits Assisted Lab: Using Queries for Code Review and Code Auditing Assisted Lab: Implementing Role-Based Access Assisted Lab: Reducing Privileges for Users Assisted Lab: Rewriting Queries to Prevent SQL Injection Assisted Lab: Backing Up and Restoring Databases with Backup Validation Applied Lab: Creating Roles and Establishing a Backup Plan
