COURSE UNIT TITLE

: DATABASE 2

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BLP 4110 DATABASE 2 COMPULSORY 3 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 View. Triggers. Creating subprograms. Defining users. Modifying data types
7 Midterm Exam.
8 Midterm Exam.
9 Define indexes. Defining users. Modifying data types
10 Modifying constant datatypes
11 Modifying constant datatypes. Data multiplication processes. Prepare maintenance plan.
12 Data multiplication processes. Prepare maintenance plan.
13 Performance analysis and upgrade
14 Performance analysis and upgrade

Recomended or Required Reading

The main source:Veri Tabanı ve Yönetimi, A.M. Ateş,Ö.Kestane, C.E.S. Enternasyonel Bookstore, Izmir, 2004.
Auxiliary source: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.
Other course materials: Database servers.

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


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

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 12 3 36
Case study 12 1 12
Preparations before/after weekly lectures 12 2 24
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) 116

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