Aug 05, 2026  
2026-2027 DCTC Catalog 
  
  Catalog Home
  Programs (A-Z)
  Programs by Awards
  Minnesota Transfer Curriculum (MnTC)
  Courses
  Course Outlines
  About DCTC
  Enrollment
  Financial Aid
  Records & Registration
  Student Resources
  Transfer Credit Policies
  Tuition & Fees
  Types of Degrees
  Academic Calendar
HELP
2026-2027 DCTC Catalog

ISTC 2040 - Database Management


3 Credits
Prerequisites ISTC 1050 

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.

Learning Outcomes
Implement triggers, functions and stored procedures.

Install and configure enterprise-level DBMS.

Monitor and troubleshoot DBMS performance.

Use SQL data definition and manipulation commands.

Manage database security.

Back up and recover databases.

Understand dead lock issues.