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 while providing hands-on exercises in which students apply these concepts and techniques to real-world problems. The course introduces the Structured Query Language (SQL database language), Data Manipulation Language (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).
Additional course fee: $85.