Course Description
Course Outcomes
Demonstrate the knowledge and ability to design, implement, maintain and repair of an organization’s database
discuss the physical database design process of producing an efficient and tuned database;
elaborate on data storage and indexing options, and perform query optimization;
use SQL for database creation, manipulation, and control;
perform daily database administration tasks;
Integrate data from old systems into a new system.
Examine and coordinate modifications to the system when needed, and troubleshoot problems when they occur
Manage, plan and coordinate security measures with network administrators
Course modules
Modules | Activities |
1 | Review of course outline, Database concepts & architecture |
2 | Database concepts & architecture |
3 | Database design, Relational model |
4 | Relational model |
5 | Basic knowledge functional dependencies and normal forms |
6 | Functional dependencies and normal forms demo practice |
7 | SQL DDL |
8 | SQL DML |
9 | Relational Algebra |
10 | Relational Calculus, File and Index Structures |
11 | File and Index Structures |