At the end of this course, the students; 1) Will be able to understand the basic concepts related with database and its components, 2) Will be able to understand entity-relationship model and draw ER diagram, 3) Will be able to create SQL tables, primary and foreign keys, establish relationship based on a given ER diagram, 4) Will be able to understand SQL commands, complex queries and nested usage of queries, 5) Will be able to apply SQL language for data creation, manipulation, query and creating index in laboratory sessions.
MODE OF DELIVERY
Face to face
PRE-REQUISITES OF THE COURSE
No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
None
COURSE DEFINITION
Main concepts in database, data and data models, relational database, SQL commands and structures, use and development of database management systems.
COURSE CONTENTS
WEEK
TOPICS
1st Week
Introduction to the database (Basic Database Concepts)
2nd Week
Entity Relationship Model
3rd Week
Relational Data Model
4th Week
Relational Database Design
5th Week
Relational Algebra
6th Week
SQL Structured Query Language
7th Week
Using SQL Functions
8th Week
MidTerm Exam
9th Week
Analyzing Data Using Grouping
10th Week
Multiple Tables
11th Week
Complex Queries
12th Week
Project # 1 section
13th Week
Project # 2 section
14th Week
Project # 3 section
RECOMENDED OR REQUIRED READING
1) VERİTABANI SİSTEMLERİ DERSİ - Teoriden Pratiğe, Yrd. Doç. Dr. Nergiz ERÇİL ÇAĞILTAY ve Dr. Gül TOKDEMİR, 2010
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
Lecture,Project,Other
ASSESSMENT METHODS AND CRITERIA
Quantity
Percentage(%)
Mid-term
1
20
Quiz
2
15
Practice
3
25
Project
1
20
Total(%)
80
Contribution of In-term Studies to Overall Grade(%)
80
Contribution of Final Examination to Overall Grade(%)
20
Total(%)
100
LANGUAGE OF INSTRUCTION
Turkish
WORK PLACEMENT(S)
No
KEY LEARNING OUTCOMES (KLO) / MATRIX OF LEARNING OUTCOMES (LO)