ITEC 3200 - Introduction to Databases

(3) Credit Hours
Prerequisite: ITEC 2140 or ITEC 2120 and (ITEC 2201 or BUSA 3100)
Additional Requirement: Windows based laptop or Apple MacBook (see IT Laptop Program @ www.ggc.edu/itlaptop)
Introduction to fundamental concepts of database management. Upon completion of this course students will be able to: (1) understand data, metadata and database systems core concepts; (2) understand logical/physical data organization and transaction management fundamental concepts; (3) understand the relational database model; (4) understand and use entity relationship (ER) modeling for conceptual design; (5) understand and use normalization of database tables technique to reduce data redundancy; (6) understand and use the core portion of structured query language (SQL) for data manipulation; (7) design, test and use databases within the course scope and in framework of Microsoft Access database application environment