Information Technology
CompTIA DataSys+ (DS0—001)
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.
5 Days
40 Hrs
15 Lessons
Course 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.
Agenda
- 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
- Topic 2A: Understand Standards and Principles
- Topic 2B: Examine Operating Systems and Command Line Scripting
- 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
- Topic 4A: Work with Views
- Topic 4B: Understand Object Relational Mapping
- Topic 4C: Program with SQL
- Topic 4D: Write Functions
- Topic 5A: Understand Types of Architecture
- Topic 5B: Gather Data System Requirements
- Topic 5C: Review Documentation Requirements
- Topic 6A: Prepare for Deployment
- Topic 6B: Conduct Testing and Other Quality Measures
- Topic 6C: Understand Validation Techniques and Methods
- Topic 7A: Consider Database Connectivity Needs
- Topic 7B: Monitor the Database
- Topic 7C: Understand and Address Deadlocks
- Topic 8A: Explain Patch Managementance Processes
- Topic 8B: Ensure Database Performance
- Topic 8C: Ensure Database Integrity
- 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
- 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
- Topic 11A: Understand Identity and Access Management
- Topic 11B: Understand Access Controls
- Topic 11C: Understand Password Policies
- Topic 11D: Work with Service Accounts
- Topic 12A: Utilize Physical Security
- Topic 12B: Utilize Logical Security
- 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
- Topic 14A: Plan for Disaster Recovery
- Topic 14B: Conduct DR Plan Testing
- Topic 14C: Transition/Failback to Normal Operations
- Topic 15A: Identify Types of Backups
- Topic 15B: Implement a Backup Strategy
- Topic 15C: Store and Purge Backups
FREE
Interested in course?
Course Type: Instructor Led