|3 units | 15 Weeks
This course introduces students to the foundations of database systems. No prior database experience is assumed, though students who have taken an undergraduate course in databases are encouraged to attend.
The course covers topics related to the engineering and design of database systems, including data models; database and schema design; integrity constraints; query processing; query optimization and cost estimation; transactions; trigger systems; pub-sub systems; and XML querying. For implementation, PHP and MySQL will be considered; for web programming and databases will be the focus.
Upon completing this course, a student should be able to:
WHEN REGISTERING, SELECT THIS COURSE TITLE:IT531 Database Design
- Understand database design principles and implementation approaches
- Understand how real-world database systems are designed and implemented
- Manage most popular Databases
- Using PHP and MySQL for the database usage for web application
- Understand Relationship Databases vs XML