VERİ TABANI YÖNETİMİ DERS TANITIM VE UYGULAMA BİLGİLERİ

Kodu	Dersin Adı	Yarıyıl	Süresi(T+U)	Kredisi	AKTS Kredisi
IBY216	VERİ TABANI YÖNETİMİ	4	4	2	6

DERS BİLGİLERİ
Dersin Öğretim Dili :	Türkçe
Dersin Düzeyi	BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle
Dersin Türü	Zorunlu
Dersin Veriliş Şekli	-
Dersin Koordinatörü	Prof. ORHAN İŞCAN
Dersi Veren Öğretim Üyesi/Öğretim Görevlisi
Ders Ön Koşulu	Yok

AMAÇ VE İÇERİK
Amaç:	This course aims to enable the student to access the data using the SQL language, to analyze the query results, and also to recognize the Oracle relational database systems and develop advanced data processing tools with PL/SQL.
İçerik:	Contents of the course include the subjects such as concepts of database systems, transaction processing, synchrony control and database recovery, object-oriented and object-relational databases, semi-structured data and XML, parallel and distributed databases, advanced distributed databases concepts, access to big data, and temporary databases.

DERSİN ÖĞRENME ÇIKTILARI (Öğrenciler, bu dersi başarı ile tamamladıklarında aşağıda belirtilen bilgi, beceri ve/veya yetkinlikleri gösterirler.)
Evaluate the role of database management systems in the organization.
Use current and logical design methods for databases.
Produce a physical database design from its logical design.
Apply a database solution to the information technology problem.
Use the SQL query language.
Determine alternative design techniques for management and reporting applications.
Prepare queries for big data sets.

HAFTALIK DERS KONULARI VE ÖNGÖRÜLEN HAZIRLIK ÇALIŞMALARI
Hafta	Ön Hazırlık	Konular	Yöntem
1	-	Introduction	Lecture, Discussion, Practice
2	Literature Review	Transaction processing concepts	Lecture, Discussion, Practice
3	Literature Review	Transaction processing concepts	Lecture, Discussion, Practice
4	Literature Review	Synchrony control techniques	Lecture, Discussion, Practice
5	Literature Review	Synchrony control techniques	Lecture, Discussion, Practice
6	Literature Review	Database recovery systems	Lecture, Discussion, Practice
7	Literature Review	Object-oriented and object-relational databases	Lecture, Discussion, Practice
8	-	MID-TERM EXAM	-
9	Literature Review	semi-structured data and XML	Lecture, Discussion, Practice
10	Literature Review	Parallel and Distributed databases	Lecture, Discussion, Practice
11	Literature Review	Distributed databases – advanced concepts	Lecture, Discussion, Practice
12	Literature Review	Distributed databases – advanced concepts	Lecture, Discussion, Practice
13	Literature Review	Big data - Apache Hadoop, MapReduce & Pig Latin	Lecture, Discussion, Practice
14	Literature Review	Temporary Databases	Lecture, Discussion, Practice
15	Literature Review	General Revision	Lecture, Discussion, Practice
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

KAYNAKLAR
Ozseven, T. (2015). Veritabani Yonetim Sistemleri II, Beta Publications, Istanbul.
Tan, P., Steinbach, M. Kumar, V. (2005). Introduction to Data Mining.

ÖLÇME VE DEĞERLENDİRME
Yarıyıl İçi Yapılan Çalışmaların Ölçme ve Değerlendirmesi	Etkinlik Sayısı	Katkı Yüzdesi	Açıklama

(0) Etkisiz	(1) En Düşük	(2) Düşük	(3) Orta	(4) İyi	(5) Çok İyi
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Interpret the basic concepts, theories and approaches of business information management, programming and management information systems.						5
2	Explain concepts related to field by associating them with information systems and programming languages.					4

KNOWLEDGE
Factual
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Explain current information about the field with information and communication theories.						5
2	Relate the information and facts about his/her field with other areas of social sciences.						5

SKILLS
Cognitive
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Prepare the technical infrastructure and content of information management in businesses.						5
2	Integrate the theoretical knowledge about the field into today's technology					4

SKILLS
Practical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Apply the programming languages for the functioning of business.						5
2	Interpret the theoretical and practical information they obtained in their field.					4

OCCUPATIONAL
Autonomy & Responsibility
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Fulfill his/her duties and responsibilities related to the solution of problems arising in enterprises.						5
2	Conducts projects related with his/her field.						5

OCCUPATIONAL
Learning to Learn
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Integrate the technical information and approaches about his/her field to business management information processes.						5
2	Research on scientific, sectoral developments and innovations related to the field with lifelong learning as a principle.						5

OCCUPATIONAL
Communication & Social
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Cooperates with stakeholders in order to generate new ideas.					4
2	Organize projects and activities for the social environment with social responsibility consciousness and to be able to apply those.					4

OCCUPATIONAL
Occupational and/or Vocational
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Students will be able to apply knowledge and skills related to his / her field by taking into account his legal, social and ethical responsibilities.						5
2	Write programs by using the programming languages related with his/her field.					4

DERSİN İŞ YÜKÜ VE AKTS KREDİSİ
Öğrenme-Öğretme Etkinlikleri İş Yükü
Öğrenme-Öğretme Etkinlikleri	Etkinlik(hafta sayısı)	Süresi(saat sayısı)	Toplam İş Yükü
Lecture & In-Class Activities	14	3	42
Preliminary & Further Study	13	3	39
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	0	0	0
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	1	1	1
Preparation for the Final Exam	6	5	30
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	6	42
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	42	0	155