TR EN

ISTANBUL GELİŞİM UNIVERSITY INFORMATION SYSTEM

INTRODUCTION TO DATABASE COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
YBS205 INTRODUCTION TO DATABASE 3 3 3 6

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week Preparatory Topics(Subjects) Method
1 - Introduction to Databases and Basic Concepts Lecture & Discussion & Practice
2 Literature Review Database Management Systems Lecture & Discussion & Practice
3 Literature Review ER (Entity-Relationship) Models and Diagrams Lecture & Discussion & Practice
4 Literature Review Normalization Lecture & Discussion & Practice
5 Literature Review Introduction to Microsoft SQL Server and Basic Commands Lecture & Discussion & Practice
6 Literature Review Data Types and Table Creation Lecture & Discussion & Practice
7 Literature Review Data Update and Deletion Operations (DDL and DML Commands – CREATE, ALTER, DROP, SELECT, INSERT, UPDATE, DELETE) Lecture & Discussion & Practice
8 Literature Review Filtering with WHERE, AND, OR Queries Lecture & Discussion & Practice
9 Literature Review Sorting and Grouping with ORDER BY and GROUP BY Lecture & Discussion & Practice
10 - MID-TERM EXAM -
11 Literature Review Mathematical Functions Lecture & Discussion & Practice
12 Literature Review Join Operations (LEFT JOIN, RIGHT JOIN, and FULL JOIN) Lecture & Discussion & Practice
13 Literature Review Subqueries Lecture & Discussion & Practice
14 Literature Review String Functions Lecture & Discussion & Practice
15 Literature Review Date Functions Lecture & Discussion & Practice
16 - FINAL EXAM -
17 - FINAL EXAM -