This course will present the essential skills for designing and working with Relational Databases. Students will become familiar with the functions of a Database Management System (DBMS) and its components in comparison with legacy systems and alternative information storage mechanisms. Students will use Structured Query Language (SQL) to create progressively complex queries on existing databases, including multi-table joins. Students will study and apply the principles of normalization and referential integrity in designing and implementing multi-table relational databases. Students will design and create databases that are maintainable, secure, and adaptable to change in business requirements.

70 Hours