Database Fundamentals. 3 credits, 3 contact hours

Catalog description

This course gives students extensive, pragmatic experience in designing, building, querying, updating, maintaining and managing relational databases, using the Structured Query Language (SQL). We will start our journey by analyzing what database is and why it is superior to other data management methods. We will then conduct logical and physical database design. SQL will be extensively covered, and students will design and implement sophisticated SQL queries invoking self-joins, outer joins, correlated subqueries and related concepts. Hands-on experience will be gained by working with actual databases using industry-standard database management systems such as Oracle.