IT 530 SQL & DATABASE FUNDAMENTALS

The development of efficient and quality database applications requires an understanding of the fundamentals of database management systems, techniques for the design of databases and principles of database administration. This course introduces SQL queries, DBMS concepts, database design techniques and principles. Database security is also a key aspect of this course. Major topics include data modeling, normalization, SQL, database integrity management, database security, transaction management, recovery, and troubleshooting and concurrency control.

Credits

1

Prerequisite

Master's level students: None. Bachelor’s level students: IT 202.

Distribution

INFORMATION TECHNOLOGY