This course provides an introduction to relational database management systems. The course covers basic types of databases, data integrity, the relational model, entity relationship modeling, normalization, and performance measurement.
Objectives:
Describe databases and database management systems
Explain relational database management systems
Design simple database models using Entity-Relationship Modeling
Normalize a database
Measure the performance of a database
Estimate the storage needs of a database
Explain the reasons for and pitfalls of denormalizing a database
Topics:
Understanding Databases
Relational Database Management Systems
Entity-Relationship Models (ERDs)
Understanding Normalization
Planning and Management
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
