COURSE INFORMATON
Course Title Code Semester L+P Hour Credits ECTS
DATA BASE II * BPP   222 4 3 3.5 4

Prerequisites and co-requisites
Recommended Optional Programme Components None

Language of Instruction Turkish
Course Level Short Cycle Programmes (Associate's Degree)
Course Type
Course Coordinator Lec. Tacettin TORE
Instructors
Öğr. Gör.TACETTİN TORE1. Öğretim Grup:A
 
Assistants
Goals
To comprehend the logic of client / server database and design client / server database
Content
Basic concepts, Entity-Relationship Model, Relational Database, Normalization, Relational Algebra, SQL, Basic SQL Transactions, Basic SQL Functions, SQL Multiline Function, Tables and properties in data bases

Learning Outcomes
-


Course's Contribution To Program
NoProgram Learning OutcomesContribution
12345

Course Content
WeekTopicsStudy Materials _ocw_rs_drs_yontem
1 The targets, aims of lesson and basic definitions, concepts -there is no need for any preparation
2 Entity-Relationship Model -there is no need for any preparation
3 Relational Database -there is no need for any preparation
4 Normalization -there is no need for any preparation
5 Relational Algebra -there is no need for any preparation
6 SQL CODES -there is no need for any preparation
7 Basic SQL Transactions -there is no need for any preparation
8 Mid-Term Exam -
9 Basic SQL Functions -there is no need for any preparation
10 SQL Multiline Function -there is no need for any preparation
11 Simple Joining the Table -there is no need for any preparation
12 Other Joining the Table -there is no need for any preparation
13 Sub Queries -there is no need for any preparation
14 Data Manuplation Language -there is no need for any preparation
15 Database Objects -there is no need for any preparation
16-17 Term Exams -

Recommended or Required Reading
Textbook
Additional Resources