Introduction to Database Design and Implementation for Business

Introduction to Database Design and Implementation for Business

MET CS 469 (4 credits)

Learn the latest relational and object-relational tools and techniques for persistent data and object modeling and management. You will gain extensive hands-on experience using Oracle or Microsoft SQL Server and Structured Query Language (SQL). Topics include the relational and entity-relational models, data modeling, normalization, object modeling, SQL, advanced SQL, stored procedures, triggers, database design, database lifecycle, and transactions. Advanced topics, including performance tuning, distributed databases, replication, business intelligence, data warehouses, internet databases, database administration, security, backup, and recovery, will be introduced. You will design and implement a database system as a term project. Laboratory course. Restrictions: This course may not be taken in conjunction with MET CS 579 or MET CS 669. Only one of these courses can be counted toward degree requirements.