Professional Database Administration Program
Structured curriculum covering relational theory, query optimization, backup strategies, and security implementation for production environments.
What the curriculum includes
The program consists of 6 sequential modules. Each module builds on the previous one, introducing new concepts after foundational knowledge has been established.
Relational Model Fundamentals
Normalization forms, entity-relationship modeling, and referential integrity constraints. Students work with sample datasets to identify anomalies and apply normalization rules.
Query Processing and Indexing
How database engines parse and execute queries. Index types, execution plans, and performance analysis using EXPLAIN statements on real workloads.
Transaction Management
ACID properties, isolation levels, and deadlock scenarios. Exercises involve simulating concurrent transactions and analyzing lock behavior under different isolation settings.
Backup and Recovery
Full, differential, and incremental backup strategies. Point-in-time recovery procedures and testing restoration processes in controlled failure scenarios.
Security and Access Control
Authentication mechanisms, role-based permissions, and audit logging. Students configure security policies and track access patterns in sample environments.
Replication and High Availability
Master-slave topologies, failover mechanisms, and data consistency in distributed systems. Lab exercises involve setting up replication and testing failover procedures.
Who teaches this program
Ivar Lindström
Lead Instructor
Reza Abbasi
Systems Specialist
Callum Tierney
Security Consultant
Program statistics from 2020 to present
Program enrollment and duration
The full program runs for 16 weeks with 8 hours of instruction per week. Classes are held twice weekly in evening sessions to accommodate working professionals.
Students receive access to a dedicated lab environment with pre-configured database instances for all exercises. All required software is provided through the learning platform.
Enrollment includes access to recorded lectures, exercise solutions, and a private discussion forum where instructors answer questions within 24 hours on business days.