91福利社

Course Outlines
Course Outlines

Database Management — ISTC 2040

  1. Course Description
    • Credits: 3.00
    • Lecture Hours/Week: 2.00
    • Lab Hours/Week: 2.00
    • OJT Hours/Week: 0
    • Prerequisites:
      • ISTC 1050: Database Systems
    • Corequisites: None
    • MnTC Goals: None
    This course focuses on working with an enterprise-level database management system as well as basic administrative tasks such as installations. The use of Structured Query Language (SQL) will be emphasized as it relates to data definition and data manipulation. Topics also include triggers and stored procedures. Prerequisites: Database Systems ISTC1050.
  2. Course Effective Dates: 8/20/07 – Present
  3. Outline of Major Content Areas
      As noted on course syllabus
  4. Learning Outcomes
    1. Install and configure enterprise-level DBMS.
    2. Monitor and troubleshoot DBMS performance.
    3. Use SQL data definition and manipulation commands.
    4. Implement triggers, functions and stored procedures.
    5. Understand dead lock issues.
    6. Back up and recover databases.
    7. Manage database security.
  5. Minnesota Transfer Curriculum Goal Area(s) and Competencies
  6. Learner Outcomes Assessment
      As noted on course syllabus
  7. Special Information
      None noted