Year
Year 2
Semester
First Semester
Credit
3
Program Description
Design, implementation, and administration of relational database systems.
About this course
Relational databases power most of the business applications used today. In this course, you will learn how to design, build, and manage those systems. You will move from basic data structures to complex database environments that support real-world applications.
You will work directly with database management software, writing SQL commands to store and retrieve information. You will also learn how to keep data secure and organized so that systems run smoothly.
Who takes this course
This course is part of the Computer Systems Technology and Computer Systems Technology (Part-time) programs at the Benchlands Campus.
Credits: 3 · Hours: 45
Prerequisites
Learning outcomes
- Design and build normalized relational database schemas for business requirements
- Write complex SQL queries to create, modify, and extract data
- Implement user roles, permissions, and security controls
- Administer database backups and perform routine maintenance tasks
Evaluation
| Component | Weight (%) |
| Database design project | 30 |
| Midterm exam | 25 |
| Practical lab assessments | 25 |
| Final exam | 20 |