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	Compulsory	2	3	4

Level of Course Unit

Short Cycle

Objectives of the Course

With this course, the student will learn about managing databases and servers. It is aimed to gain competencies.

Name of Lecturer(s)

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

Learning Outcomes

1	854-Industry standard server software of at least two different manufacturers and sets up the management panel, defines the database and user.
2	2855-Table defines, manages database diagram, database transfers.
3	2856-View, trigger, subprogram, index, user roles, user edits the defined datatypes, rules, and default values.
4	2857-Data replication operations, maintenance plan, performance analysis and makes improvements.

Mode of Delivery

Daytime Class

Prerequisites and co-requisities

None

Recommended Optional Programme Components

Course Contents

1. INDUSTRIAL STANDARD OFFERED BY AT LEAST TWO DIFFERENT MANUFACTURERS INSTALLING THE SOFTWARE 2. SETUP OF DATABASE MANAGEMENT PANEL 3.CREATING A DATABASE AND DEFINING USERS 4. DEFINING TABLES AND MANAGING THE DIAGRAM 5. PERFORMING DATA TRANSFER OPERATIONS 6. CREATING A NEW DATABASE FROM THE EXISTING DATABASE 7. VIEW, TRIGGER, SUBROGRAMS AND INDICES EDIT 8.USER ROLES, USER-DEFINED DATA TYPES EDIT 9. ADJUSTING THE RULE AND DEFAULT VALUES 10. DATA MULTIPLICATION AND MAINTENANCE PLAN MAKING 11. PERFORMANCE ANALYSIS AND IMPROVEMENTS

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	Industry standard of at least two different manufacturers install server software
2	Setting up the database management panel, Database create and identify users
3	Create a database and describe, describe tables and diagram manage
4	Defining tables and managing diagrams, Performing data transfer operations
5	Performing data transfer operations, Existing create new database from database
6	New database from existing database create, view, trigger, subroutines and edit indexes
7	View, edit trigger
8	Editing subprograms and indexes
9	User roles, user-defined data types arrange
10	Arrange a rule
11	Editing default values, Data replication make operations and maintenance plan
12	Data replication and maintenance plan
13	Performing performance analysis
14	Making improvements

Recommended or Required Reading

SQL Server 2008 R2 & Database Programming for Participants, Yaşar GÖZÜDELİ, Seçkin Publishing, Ankara, 2011. Database Programming with MySQL and PostgreSQL, Mehmet Şamlı, Seçkin Publishing, 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)

application

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Midterm Examination	2	1	2
Final Examination	1	1.5	1.5
Makeup Examination	1	1	1
Quiz	5	1.5	7.5
Attending Lectures	1	14	14
Observation	1	1	1
Project Preparation	1	8	8
Project Presentation	1	8	8
Seminar	1	2	2
Self Study	1	28	28
Individual Study for Homework Problems	4	8	32
Homework	5	2	10
TOTAL WORKLOAD (hours)			115.0

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	2	3	4				5
LO2	2	3	4				5
LO3	2	3	4				5
LO4	2	3	4				5

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