DATABASE APPLICATIONS AND SECURITY COURSE IDENTIFICATION AND APPLICATION INFORMATION
| Code |
Name of the Course Unit |
Semester |
In-Class Hours (T+P) |
Credit |
ECTS Credit |
| BGT254 |
DATABASE APPLICATIONS AND SECURITY |
4 |
2 |
2 |
5 |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
| Week |
Preparatory |
Topics(Subjects) |
Method |
| 1 |
- |
Introduction and Basic Concepts |
Expression |
| 2 |
Research |
Database Modeling and ER Diagrams |
Application |
| 3 |
Research |
Relational Database Design |
Application |
| 4 |
Research |
Data Integrity and Restrictions |
Application |
| 5 |
Research |
Normalization |
Application |
| 6 |
Research |
Introduction to SQL |
Application |
| 7 |
Research |
Basic SQL Queries |
Application |
| 8 |
Research |
SQL-Joins |
Application |
| 9 |
Research |
SQL-Joins |
Application |
| 10 |
- |
MID-TERM EXAM |
- |
| 11 |
Research |
Advanced SQL - Functions |
Application |
| 12 |
Research |
Advanced SQL - Store Procedure |
Application |
| 13 |
Research |
Advanced SQL - Trigger |
Application |
| 14 |
- |
Project Presentations |
Application |
| 15 |
- |
Project Presentations |
Application |
| 16 |
- |
FINAL EXAM |
- |
| 17 |
- |
FINAL EXAM |
- |