Information Technology

CompTIA DataSys+ (DS0—001)

Instructor-Led 15 Agenda

Description

This vendor-neutral course presents a unified standard of skills for the successful management and securing of data assets. It covers what database administrators need to deploy, manage, and maintain systems, as well as securing those systems and data assets. This course prepares you to take the DataSys+ (DS0-001) exam.

Course Overview

Course Objective

In this course you will:
Compare and contrast database structure types.
Compare and contrast aspects of database planning and design.
Given a scenario, implement data management tasks.
Given a scenario, develop, modify, and run SQL code.
Compare and contrast scripting methods and scripting environments.
Explain the impact of programming on database operations.
Explain database implementation, testing, and deployment phases.
Given a scenario, produce documentation and use relevant tools.
Explain the purpose of monitoring and reporting for database management and performance.
Compare and contrast scripting methods and scripting environments.
Explain common database maintenance processes.
Explain the purpose of governance and regulatory compliance.
Explain data security concepts.
Given a scenario, implement policies and best practices related to authentication and authorization.
Explain the purpose of database infrastructure security.
Describe types of attacks and their effects on data systems.
Explain the importance of disaster recovery and relevant techniques.
Explain backup and restore best practices and processes.

Who Should Attend

This course is intended for Database Administrators or those with a similar role. As well, those interested in working with data and ensuring its accuracy and security would be well-suited for this course:
Database administrator/DBA (and all related titles such as System DBA, Application DBA, Cloud DBA, Task-oriented DBA, SQL DBA, etc.)
Database coordinator
Database manager
Database designer
Database tester/modeler
Performance analyst
Database programmer

Understanding Database Types and Structures Lesson Id 1

Understanding Database Types and Structures

Recognizing Standards and Commands Lesson Id 2

Recognizing Standards and Commands

Running Scripts for Data and Data System Lesson Id 3

Running Scripts for Data and Data System

Explaining the Impact of Programming on Database Operations Lesson Id 4

Explaining the Impact of Programming on Database Operations

Understanding Database Planning and Design Lesson Id 5

Understanding Database Planning and Design

Implementing, Testing, and Deploying Databases Lesson Id 6

Implementing, Testing, and Deploying Databases

Monitoring and Reporting on Database Performance Lesson Id 7

Monitoring and Reporting on Database Performance

Understanding Common Data Mainten Lesson Id 8

Understanding Common Data Mainten

Understanding Governance and Regulatory Compliance Lesson Id 9

Understanding Governance and Regulatory Compliance

Securing Data Lesson Id 10

Securing Data

Securing Data Access Lesson Id 11

Securing Data Access

Securing the Database and Server Lesson Id 12

Securing the Database and Server

Classifying Types of Attacks Lesson Id 13

Classifying Types of Attacks

Planning for Disaster Recovery Lesson Id 14

Planning for Disaster Recovery

Implementing Backup and Restore Best Practices Lesson Id 15

Implementing Backup and Restore Best Practices

Lesson Id	Title	Description
1	Understanding Database Types and Structures	Topic 1A: Identify Relational and Non-Relational Databases<br />Topic 1B: Understand Different Types of NoSQL Databases and Tools<br />Topic 1C: Understand Relational Database Design<br />Topic 1D: Identify Other Data Systems
2	Recognizing Standards and Commands	Topic 2A: Understand Standards and Principles<br />Topic 2B: Examine Operating Systems and Command Line Scripting
3	Running Scripts for Data and Data System	Topic 3A: Create and Alter Objects Using Data Definition Languages<br />Topic 3B: Manipulate Data using Data Manipulation Language<br />Topic 3C: Work with Transactions<br />Topic 3D: Perform Data Management Tasks
4	Explaining the Impact of Programming on Database Operations	Topic 4A: Work with Views<br />Topic 4B: Understand Object Relational Mapping<br />Topic 4C: Program with SQL<br />Topic 4D: Write Functions
5	Understanding Database Planning and Design	Topic 5A: Understand Types of Architecture<br />Topic 5B: Gather Data System Requirements<br />Topic 5C: Review Documentation Requirements
6	Implementing, Testing, and Deploying Databases	Topic 6A: Prepare for Deployment<br />Topic 6B: Conduct Testing and Other Quality Measures<br />Topic 6C: Understand Validation Techniques and Methods
7	Monitoring and Reporting on Database Performance	Topic 7A: Consider Database Connectivity Needs<br />Topic 7B: Monitor the Database<br />Topic 7C: Understand and Address Deadlocks
8	Understanding Common Data Mainten	Topic 8A: Explain Patch Managementance Processes<br />Topic 8B: Ensure Database Performance<br />Topic 8C: Ensure Database Integrity
9	Understanding Governance and Regulatory Compliance	Topic 9A: Understand the Importance of Protecting Data and Preventing Data Loss<br />Topic 9B: Understand Data Retention Policies<br />Topic 9C: Classify Data<br />Topic 9D: Consider Global Jurisdiction and Regional Regulations<br />Topic 9E: Understand Third-Party Agreements and Release Approvals
10	Securing Data	Topic 10A: Understand Data Encryption <br />Topic 10B: Understand Data Masking <br />Topic 10C : Describe Data Destruction Techniques <br />Topic 10D: Audit Data Access <br />Topic 10E: Audit Code and Changes
11	Securing Data Access	Topic 11A: Understand Identity and Access Management <br />Topic 11B: Understand Access Controls <br />Topic 11C: Understand Password Policies <br />Topic 11D: Work with Service Accounts
12	Securing the Database and Server	Topic 12A: Utilize Physical Security <br />Topic 12B: Utilize Logical Security
13	Classifying Types of Attacks	Topic 13A: Mitigate the SQL Injection Attack <br />Topic 13B: Mitigate the Denial of Service (DoS) Attack <br />Topic 13C: Mitigate the On-Path Attack <br />Topic 13D: Mitigate the Brute Force Attack <br />Topic 13E: Mitigate Social Engineering Attacks <br />Topic 13F: Mitigate Malware
14	Planning for Disaster Recovery	Topic 14A: Plan for Disaster Recovery <br />Topic 14B: Conduct DR Plan Testing <br />Topic 14C: Transition/Failback to Normal Operations
15	Implementing Backup and Restore Best Practices	Topic 15A: Identify Types of Backups <br />Topic 15B: Implement a Backup Strategy <br />Topic 15C: Store and Purge Backups