CSCI2051 — Database Management Systems 2
CSCI 2051 - Database Management Systems 2 CSCI 2051 - Database Management Systems 2 Hours/Week: Lecture 3 Lab 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 use appropriate techniques to design, create, and configure an optimal database to meet requirements. import or convert data from a variety of formats. analyze security issues in order to incorporate effective security measures. create and manage tables, indices, views. optimize queries using appropriate tools and techniques. establish effective procedures to ensure data integrity. automate database operations through the use of procedures, functions, and triggers. use appropriate tools and policies to administer users and operations. implement a backup strategy in order to backup and restore a database. monitor performance and use optimization techniques to achieve high availability and throughput. migrate data into databases. replicate data from one DBMS to another. use appropriate tools to ensure effective transaction capture and backup. conduct periodic maintenance. Minnesota Transfer Curriculum (MnTC): Goals and Competencies Competency Goals
Prerequisites: CSCI2050