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. This course may earn a Credly badge.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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.

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

2

  • Recognizing Standards and Commands

  •  Topic 2A: Understand Standards and Principles

    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

    Topic 3B: Manipulate Data using Data Manipulation Language

    Topic 3C: Work with Transactions

    Topic 3D: Perform Data Management Tasks

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

5

  • Understanding Database Planning and Design

  • Topic 5A: Understand Types of Architecture

    Topic 5B: Gather Data System Requirements

    Topic 5C: Review Documentation Requirements

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

7

  • Monitoring and Reporting on Database Performance

  •  Topic 7A: Consider Database Connectivity Needs

    Topic 7B: Monitor the Database

    Topic 7C: Understand and Address Deadlocks

8

  • Understanding Common Data Mainten

  •  Topic 8A: Explain Patch Managementance Processes

    Topic 8B: Ensure Database Performance

    Topic 8C: Ensure Database Integrity

9

  • Understanding Governance and Regulatory Compliance

  •  Topic 9A: 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

10

  • 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

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 

12

  • Securing the Database and Server

  • Topic 12A: Utilize Physical Security

    Topic 12B: Utilize Logical Security

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 

14

  • Planning for Disaster Recovery

  • Topic 14A: Plan for Disaster Recovery

    Topic 14B: Conduct DR Plan Testing

    Topic 14C: Transition/Failback to Normal Operations

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

Audience

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

Language

English

Prerequisites

In addition to good technical skills or aptitude to learn technology, good target candidates should have strong analytical and problem-solving skills, attention to detail, and the ability to work collaboratively with other IT professionals. They should also be able to manage multiple tasks and prioritize effectively.

$2,475

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
27
Nov
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
05
Feb
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
29
Apr
Monday
8:00 AM PT -
4:00 PM PT
Available
Schedule select
22
Jul
Monday
9:00 AM ET -
5:00 PM ET
Available
Loading...