VERİTABANI UYGULAMALARI VE GÜVENLİĞİ PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
BGT254	VERİTABANI UYGULAMALARI VE GÜVENLİĞİ	4	2	2	5

GENERAL INFORMATION
Language of Instruction :	Türkçe
Level of the Course Unit :	ÖNLİSANS, TYY: + 5.Düzey, EQF-LLL: 5.Düzey, QF-EHEA: Kısa Düzey
Type of the Course :	Zorunlu
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Öğr.Gör. TUĞÇE YÜKSEL
Instructor(s) of the Course Unit	Öğr.Gör. AYSUN YILMAZ KIZILBOĞA
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	Öğrencilere veri tabanı yönetim sistemlerini (VTYS) kullanmayı öğretmek ve uygulamalı projelerle veritabanı tasarımı ve yönetimi konularında deneyim kazandırmak. İleri Sql konuları ile veritabanı güvenliğini sağlamak.
Contents of the Course Unit:	Öğrencilerin veritabanı sistemlerini anlamalarını, modelleme yapmalarını ve SQL gibi araçlarla veri yönetimi ve sorgulama becerileri kazanmalarını sağlar.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Veritabanı Temellerini Kavrayabilme Veri Modelleme Becerisi Kazanma İlişkisel Veritabanı Tasarımı SQL Sorguları Yazabilme İleri SQL İle Veritabanı Güvenliğini Sağlamak Proje Geliştirme ve Sunum Yapabilme

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	Anlatım	Giriş ve Temel Kavramlar	-
2	Uygulama	Veritabanı Modelleme ve ER Diyagramları	-
3	Uygulama	İlişkisel Veritabanı Tasarımı	-
4	Uygulama	Veri Bütünlüğü ve Kısıtlamalar	-
5	Uygulama	Normalizasyon	-
6	Uygulama	SQL'e Giriş	-
7	Uygulama	Temel SQL Sorguları	-
8	-	ARA SINAV	-
9	Uygulama	SQL-Joinler	-
10	Uygulama	SQL-Joinler	-
11	Uygulama	İleri SQL - Fonksiyonlar	-
12	Uygulama	İleri SQL - Store Procedure	-
13	Uygulama	İleri SQL - Trigger	-
14	Uygulama	Proje Sunumları	-
15	Uygulama	Proje Sunumları	-
16	-	FİNAL	-
17	-	FİNAL	-

SOURCE MATERIALS & RECOMMENDED READING
Elmasri R., Navathe S.B., Fundamentals of Database Systems, 7th edition, Pearson Education, 2016.

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Knows the necessary terms and information in the computer field.				3
2	Gains knowledge of the concept of information security.						5

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains the ability to learn the necessary concepts in the computer field.				3

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to identify, define, formulate and solve complex Information Security problems; for this purpose, the ability to select and apply appropriate analysis and modeling methods					4

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design a complex computer-based system, process, security to meet specific requirements under realistic constraints and conditions; for this purpose, the ability to apply modern design methods.					4

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design, conduct experiments, collect data, analyze and interpret results for examining Information Security problems						5
2	Ability to work effectively within the discipline of Information Security and in multi-disciplinary teams; individual study skills						5
3	Professional and ethical responsibility awareness						5
4	Knowledge of project management and business practices such as risk management and change management; awareness of entrepreneurship, innovation and sustainable development					4

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to develop, select and use modern techniques and tools required for Information Security applications					4
2	Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself					4

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to communicate effectively in Turkish orally and in writing, foreign language knowledge					4

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Information about the effects of Information Security practices on health, environment and security in universal and social dimensions and the problems of the age; Awareness of the legal consequences of Information Security solutions					4

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Ders	14	2	28
Derse Ön Hazırlık ve Ders Sonrası Pekiştirme	14	2	28
Arazi Çalışması	0	0	0
Grup Çalışması / Ödevi	0	0	0
Laboratuvar	14	2	28
Okuma	0	0	0
Ödev	0	0	0
Proje Hazırlama	4	2	8
Seminer	0	0	0
Staj	0	0	0
Teknik Gezi	0	0	0
Web Tab. Öğrenme	0	0	0
Uygulama	0	0	0
Yerinde Uygulama	0	0	0
Mesleki Faaliyet	0	0	0
Sosyal Faaliyet	0	0	0
Tez Hazırlama	0	0	0
Alan Çalışması	0	0	0
Rapor Yazma	0	0	0
Final Sınavı	1	1	1
Final Sınavı Hazırlığı	14	1	14
Ara Sınav	1	1	1
Ara Sınav Hazırlığı	7	2	14
Kısa Sınav	0	0	0
Kısa Sınav Hazırlığı	0	0	0
TOPLAM	69	0	122