IT276 Database Administration
Database Administration notes
10 chapter notes, in syllabus order. Each starts with the key points.
Unit 1
DB Admin: Roles, DBMS Types, Challenges & CareerUnit 1 of Database Administration introduces the core concepts of database administration, including the role of a DBA, types of database management systems (DBMS), challenges faced in database administration, and the career prospects in this field. This note covers definitions, responsibilities, DBMS classifications, 15 min readUnit 2
DBMS Architecture & Installation: Layers, Components & SetupUnit 2 of Database Administration explores the internal structure of DBMS (three-schema architecture, layers, components), installation methods, and configuration steps for relational and NoSQL systems, with real-world examples from Nepalese banks and e-commerce platforms.11 min readUnit 3
Storage Structures & Tablespaces: Files, Segments, Extents, BlocksUnit 3 of Database Administration explores how databases physically store data—from files and tablespaces to segments, extents, and blocks—explaining their roles, relationships, and optimization techniques in Oracle, MySQL, and PostgreSQL.12 min readUnit 4
User Roles, Privileges, Authentication & Security in DBMSUnit 4 of Database Administration explores how to manage database users, assign permissions, enforce authentication, and secure data against unauthorized access or breaches, with real-world examples from Nepalese banks and apps.10 min readUnit 5
Backup & Recovery: Strategies, Techniques & Disaster HandlingUnit 5 of Database Administration explores backup strategies (full, incremental, differential), recovery techniques (point-in-time, crash recovery), disaster scenarios, and tools like RMAN and archived logs—essential for protecting data integrity in real-world systems like Ncell’s billing or eSewa’s transaction databas8 min readUnit 6
Performance Monitoring & Tuning: Metrics, Tools & OptimizationUnit 6 of Database Administration explores how to measure database performance using tools like AWR, SQL Trace, and OS statistics, then optimize queries, indexes, and system configurations to reduce latency, improve throughput, and ensure scalability—critical for real-world systems like eSewa’s transaction processing o15 min readUnit 7
Query Optimization: Techniques, Execution Plans, Indexing & Cost-Based AnalysisUnit 7 of Database Administration explores how to optimize SQL queries for speed, efficiency, and resource usage by analyzing execution plans, indexing strategies, query rewriting, and cost-based optimization. Learn practical techniques to reduce query response time and improve database performance.11 min readUnit 8
Replication & High Availability: Strategies, Models & FailoverUnit 8 of Database Administration explores how databases ensure continuous operation through replication (synchronous/asynchronous), high availability (HA) architectures, failover mechanisms, and real-world trade-offs between consistency and uptime.10 min readUnit 9
Database Auditing: Techniques, Tools & ComplianceUnit 9 of Database Administration explores database auditing fundamentals, including audit trails, logging mechanisms, regulatory compliance (GDPR, SOX), and tools like Oracle Audit Vault, SQL Server Audit, and PostgreSQL’s pgAudit. It covers audit policies, real-world applications in financial systems and healthcare, 11 min readUnit 10
Cloud Databases: Models, Services, Security & MigrationUnit 10 of Database Administration explores cloud-based database architectures, deployment models (IaaS/PaaS/SaaS), security challenges, migration strategies, and real-world implementations like AWS RDS and Google Cloud Spanner, with cost-performance tradeoffs and compliance considerations.14 min read