VOCATIONAL SCHOOL
Department of Information Security of Technology (Turkish)
MBGT 201 | Course Introduction and Application Information
| Course Name |
Database Security and Defense Algorithms
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBGT 201
|
Fall
|
2
|
2
|
3
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
Turkish
|
|||||
| Course Type |
Required
|
|||||
| Course Level |
Short Cycle
|
|||||
| Mode of Delivery | - | |||||
| Teaching Methods and Techniques of the Course | - | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description |
|
|
Core Courses |
X
|
| Major Area Courses | ||
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Creating server software from at least two different producers | |
| 2 | Creating administrator database panel, defining users | |
| 3 | Creating administrator database panel, defining users | |
| 4 | Defining tables and managing diagrams, making data transfer operations. | |
| 5 | Making data transfer operations, creating a new database from existing one. | |
| 6 | Display, creating trigger | |
| 7 | Creating subprograms, editing indexes. | |
| 8 | Mid-term exam | |
| 9 | Editing types of data descripted users, users roles. | |
| 10 | Editing default datas and rules. | |
| 11 | Editing default datas and rules. | |
| 12 | Making maintenance plans. | |
| 13 | Making maintenance plans. | |
| 14 | Performance analysis. | |
| 15 | Performance analysis. | |
| 16 | Final. |
| Course Notes/Textbooks | |
| Suggested Readings/Materials |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation |
1
|
10
|
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments | ||
| Presentation / Jury | ||
| Project | ||
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
40
|
| Final Exam |
1
|
50
|
| Total |
| Weighting of Semester Activities on the Final Grade |
2
|
60
|
| Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
| Total |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
2
|
32
|
| Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
2
|
32
|
| Study Hours Out of Class |
13
|
6
|
78
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
0
|
||
| Presentation / Jury |
0
|
||
| Project |
0
|
||
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
4
|
4
|
| Final Exam |
1
|
8
|
8
|
| Total |
154
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
|
1
|
2
|
3
|
4
|
5
|
||
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest