IT 201 - Database Fundamentals

Credits: 5
Covers the management of database tables, queries, views, indexes, and constraints using a Database Management System (DBMS) and Structured Query Language (SQL). Hands-on exercises include the analysis, troubleshooting, and problem solving of real world database scenarios.

Course Outcomes:
Students who successfully complete this class will be able to:

Understand and manipulate database objects using CREATE, ALTER, and DROP statements.
Understand and manipulate data using SELECT, INSERT, UPDATE, and DELETE statements.
Understand, design and implement PRIMARY KEY and FOREIGN KEY constraints.
Understand, design, and create SQL queries with inner and outer joins.
Understand, design, and create SQL queries that utilize set operations and subqueries.
Understand basic concepts of database security and techniques used to secure databases.

Program Outcomes

Understand and demonstrate basic programming and database constructs.

College-wide Outcomes

Critical Thinking - Critical thinking finds expression in all disciplines and everyday life. It is characterized by an ability to reflect upon thinking patterns, including the role of emotions on thoughts, and to rigorously assess the quality of thought through its work products. Critical thinkers routinely evaluate thinking processes and alter them, as necessary, to facilitate an improvement in their thinking and potentially foster certain dispositions or intellectual traits over time.