ITEC 2120 - Database Design and SQL

4 Credit(s) 3 credits lecture/1 credit lab

This course is designed to provide individuals to build a database application. Students will create the logical and physical database design. They will create tables, queries, forms and reports while implementing proper design methodologies. Students will use SQL to create a simple query, join multiple tables, perform unions, simple totals, grouping data, inserting data, updating data and deleting data. Course instruction is enhanced through hands-on labs, projects, and exercises.

Course Prerequisite(s): ITEC 1006 or instructor permission