DATABASE MANAGEMENT SYSTEMS II DERS TANITIM VE UYGULAMA BİLGİLERİ

Kodu	Dersin Adı	Yarıyıl	Süresi(T+U)	Kredisi	AKTS Kredisi
CMP152	DATABASE MANAGEMENT SYSTEMS II	2	2	2	7

DERS BİLGİLERİ
Dersin Öğretim Dili :	İngilizce
Dersin Düzeyi	ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle
Dersin Türü	Zorunlu
Dersin Veriliş Şekli	-
Dersin Koordinatörü	Lecturer ADNAN KÜRŞAT TEKE
Dersi Veren Öğretim Üyesi/Öğretim Görevlisi	Öğr.Gör. ADNAN KÜRŞAT TEKE
Ders Ön Koşulu	Yok

AMAÇ VE İÇERİK
Amaç:	In today's world, data is one of the most important and vital corporate assets. Database management is one of the main topics of information technology strategy and information resource management. Based on these reasons, the aim of the course is to equip students with the most up-to-date knowledge and skills in analysis, design and application areas.
İçerik:	Data modeling and logical design of databases in the course; data description, processing and control languages; physical design of databases; Programming with SQL; data access standards; transaction management and client-server systems are discussed. In the field of database management, some advanced topics such as object oriented databases, distributed databases and data warehouses are also mentioned.

DERSİN ÖĞRENME ÇIKTILARI (Öğrenciler, bu dersi başarı ile tamamladıklarında aşağıda belirtilen bilgi, beceri ve/veya yetkinlikleri gösterirler.)
Prepares a relational database.
Implements a relational database.
Uses queries in a relational database using SQL language.
Designs multidimensional databases and data warehouses.
Designs object-relational and object oriented databases.
Creates users using SQL language.
Edits existing user roles using SQL language.

HAFTALIK DERS KONULARI VE ÖNGÖRÜLEN HAZIRLIK ÇALIŞMALARI
Hafta	Ön Hazırlık	Konular	Yöntem
1	-	Database Systems and Data Models	Instruction
2	Research	Relational Database Model	Instruction
3	Research	Entity-Relationship Model	Instruction
4	Research	Normalization of Database Tables	Demonstration
5	Research	Introduction to SQL Programming Language	Demonstration
6	Research	Functions Used in SQL Language	Demonstration
7	Research	Functions Used in SQL Language	Demonstration
8	-	MID-TERM EXAM	-
9	Research	Database Problem Solutions	Demonstration
10	Research	Advanced SQL Programming	Demonstration
11	Research	Database Design	Demonstration
12	Research	Transaction Management and Concurrency Control (Dynamic T-SQL)	Demonstration
13	Research	Database Performance Settings and Query Optimization	Demonstration
14	Research	Query and Access Security	Demonstration
15	Research	Backup and Restoring from Backup	Demonstration
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

KAYNAKLAR
Projeler ile SQL Server 2016, Süleyman Uzunköprü, Kodlab

Ö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	Computer concepts, methods and the software would dominate.						5
2	Recognizes the basic functions of hardware.		1
3	Recognize personal and network operating systems.					4
4	Ethics related to the profession, oversees the health and safety measures.						5
5	Have adopted the philosophy of total quality and technical elements that could support institutional processes become.						5

KNOWLEDGE
Factual
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Hardware makes the process of discovery and establishment.		1
2	Explains data management processes.					4
3	Explains different areas where software languages are used.						5

SKILLS
Cognitive
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Software (PC, network and Internet environment) are involved in planning and design.					4
2	Professional in the field of algorithmic thinking to find solutions to deal with problems that will arise.						5
3	Use math skills in vocational areas.					4

SKILLS
Practical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Word processor, spreadsheet, presentation, database, and graphics-based design of programs you install and use.						5
2	Are given the chance to apply theoretical issues.						5

OCCUPATIONAL
Autonomy & Responsibility
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Detects common software and hardware failures, produce solutions to problems.						5
2	Measures related to data security and storage space and become individuals find appropriate solutions.					4
3	Fault finding, problem solving, decision-making and planning processes become competent in the subjects.						5

OCCUPATIONAL
Learning to Learn
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	They can learn and put into practice what they learned fast.						5
2	With the basic knowledge learned in the training process of learning and innovation that exists will have the ability to develop them.						5

OCCUPATIONAL
Communication & Social
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Except of course in the section related to their field of study clubs that exist in the industry to meet and communicate with the companies they have a chance.					4

OCCUPATIONAL
Occupational and/or Vocational
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Department students and programming, web design and technical courses will increase their chances to opt for.						5
2	Programming courses enables students to develop new programs and projects that they produce their own applications gain competence.						5
3	Some small or medium-sized companies take the role of management and leadership.					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	2	28
Preliminary & Further Study	14	3	42
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	8	3	24
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	12	2	24
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	14	3	42
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	2	14
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	71	0	176