Dec 07, 2021  
2017-2018 Course Catalog 
2017-2018 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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

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

Learning Outcomes
At the end of this course students will be able to:

  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

Add to Portfolio (opens a new window)