CSCI 2051 - Database Management Systems 2

Credits: 3
Hours/Week: Lecture 3Lab None
Course Description: This course presents advanced database management systems (DBMS) concepts and applications. It emphasizes topics essential for creating, maintaining, and using a multi-user client-server database system. These include configuration, optimization, security, backup, replication, and troubleshooting. Students will complete hands-on exercises using a current client/server database system.
MnTC Goals
None

Prerequisite(s): CSCI 2050   with a grade of C or higher.
Corequisite(s): None
Recommendation: None

Major Content

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