Lesson 1: Understanding Database Types and Structures

• Identify Relational and Non-Relational Databases
• Understand Different Types of NoSQL Databases and Tools
• Understand Relational Database Design
• Identify Other Data Systems

Lesson 2: Recognizing Standards and Commands

• Understand Standards and Principles
• Examine Operating Systems and Command Line Scripting

Lesson 3: Running Scripts for Data and Data Systems

• Create and Alter Objects Using Data Definition Language
• Manipulate Data Using Data Manipulation Language
• Work with Transactions
• Perform Data Management Tasks

Lesson 4: Explaining the Impact of Programming on Database Operations

• Work with Views
• Understand Object Relational Mapping
• Program with SQL
• Write Functions

Lesson 5: Understanding Database Planning and Design

• Understand Types of Architecture
• Gather Data System Requirements
• Review Documentation Requirements

Lesson 6: Implementing, Testing, and Deploying Databases

• Prepare for Deployment
• Conduct Testing and Other Quality Measures
• Understand Validation Techniques and Methods

Lesson 7: Monitoring and Reporting on Database Performance

• Consider Database Connectivity Needs
• Monitor the Database
• Understand and Address Deadlocks

Lesson 8: Understanding Common Data Maintenance Processes

• Explain Patch Management
• Ensure Database Performance
• Ensure Database Integrity

Lesson 9: Understanding Governance and Regulatory Compliance

• Understand the Importance of Protecting Data and Preventing Data Loss
• Understand Data Retention Policies
• Classify Data
• Consider Global Jurisdiction and Regional Regulations
• Understand Third-Party Agreements and Release Approvals

Lesson 10: Securing Data

• Understand Data Encryption
• Understand Data Masking
• Describe Data Destruction Techniques
• Audit Data Access
• Audit Code and Changes

Lesson 11: Securing Data Access

• Understand Identity and Access Management
• Understand Access Controls
• Understand Password Policies
• Work with Service Accounts

Lesson 12: Securing the Database and Server

• Utilize Physical Security
• Utilize Logical Security

Lesson 13: Classifying Types of Attacks

• Mitigate the SQL Injection Attack
• Mitigate the Denial of Service (DoS) Attack
• Mitigate the On-Path Attack
• Mitigate the Brute Force Attack
• Mitigate Social Engineering Attacks
• Mitigate Malware

Lesson 14: Planning for Disaster Recovery

• Plan for Disaster Recovery
• Conduct DR Plan Testing
• Transition/Failback to Normal Operations

Lesson 15: Implementing Backup and Restore Best Practices

• Identify Types of Backups
• Implement a Backup Strategy
• Store and Purge Backups