Iğdır University Lifelong Learning Programme

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type of Course Unit	Year of Study	Semester	Number of ECTS Credits
3303003202	DATABASE -2	Elective	2	3	4

Level of Course Unit

Short Cycle

Objectives of the Course

It is aimed that, with this course, students will gain basic skills in management of database and server.

Name of Lecturer(s)

Öğr. Gör. Metehan GÜNDE

Learning Outcomes

1	Students will install management panel and a server software of at least two suppliers who have different industrial standarts and define database and user.
2	Students will define tables, manage database diagram, transfer database.
3	Students will edit display, trigger, subprogramme, index, user role, user-defined data types and assumed value.
4	Students will duplicate data, make a maintenance plan, analyse a performance and improve.

Mode of Delivery

Evening Education

Prerequisites and co-requisities

None

Recommended Optional Programme Components

None

Course Contents

"1. Install a Server Software of at least two Suppliers who have different Industrial Standarts 2. Install a Database Management Panel 3. Create a Database and Define Users 4. Define Tables and Manage Diagram 5. Transfer Data 6. Create a new Database from the Existing Database 7. Edit Subprogrammes, Index, Display and Trigger 8. Edit User Role and User-defined Data Types 9. Edit Rule and Edit assumed Value 10. Duplicate Data and Make a Maintenance Plan 11. Analyses of a Performance and Improve "

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	Install a Server Software of at least two Suppliers who have different Industrial Standarts
2	Install a Database Management Panel, Create a Database and Define Users
3	Create a Database and Define Users, Define Tables and Manage Diagram
4	Define Tables and Manage Diagram, Transfer Data
5	Transfer Data and Create a new Database from the Existing Database
6	Transfer Data and Create a new Database from the Existing Database
7	Edit Display and Trigger
8	Edit Subprogrammes and Index
9	Edit User Role and User-defined Data Types
10	Edit Rule
11	Edit assumed Value, Duplicate Data and Plan Maintenance Duplicate Data and Make a Maintenance Plan
12	Duplicate Data and Make a Maintenance Plan
13	Analyses of a Performance
14	Improve

Recommended or Required Reading

"Yazılımcılar İçin SQL Server 2008 R2 & Veritabanı Programlama, Yaşar GÖZÜDELİ, Seçkin Yayıncılık, Ankara, 2011. MySQL ve PostgreSQL ile Veritabanı Programlama, Mehmet şamlı, Seçkin Yayıncılık, Ankara, 2005.

Planned Learning Activities and Teaching Methods

Assessment Methods and Criteria

Term (or Year) Learning Activities	Quantity	Weight
Midterm Examination	1	100
SUM		100
End Of Term (or Year) Learning Activities	Quantity	Weight
Final Examination	1	100
SUM		100
Term (or Year) Learning Activities		40
End Of Term (or Year) Learning Activities		60
SUM		100

Language of Instruction

Turkish

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Midterm Examination	1	1	1
Final Examination	1	2	2
Attending Lectures	14	4	56
Practice	1	1	1
Self Study	14	3	42
Individual Study for Mid term Examination	1	6	6
Individual Study for Final Examination	1	12	12
TOTAL WORKLOAD (hours)			120

Contribution of Learning Outcomes to Programme Outcomes

	PO 1	PO 2	PO 3	PO 4	PO 5	PO 6	PO 7	PO 8	PO 9	PO 10	PO 11
LO1	5		4
LO2	5		4
LO3	5		3
LO4	5		4

* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High