CSCI 2051 - Database Management Systems 2

1. DBMS planning
2. DBMS design
3. DBMS creation, configuration, modification
4. Tables, indices, views, reports
5. Automation using procedures, scripts, triggers
6. User administration and security
7. Transaction management
8. Query optimization
9. Backup and recovery
10. Performance monitoring and optimization
11. Data import/export/transformation
12. Reliability and availability
13. Replication
14. Maintenance

1. determine resource and capacity  requirements.
2. use appropriate techniques to design, create, and configure an optimal database to meet requirements.
3. import or convert data from a variety of formats.
4. analyze security issues in order to incorporate effective security measures.
5. create and manage tables, indices, views.
6. optimize queries using appropriate tools and techniques.
7. establish effective procedures to ensure data integrity.
8. automate database operations through the use of procedures, functions, and triggers.
9. use appropriate tools and policies to administer users and operations.
10. implement a backup strategy in order to backup and restore a database.
11. monitor performance and use optimization techniques to achieve high availability and throughput.
12. migrate data into databases.
13. replicate data from one DBMS to another.
14. use appropriate tools to ensure effective transaction capture and backup.
15. conduct periodic maintenance.

Courses and Registration