| |
Mar 29, 2026
|
|
|
|
|
IT 408 - Database Design & Development (SQL)
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 the DBMS concepts and database design techniques and principles. The emphasis is on the conceptual database design as well as implementation details. 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, troubleshooting and concurrency control.
Credit(s): 3
Prerequisite(s):
IT 202 .
Outcomes
- Construct advanced logical and physical database designs from conceptual models.
- Create complex SQL queries that aggregate data from multiple tables.
- Maximize database performance and reliability through benchmarking and optimization techniques.
- Build scalable database infrastructures for business applications and data analysis.
- Improve the security of database objects and data.
- Develop professional interpersonal skills by creating comprehensive database designs and physical implementations both individually and within teams.
Add to Favorites (opens a new window)
|
|
