CompTIA DataSys+ (UT-CompTIA DataSys+)

Course Description

This course can benefit you in two ways. If you intend to pass the CompTIA DataSys+ (Exam DS0-001) certification examination, this course can be a significant part of your preparation. But certification is not the only key to professional success in the field of database administration. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your database administration skill set so that you can confidently perform your duties in any DBA role.

Course Objectives

  1. Understand database types and structures.
  2. Recognize standards and commands.
  3. Run scripts for data and data systems.
  4. Explain the impact of programming on database operations.
  5. Understand database planning and design.
  6. Implement, test, and deploy databases.
  7. Monitor and report on database performance.
  8. Understand common data maintenance processes.
  9. Understand governance and regulatory compliance.
  10. Secure data.
  11. Secure data access.
  12. Secure the database and server.
  13. Classify types of attacks.
  14. Plan for disaster recovery.
  15. Implement backup and restore best practices.

Course Outline

Lesson 1: Understanding Database Types and Structures

  • Topic 1A: Identify Relational and Non-Relational Databases
  • Topic 1B: Understand Different Types of NoSQL Databases and Tools
  • Topic 1C: Understand Relational Database Design
  • Topic 1D: Identify Other Data Systems

Lesson 2: Recognizing Standards and Commands

  • Topic 2A: Understand Standards and Principles
  • Topic 2B: Examine Operating Systems and Command Line Scripting

Lesson 3: Running Scripts for Data and Data Systems

  • Topic 3A: Create and Alter Objects Using Data Definition Language
  • Topic 3B: Manipulate Data Using Data Manipulation Language
  • Topic 3C: Work with Transactions
  • Topic 3D: Perform Data Management Tasks

Lesson 4: Explaining the Impact of Programming on Database Operations

  • Topic 4A: Work with Views
  • Topic 4B: Understand Object Relational Mapping
  • Topic 4C: Program with SQL
  • Topic 4D: Write Functions

Lesson 5: Understanding Database Planning and Design

  • Topic 5A: Understand Types of Architecture
  • Topic 5B: Gather Data System Requirements
  • Topic 5C: Review Documentation Requirements

Lesson 6: Implementing, Testing, and Deploying Databases

  • Topic 6A: Prepare for Deployment
  • Topic 6B: Conduct Testing and Other Quality Measures
  • Topic 6C: Understand Validation Techniques and Methods

Lesson 7: Monitoring and Reporting on Database Performance

  • Topic 7A: Consider Database Connectivity Needs
  • Topic 7B: Monitor the Database
  • Topic 7C: Understand and Address Deadlocks

Lesson 8: Understanding Common Data Maintenance Processes

  • Topic 8A: Explain Patch Management
  • Topic 8B: Ensure Database Performance
  • Topic 8C: Ensure Database Integrity

Lesson 9: Understanding Governance and Regulatory Compliance

  • Topic 19A: Understand the Importance of Protecting Data and Preventing Data Loss
  • Topic 9B: Understand Data Retention Policies
  • Topic 9C: Classify Data
  • Topic 9D: Consider Global Jurisdiction and Regional Regulations
  • Topic 9E: Understand Third-Party Agreements and Release Approvals

Lesson 10: Securing Data

  • Topic 10A: Understand Data Encryption
  • Topic 10B: Understand Data Masking
  • Topic 10C: Describe Data Destruction Techniques
  • Topic 10D: Audit Data Access
  • Topic 10E: Audit Code and Changes

Lesson 11: Securing Data Access

  • Topic 11A: Understand Identity and Access Management
  • Topic 11B: Understand Access Controls
  • Topic 11C: Understand Password Policies
  • Topic 11D: Work with Service Accounts

Lesson 12: Securing the Database and Server

  • Topic 12A: Utilize Physical Security
  • Topic 12B: Utilize Logical Security

Lesson 13: Classifying Types of Attacks

  • Topic 13A: Mitigate the SQL Injection Attack
  • Topic 13B: Mitigate the Denial of Service (DoS) Attack
  • Topic 13C: Mitigate the On-Path Attack
  • Topic 13D: Mitigate the Brute Force Attack
  • Topic 13E: Mitigate Social Engineering Attacks
  • Topic 13F: Mitigate Malware

Lesson 14: Planning for Disaster Recovery

  • Topic 14A: Plan for Disaster Recovery
  • Topic 14B: Conduct DR Plan Testing
  • Topic 14C: Transition/Failback to Normal Operations

Lesson 15: Implementing Backup and Restore Best Practices

  • Topic 15A: Identify Types of Backups
  • Topic 15B: Implement a Backup Strategy
  • Topic 15C: Store and Purge Backups

Course Prerequisites

To ensure your success in this course, you should have two to three years of hands-on experience working as a database administrator.

Course Information

Length: 5 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16


Contact Us

Do you have more questions? We're delighted to assist you!


Who Should Attend

The Official CompTIA DataSys+ (Exam DS0-001) is the primary course you will need to take if your job responsibilities include managing, maintaining, and securing data in one or more data systems, with consideration for data storage, organization, presentation, utilization, and analysis from a technical perspective. You can take this course to prepare for the CompTIA DataSys+ (Exam DS0-001) certification examination.