4.00 Credits
As an introduction to relational database management systems and database programming for computers using modern enterprise database servers, this course covers fundamental concepts in database design, database modeling techniques, and Structured Query Language (SQL) programming techniques wile providing hands-on exercises in which students apply these concepts and techniques to real-world problems. The course introduces the SQL, Data Manipulation Langauge (DML), Data Definition Language (DDL), Data Control Language (DCL), and store procedure programming. It also includes concepts for building frameworks for high performance web applications in multi-tier environments. Students will implement a relational database from initial requirements and conceptual design (ER Diagram) to the physical database in a modern enterprise relational database management system (RDMS).
Prerequisite:
CIS 103, CSCI 112 (Prerequisite or Corequisite), or CSCI 118
Corequisite:
CSCI 112 (Prerequisite or Corequisite)