CompTIA DataSys+ (Preparation for Exam DS0-001)

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.
 

Database Administrator
 

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

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