| 1 |
The relevant unit in the course book |
Concepts of data, information, and databases; objectives, components, and applications of database management systems |
Explanation, problem-solving, practical application |
| 2 |
The relevant unit in the course book |
Database models; examination of relational and non-relational database approaches |
Explanation, problem-solving, practical application |
| 3 |
The relevant unit in the course book |
The relational database model; table, row, column, field, record, key, and integrity constraints |
Explanation, problem-solving, practical application |
| 4 |
The relevant unit in the course book |
Database design, entity-relationship model, and the concepts of entity, attribute, and relationship |
Explanation, problem-solving, practical application |
| 5 |
The relevant unit in the course book |
Converting entity-relationship diagrams to a relational schema |
Explanation, problem-solving, practical application |
| 6 |
The relevant unit in the course book |
Normalization, functional dependency |
Explanation, problem-solving, practical application |
| 7 |
The relevant unit in the course book |
Introduction to SQL; creating, modifying, and deleting databases and tables using SQL commands |
Explanation, problem-solving, practical application |
| 8 |
The relevant unit in the course book |
SQL data manipulation commands; inserting, updating, and deleting data |
Explanation, problem-solving, application |
| 9 |
The relevant unit in the course book |
SQL queries and the use of comparison and logical operators |
Explanation, problem-solving, practical application |
| 10 |
- |
MID-TERM EXAM |
- |
| 11 |
The relevant unit in the course book |
SQL functions; aggregate functions, grouping |
Explanation, problem-solving, practical application |
| 12 |
The relevant unit in the course book |
Querying multiple tables; inner, outer, and cross joins |
Explanation, problem-solving, practical application |
| 13 |
The relevant unit in the course book |
Basic use of subqueries, views, indexes, and stored procedures |
Explanation, problem-solving, practical application |
| 14 |
The relevant unit in the course book |
Practice |
Practical application |
| 15 |
The relevant unit in the course book |
Practice |
Practical application |
| 16 |
- |
FINAL EXAM |
- |
| 17 |
- |
FINAL EXAM |
- |