COURSE UNIT TITLE

: DATABASE 2

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BLP 4126 DATABASE 2 COMPULSORY 2 1 0 5

Offered By

Computer Programming

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

DOCTOR ÖZER KESTANE

Offered to

Computer Programming
Computer Programming (Evening)

Course Objective

With this course, the student is to gain qualifications for managing the database and servers.

Learning Outcomes of the Course Unit

1   Perform database setup
2   Perform basic tasks with tables.
3   Perform complex tasks with tables
4   Manage a database server.
5   Performance analysis and enhancements to choose.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Setting up of at least two server programs according to industry standards
2 Database management panel set up, create a database and define users. User roles.
3 Create a database and identify users, identify the tables and diagrams, to manage.
4 Defining table. Managing diagrams. Performing data export tasks.
5 Performing data export tasks. Creating new database from existing database.
6 Creating View and Triggers.
7 Creating subprograms. Defining users modifying data types
8 Midterm Exam.
9 Define indexes.
10 Edit rules and default values
11 Edit rules and default values
12 Data multiplication processes.
13 Prepare maintenance plan.
14 Performance analysis and upgrade
15 Performance analysis and upgrade

Recomended or Required Reading

Textbook(s): Veri Tabanı ve Yönetimi, A.M. Ateş,Ö.Kestane, C.E.S. Enternasyonel Kitabevi, Izmir, 2004.
Supplementary Book(s): Veri Tabanı Yönetim Sistemleri 2, Turgut Özseven,Ekin Yayınevi,2019.
SQL Server 2014& Veritabanı Programlama, Yaşar Gözüdeli, Seçkin Yayınevi, 2014.Internet, Computer lab.
References:
Materials:Database server

Planned Learning Activities and Teaching Methods

1. Lectures
2. Example applications that make

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 FN Final
3 FCG FINAL COURSE GRADE VZ*0.40 + FN* 0.60
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) VZ*0.40 + BUT* 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

Mid-term exam and final exam to measure learning outcomes, and in-class applications
with the five outcomes that will be followed in reaching the stage of the student.

Language of Instruction

Turkish

Course Policies and Rules

70% of the classes is compulsory to attend. Disciplinary investigation will be
concluded with the opening of any act of dishonesty.

Contact Details for the Lecturer(s)

Ph.D. Özer Kestane
Telefon: +90 232 301 26 21
E-posta:ozer.kestane@deu.edu.tr

Office Hours

Wednesday 16:00-17:00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 2 28
Case study 14 1 14
Preparations before/after weekly lectures 14 3 42
Preparation for midterm exam 1 14 14
Preparation for final exam 1 28 28
Midterm 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 128

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15
LO.11111
LO.21111
LO.31111
LO.41111
LO.511111