Kocaeli University / European Credit Transfer System (ECTS)

Name of Lecturer(s)

Associate Prof. Dr. Özkan KAFADAR
Lecturer NEVIN ANTAR
Lecturer Mustafa OF

Learning Outcomes of the Course Unit
Program Competencies-Learning Outcomes Relation

Learning Outcomes of the Course Unit

1) Explain database concepts.
2) Compare the differences between database users.
3) Express the concept of data independence.
4) Explain to relationship of in database architecture components.
5) Use, explain and sample to relational model concepts.
6) Identify constraints to the relational model, express to using cases.
7) Write queries using the SQL SELECT statement.
8) Write action queries using with SQL INSERT, UPDATE, and DELETE statements.

Program Competencies-Learning Outcomes Relation

Bölümün/programın program yeterlilikleri sistemde olmadığından ilişkilendirme işlemi yapılamamıştır.

Mode of Delivery

e-course

Prerequisites and Co-Requisites

None

Recommended Optional Programme Components

Data Types and Programming

Course Contents

Begining of Database Relational Data Model and SQL Conceptual Database Design Database Normalization Theory Query Processing, Optimization, and Database Tuning Movement Processing and Concurrency Control New Generation Database Applications

Weekly Schedule

1) The concept of database
2) Introduction to structured query language
3) Basic SQL statements
4) Basic functions in the SQL: MIN, MAX, COUNT
5) Average and sum functions in SQL: AVG, SUM
6) Using a nested SELECT command
7) Using a nested SELECT command
8) Midterm examination/Assessment
9) Working with more than one table
10) Working with multiple tables and data
11) Enter data to the database with SQL
12) Updating the data
13) Delete data from table
14) Condition statement in SQL
15) Writing SQL commands for related tables
16) Final examination

Planned Learning Activities and Teaching Methods

1) Lecture
2) Question-Answer
3) Discussion
4) Drill and Practice
5) Demonstration
6) Group Study
7) Simulation
8) Case Study
9) Lab / Workshop
10) Self Study
11) Problem Solving
12) Project Based Learning

Assessment Methods and Criteria

Contribution of Midterm Examination to Course Grade	20%
Contribution of Final Examination to Course Grade	80%
Total	100%

Language of Instruction

Turkish

Work Placement(s)

Not Required

Course Unit Title	Course Unit Code	Type of Course Unit	Level of Course Unit	Year of Study	Semester	ECTS Credits
Database Query Language	BUE237	Elective	Associate degree	2	Spring	4