Learning Objectives

• Identify and configure different database structure types
• Write, modify, and execute structured query language (SQL) code
• Collect, store, and manage data across operating systems
• Apply database security controls and manage user access
• Defend databases against common attack vectors
• Support governance requirements and regulatory compliance
• Evaluate and distinguish between database design approaches
• Describe the processes for implementation, testing, deployment, and optimization
• Develop a disaster recovery plan for database environments
• Apply database backup and restoration strategies
• Track and report on database performance metrics
• Carry out routine maintenance tasks and produce supporting documentation

Course Outline

Module 1: Core Database Concepts

Identify and work with different database structure types. Write, modify, and execute SQL code. Collect, store, and manage data across various operating systems.

Module 2: Database Security and Compliance

Apply security controls and manage database access. Defend against database attacks. Address governance requirements and maintain regulatory compliance.

Module 3: Database Deployment and Design

Evaluate and compare different database design approaches. Describe processes for implementation, testing, deployment, and performance optimization.

Module 4: Continuity and Recovery

Develop disaster recovery plans for database environments. Apply backup and restoration strategies to protect data.

Module 5: Ongoing Database Administration

Monitor database performance and produce reports. Conduct routine maintenance and generate operational documentation.