CPSC-50900 Database Systems

This course offers a thorough investigation of relational databases and DBMS, and provides a three-fold coverage of the topic: database design, programming and administration. Students will learn how to use Entity Relationship Diagrams (ERDs) to model a problem, and implement normalization in the process of database design. Structured Query Language (SQL) and database programming will be presented, students will work on lab activities involving writing SQL queries, and using high-level programming languages for accessing and manipulating databases. Students will learn about various database administration tasks including performance monitoring, user account management, query optimization, deadlock detection and resolution, and more.

Credits

Prerequisite

CPSC 50100

© 2012 • Lewis University Main Campus, Romeoville, IL • (815) 838-0500 • • •
Lewis University is authorized to operate as a postsecondary educational institution by the Illinois Board of Higher Education .