# |
Learning Outcomes |
1 |
To be able to learn structured query language, database objects and data types.
|
2 |
To be able to understand structured query language commands.
|
3 |
To be able to learn how to open, modify delete tables in the structured query language.
|
4 |
To be able to understand administrative functions in the structured query language.
|
5 |
To be able to learn the programming logic in a client/server featured database.
|
6 |
To be able to prepare an interface in a client/server featured database.
|
7 |
To be able to prepare reports in a client/server featured database.
|
# |
Subjects |
Teaching Methods and Technics |
1 |
Introduction to database systems, fundamentals |
Lecture, discussion, presentation |
2 |
Relational model |
Lecture, discussion, presentation |
3 |
Relational algebra |
Lecture, discussion, presentation |
4 |
Database design in E/R model |
Lecture, discussion, presentation |
5 |
Database design theory |
Lecture, discussion, presentation |
6 |
SQL: Basics |
Lecture, discussion, presentation |
7 |
1. Mid Term Exam |
Exam |
8 |
SQL: Subqueries, aggregation |
Lecture, discussion, presentation |
9 |
SQL: NULL’s outerjoints |
Lecture, discussion, presentation |
10 |
SQL: Modifications, constraints, triggers |
Lecture, discussion, presentation |
11 |
SQL: Views, indexes |
Lecture, discussion, presentation |
12 |
More database design thoery |
Lecture, discussion, presentation |
13 |
Data integration, warehousing, mining |
Lecture, discussion, presentation |
14 |
Final Exam |
Exam |
15 |
|
|
16 |
|
|
# |
Learning Outcomes |
Program Outcomes |
Method of Assessment |
1 |
To be able to learn structured query language, database objects and data types.
|
1͵3 |
1͵2 |
2 |
To be able to understand structured query language commands.
|
1͵3 |
1͵2 |
3 |
To be able to learn how to open, modify delete tables in the structured query language.
|
1͵3 |
1͵2 |
4 |
To be able to understand administrative functions in the structured query language.
|
1͵3 |
1͵2 |
5 |
To be able to learn the programming logic in a client/server featured database.
|
1͵3 |
1͵2 |
6 |
To be able to prepare an interface in a client/server featured database.
|
1͵3 |
1͵2 |
7 |
To be able to prepare reports in a client/server featured database.
|
1͵3 |
1͵2 |