Installing a database server: Planning; Hardware and Software considerations; Licensing issues; Methods of server Installation. Standard, unattended, and installation. Managing Database files. Managing Security: Implementing authentication, assigning Login accounts to users and Roles, Assigning and managing permissions. Managing Backup operations: Types of backup methods; Implementing backups. Disaster Recovery and Restoration of Databases: Monitoring performance. Tuning database performance. Data Transformation and Transfer operations. Managing database Availability. Database Replication and Distribution Operations. Transaction management and concurrency control. Case study tools Oracle /SQL server/ My SQL
- editing-lecturer: Jeremiah Onunga