We're offering 20% off September Live Online classes! See which courses are applicable.   |   Details

AccountIcon BigDataIcon BlogIcon default_resource_icon CartIcon checkmark_icon cloud_devops_icon computer_network_admin_icon cyber_security_icon gsa_schedule_icon human_resources_icon location_icon phone_icon plus_icon programming_software_icon project_management_icon redhat_linux_icon search_icon sonography_icon sql_database_icon webinar_icon

Search UMBC Training Centers

Data Science

CompTIA DataSys+

Group Training + View more dates & times


CompTIA DataSys+ provides a comprehensive set of resources for learning and skills validation to ensure that data management professionals have the skills needed to do the job securely, accurately and efficiently. It covers what database administrators need to deploy, manage and maintain systems, including employing the fundamentals of scripting and programming in a database environment while using security and business continuity best practices.

Covered skills include:

  • Designing and modeling databases to meet a specific organizational need
  • Executing database tasks, including processing and structuring data files, running routines, etc.
  • Installing, configuring and maintaining database software and tools for optimal performance
  • Establishing and maintaining sound security, backup and recovery policies and procedures
  • Working with key stakeholders to translate data into actionable intelligence

Although CompTIA DataSys+ is designed for those with 2-3 years of experience in a database administrator role, other professionals, such as IT support specialists, software developers, network administrators, and database developer, are well-positioned to pursue a successful career as database administrators.

Who Should Take This Course

AUDIENCE & Prerequisites

CompTIA DataSys+ is designed for those with 2-3 years of experience in a database administrator role. Other professionals, such as IT support specialists, software developers, network administrators, and database developer, are well-positioned to pursue a successful career as database administrators.

Why You Should Take This Course

CompTIA DataSys+ is vendor-neutral, so the skills acquired are applicable regardless of the system that the organization is using. For this reason, the skills are also transferable should the organization migrate to a different technology or should the individual move on to a position at another organization.

The demand for capable database administrators is growing. Skilled database administrators are needed to oversee, maintain and protect the increasing quantity of data available to their organizations. As needs evolve and grow, CompTIA DataSys+ learning provides a uniform solution to develop talent from within.

Many people may call themselves database administrators or claim that they have the requisite capabilities, but organizations seeking to hire database administrators can rely on CompTIA DataSys+ certification to validate the skills of candidates.

Upon completing this course, students will be skilled at:

  • Understanding database design and structure, including planning, implementation, testing and deployment
  • Comparing and contrasting scripting methods and developing, modifying and running SQL code
  • Explaining the impact of programming on database operations
  • Monitoring and maintaining the data, reporting on and documenting any incidents
  • Implementing critical data management tasks
  • Securing the data by limiting access and defending against attacks
  • Understanding and meeting regulation and governance requirements
  • Creating and saving back-ups, and preparing for restoration/disaster recovery
Course Outline

Course Outline DataSys+ (DS0-001)


Lesson 1: Understanding Database Types and Structures

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


Lesson 2: Recognizing Standards and Commands

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


Lesson 3: Running Scripts for Data and Data Systems

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


Lesson 4: Explaining the Impact of Programming on Database Operations

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


Lesson 5: Understanding Database Planning and Design

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


Lesson 6: Implementing, Testing, and Deploying Databases

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


Lesson 7: Monitoring and Reporting on Database Performance

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


Lesson 8: Understanding Common Data Maintenance Processes

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


Lesson 9: Understanding Governance and Regulatory Compliance

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


Lesson 10: Securing Data

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


Lesson 11: Securing Data Access

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


Lesson 12: Securing the Database and Server

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


Lesson 13: Classifying Types of Attacks

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


Lesson 14: Planning for Disaster Recovery

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


Lesson 15: Implementing Backup and Restore Best Practices

  • Topic A: Identify Types of Backups
  • Topic B: Implement a Backup Strategy
  • Topic C: Store and Purge Backups
Is there a discount available for current students?

UMBC students and alumni, as well as students who have previously taken a public training course with UMBC Training Centers are eligible for a 10% discount, capped at $250. Please provide a copy of your UMBC student ID or an unofficial transcript or the name of the UMBC Training Centers course you have completed. Asynchronous courses are excluded from this offer.

What is the cancellation and refund policy?

Student will receive a refund of paid registration fees only if UMBC Training Centers receives a notice of cancellation at least 10 business days prior to the class start date for classes or the exam date for exams.

Contact Us