4.00 Credits
3-2-4 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). Prereqs: (Eff. FL20) CSCI 112, which may be taken concurrently, or CIS 103, or CSCI 118.
Prerequisite:
Prereqs: (Eff. FL20) CSCI 112, which may be taken concurrently, or CIS 103, or CSCI 118.