Print Page
Database Design and Implementation (ITEC 1375)
Total Credits:
4
Lecture Credits:
3
Lab Credits:
1
Description:
This course will help you learn to design, implement and manage database systems, teaching you database fundamentals and design, data storage and retrieval techniques, security, normalization, and administration of a database management system. You will reinforce these concepts by creating, maintaining, and naturalizing data using individual and group hands-on lab exercises. Must be taken A-F.
Topical Outline:
1. Fundamental relational database concepts
2. Relational database design
3. Database queries, functions and procedures
4. Relational database administration
5. Relational database maintenance
6. Relational database security
Learning Outcomes:
1. Define relational database terms and concepts
2. Design and create relational database structures
3. Create query statements to search, create, read, update, and delete data
4. Manage and administer a database environment using appropriate strategies and tools
5. Appreciate the importance of normalization for performance, organization; use appropriate processes to create an optimally normalized database
6. Write procedures and functions to write, access and manage data
Prerequisites:
ITEC 1100,
ITEC 1110,
ITEC 1150, and
ITEC 1250