IT276 Database Administration
Database Administration notes
9 chapter notes, in syllabus order. Each starts with the key points.
Unit 1
DB Admin: Roles, DBMS Types, Data Models & ChallengesUnit 1 of Database Administration introduces the core concepts of database administration, including the role of a DBA, types of database management systems (DBMS), data models, and common challenges faced in database management. This note covers definitions, real-world applications, and comparisons to help students un11 min readUnit 2
DBMS Architecture & Installation: Layers, Components & SetupUnit 2 of Database Administration explores the internal architecture of DBMS (three-schema, two-layer, client-server models), core components (query processor, storage manager, DML/DDL compilers), and hands-on installation procedures for Oracle, MySQL, and PostgreSQL, including configuration files, user roles, and trou13 min readUnit 3
Storage Structures & Tablespaces: Files, Blocks, Extents & AllocationUnit 3 of Database Administration explores how databases physically store data—segment types (tablespaces, tables, indexes), storage structures (data blocks, extents, files), and allocation methods (PCTFREE, PCTUSED, storage parameters). Learn how Oracle, MySQL, and PostgreSQL organize data on disk, manage free space, 14 min readUnit 4
User Roles, Privileges, Authentication & Security in DBMSUnit 4 of Database Administration covers user management (roles, privileges, profiles), authentication methods (passwords, certificates, biometrics), authorization models (discretionary, mandatory, role-based), security threats (SQL injection, privilege escalation), and best practices for securing databases like encryp12 min readUnit 5
Backup & Recovery: Strategies, Techniques & Disaster HandlingUnit 5 of Database Administration covers backup strategies (full, incremental, differential), recovery models (full, bulk-logged, simple), point-in-time recovery, disaster recovery plans, and hands-on techniques like transaction log backups and restore operations with SQL examples.11 min readUnit 6
Performance Monitoring and Tuning · note coming
Unit 7
Query Optimization: Techniques, Execution Plans & Performance TuningUnit 7 of Database Administration explores how to analyze, rewrite, and optimize SQL queries to reduce execution time, minimize resource usage, and improve database performance—critical for large-scale systems like eSewa or Ncell.10 min readUnit 8
Replication & High Availability: Methods, Failover, and Cloud SyncUnit 8 of Database Administration explores how replication ensures data redundancy, how high availability (HA) keeps systems operational, and how cloud-based solutions like multi-region databases achieve fault tolerance. Learn synchronous vs. asynchronous replication, failover mechanisms, and real-world deployments by 12 min readUnit 9
Database Auditing: Techniques, Tools & ComplianceUnit 9 of Database Administration explores database auditing—its purpose, methods, tools, and regulatory compliance—covering audit trails, change tracking, and security monitoring to ensure data integrity and accountability.13 min readUnit 10
Cloud Databases: Models, Services, Security & MigrationUnit 10 of Database Administration explores cloud-based database architectures, deployment models (PaaS, SaaS, IaaS), security challenges, migration strategies, and real-world use cases like eSewa’s transaction logs and Daraz’s inventory databases. Covers cost optimization, compliance (GDPR, PCI-DSS), and hybrid cloud 15 min read