VERİ TABANINA GİRİŞ DERS TANITIM VE UYGULAMA BİLGİLERİ

Kodu	Dersin Adı	Yarıyıl	Süresi(T+U)	Kredisi	AKTS Kredisi
YBS205	VERİ TABANINA GİRİŞ	3	3	3	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ü	Assist.Prof. DİDEM TETİK KÜÇÜKELÇİ
Dersi Veren Öğretim Üyesi/Öğretim Görevlisi	Arş.Gör. MERVE VURAL ALLAHAM
Ders Ön Koşulu	Yok

AMAÇ VE İÇERİK
Amaç:	This course aims to understand the concept of data, to model different structures, to list the functions of databases, to create the necessary infrastructure to develop queries by using relational databases.
İçerik:	Contents of the course include the subjects such as data concept, data structures, data models, access to databases, database components, relational databases, table creation, indexing, sorting and querying.

DERSİN ÖĞRENME ÇIKTILARI (Öğrenciler, bu dersi başarı ile tamamladıklarında aşağıda belirtilen bilgi, beceri ve/veya yetkinlikleri gösterirler.)
Describe concepts of data and database.
Discover the relational data model.
Experiment the relational structure of a business's information system.
Act data transfer from external environments.
Practice various queries on tables.
Design data entry forms.
Prepare reports from data.

HAFTALIK DERS KONULARI VE ÖNGÖRÜLEN HAZIRLIK ÇALIŞMALARI
Hafta	Ön Hazırlık	Konular	Yöntem
1	-	Introduction to databases, database concepts	Lecture & Discussion & Practice
2	Literature Review	What is database? database management system (VTYS), components of database management system	Lecture & Discussion & Practice
3	Literature Review	Data Models, relational models, relation types	Lecture & Discussion & Practice
4	Literature Review	Microsoft Office Access, table creation, Microsoft Access data types and functions	Lecture & Discussion & Practice
5	Literature Review	External data transfer, select query (sorting, and, or like)	Lecture & Discussion & Practice
6	Literature Review	Table creation querying, updating querying, text functions, conditional functions	Lecture & Discussion & Practice
7	Literature Review	Record append query, delete query, crosstab query, replicable finding query, mismatch finding query	Lecture & Discussion & Practice
8	-	MID-TERM EXAM	-
9	Literature Review	Form Design	Lecture & Discussion & Practice
10	Literature Review	Form Design	Lecture & Discussion & Practice
11	Literature Review	Form Design	Lecture & Discussion & Practice
12	Literature Review	Rapor Design	Lecture & Discussion & Practice
13	Literature Review	Rapor Design	Lecture & Discussion & Practice
14	Literature Review	Macro and Modules	Lecture & Discussion & Practice
15	Literature Review	Macro and Modules	Lecture & Discussion & Practice
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

KAYNAKLAR
Ozturk, T. H. (2015). Veritabanı Yonetimine Giris Oracle Database 11g R2. Abakus Books
Ozkan, Y., & Tuzel, A. D. (2009). Veri tabanı sistemleri. Alfa Press.
Ozseven, T. (2013). Veritabanı Yonetim Sistemleri I. Ekin Press

Ö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	Define concepts such as management, manager and leader.				3
2	Analyze the accuracy, reliability and validity of the new information obtained from the data.					4

KNOWLEDGE
Factual
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Report the obtained data.						5
2	Prepare software and projects related with the field.						5

SKILLS
Cognitive
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Use the appropriate resources for data analysis related with the field.						5
2	Analyze the work processes.						5

SKILLS
Practical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Manage projects as part of a team.						5
2	Apply the material, techniques and analyzes in relation with the subject for project and work flows.						5

OCCUPATIONAL
Autonomy & Responsibility
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Fulfill responsibility with a focus on result in individual and team studies.						5

OCCUPATIONAL
Learning to Learn
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Recognizes what he/she knows about his/her field or not.						5
2	Act the theoretical knowledge in real life with learning to learn approach.						5
3	Apply different methods and techniques with an innovative approach in his/her research.						5

OCCUPATIONAL
Communication & Social
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Apply the results obtained in accordance with voluntarism and social responsibility projects.						5
2	Establish a healthy contact with colleagues						5
3	Share the analyzes and obtained results with colleagues.						5
4	Cooperate with colleagues at international level with the help of foreign language competency.					4

OCCUPATIONAL
Occupational and/or Vocational
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Behave in accordance with ethical values regarding the collection, analysis and reporting of data.					4
2	Participate the design of work processes and systems with full quality.						5
3	Cooperate with other employees for the continuation of sustainability in the profession.					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	2	26
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	12	1	12
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	7	5	35
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	6	6	36
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	54	0	153