TYPE OF COURSE UNIT	Elective Course
LEVEL OF COURSE UNIT	Master's Degree With Thesis
YEAR OF STUDY	-
SEMESTER	-
NUMBER OF ECTS CREDITS ALLOCATED	10
NAME OF LECTURER(S)	-
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Are expected to master on SQL and have the knowledge to develop and administer databases on any platform.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	There is no recommended optional programme component for this course.
COURSE DEFINITION	Databases. Relational databases. Tables. Structured Query Language (SQL), Entering Information, Extracting Information, Advanced Database Design, Manipulating Data, Grouping and Aggregating Data, Selecting Data from Different Tables, Queries within Queries, Advanced Queries, Views, Transactions, SQL Security, Database Tuning.
COURSE CONTENTS	WEEK TOPICS 1st Week Database concepts and types of databases 2nd Week Relational databases 3rd Week Storing and Retreving data 4th Week SQL 5th Week Data Manipulation 6th Week SQL operators and functions 7th Week Oracle SQL*Plus 8th Week MIDTERM 9th Week PL/SQL 10th Week Oracle Installation, Configuration and Building 11th Week Developing Data Models 12th Week Designing a Database's Structure 13th Week Normalization 14th Week Database Tools
RECOMENDED OR REQUIRED READING	George Koch - Kevin Loney : Oracle The Complete Reference, Osborne McGraw-Hill, NewYork, 1997. Dwight Cheu - Brian Linden: SQL Language Reference, Oracle, Ireland, 1990.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Questions/Answers,Problem Solving,Other
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Assignment 1 10 Project 1 10 Total(%) 50 Contribution of In-term Studies to Overall Grade(%) 50 Contribution of Final Examination to Overall Grade(%) 50 Total(%) 100
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No