Course Overview

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)
Objectives
During this course, students will 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.

Audience
Database Administrator

Prerequisites
No prerequisites, but 2-3 years of experience in a database administrator role is recommended.

Topics
Topics Covered
Lesson 1: Understanding Database Types and Structures
Lesson 2: Recognizing Standards and Commands
Lesson 3: Running Scripts for Data and Data Systems
Lesson 4: Explaining the Impact of Programming on Database Operations
Lesson 5: Understanding Database Planning and Design
Lesson 6: Implementing, Testing, and Deploying Databases
Lesson 7: Monitoring and Reporting on Database Performance
Lesson 8: Understanding Common Data Maintenance Processes
Lesson 9: Understanding Governance and Regulatory Compliance
Lesson 10: Securing Data
Lesson 11: Securing Data Access
Lesson 12: Securing the Database and Server
Lesson 13: Classifying Types of Attacks
Lesson 14: Planning for Disaster Recovery
Lesson 15: Implementing Backup and Restore Best Practices
Labs Available
Assisted 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
Assisted 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
Assisted Lab: Validating Data
Assisted Lab: Monitoring Databases
Applied Lab: Configuring and Monitoring Databases
Assisted Lab: Optimizing Queries
Assisted Lab: Ensuring Data Integrity with Constraints
Assisted 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
License Information
Once license provides access to CertMaster Learn for DataSys+ (DS0-001) with CertMaster Labs integrated throughout the course
Once activated, the license is valid for 12 months