Course Outline
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 - Securing Data
- 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
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
Target 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