COURSE INFORMATON
Course Title Code Semester L+P Hour Credits ECTS
Database-II * BPP   219 3 2 2.5 3

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. Mesut ÖZONUR
Instructors
Öğr. Gör.MESUT ÖZONURUzaktan Öğ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, Simple Joining the Table, Other Joining the Table, Sub Queries, Data Manuplation Language, Database Objects.

Learning Outcomes
-


Course's Contribution To Program
NoProgram Learning OutcomesContribution
12345

Course Content
WeekTopicsStudy Materials _ocw_rs_drs_yontem
1 Basic concepts Reading and understanding of the issues before the course.
2 Entity-Relationship Model Reading and understanding of the issues before the course.
3 Relational Database Reading and understanding of the issues before the course.
4 Normalization Reading and understanding of the issues before the course.
5 Relational Algebra Reading and understanding of the issues before the course.
6 SQL - Structured Query Language Reading and understanding of the issues before the course.
7 Basic SQL Transactions Reading and understanding of the issues before the course.
8 Mid-Term Exam Multiple Choice, Text, True / False or Open Ended Exam
9 Basic SQL Functions Reading and understanding of the issues before the course.
10 SQL Multiline Function Reading and understanding of the issues before the course.
11 Simple Joining the Table Reading and understanding of the issues before the course.
12 Other Joining the Table Reading and understanding of the issues before the course.
13 Sub Queries Reading and understanding of the issues before the course.
14 Data Manuplation Language Reading and understanding of the issues before the course.
15 Database Objects Reading and understanding of the issues before the course.
16-17 Term Exams Multiple Choice, Text, True / False or Open Ended Exam

Recommended or Required Reading
Textbook
Additional Resources