MET CS 669 Database Design and Implementation for Business

Prerequisites: MET CS 200 or MET CS 622. Or, instructor’s consent.
Delivery: Boston-Charles River Campus, Online, Blended
Program: MS CIS core, MS SD elective
On Campus Syllabus: CS 669 Fall 2018
Online Syllabus: CS669_O2_SUMM 2 2018

Description: Students learn the latest relational and object-relational tools and techniques for persistent data and object modeling and management. Students gain extensive hands-on experience using Oracle or Microsoft SQL Server as they learn the Structured Query Language (SQL) and design and implement databases. Topics covered include: the relational and entity-relational models, data modeling, normalization, object modeling, SQL, advanced SQL, stored procedures, triggers, database design, database lifecycle, and transactions. Students are introduced to advanced topics including performance tuning, distributed databases, replication, business intelligence, data warehouses, internet databases, database administration, security, backup and recovery. Students design and implement a database system as a term project. (Lab class)

Restrictions: This course may not be taken in conjunction with CS 469 (undergraduate) or CS 579. Only one of these courses can be counted towards degree requirements.