Aug 06, 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 1050 - Database Systems


3 Credits
Prerequisites ISTC 1015 

This course focuses on the fundamentals of relational databases; their use, design and implementation. The course will include entity-relationship modeling, logical and physical design and normalization. The use of Structured Query Language (SQL) for data manipulation will be emphasized. The course will also cover concepts of client/server, distributed and object-oriented databases, big data security, and data warehousing.

Learning Outcomes
Summarize database administration concepts of concurrency control, locking and recovery strategies.

Explain various database science concepts such as big data, NoSQL databases, and data warehousing.

Design relational databases according to normalization practices, annotating the design in Entity-Relationship diagrams.

Utilize SQL commands for data definition, data retrieval, and data manipulation in single and multiple table environments.