| |
Mar 29, 2026
|
|
|
|
|
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.
Credit(s): 1
Outcomes
- Demonstrate working knowledge of fundamental concepts in the development and implementation of database systems.
- Explain data modeling; the application of both entity-relationship and normalization approaches to the design of relational model databases.
- Construct logical and physical database designs from conceptual models using best principles.
- Develop relational databases for business applications.
- Analyze database structure and data through the use of SQL.
- Examine techniques to secure 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)
|
|
