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) Will have learned the core of database management systems. 2) Are expected to be able to install, connect and maintain the ORACLE database.
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 on Networks. Object databases. XML databases. Applications.
COURSE CONTENTS	WEEK TOPICS 1st Week Connecting DB 2nd Week Oracle Installation and DB Creation 3rd Week Database Vs Instances 4th Week Starting up and shutdown the installation files 5th Week Managing Tables, viewers, constraints and sequences 6th Week Exporting/Importing databases, schemas, tables 7th Week PL/SQL Basics 8th Week ARASINAV I 9th Week Procedures/Functions 10th Week Managing Packages 11th Week Managing UNDO Segments 12th Week Tables 13th Week Creating, Altering and Dropping users 14th Week Oracle Security
RECOMENDED OR REQUIRED READING	1. Iggy Fernandez, Beginning Oracle Database 11g Administration: From Novice to Professional, Apress; 1 edition, 2009, ISBN: 978-1590599686. 2. Thomas Kyte, Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions, Apress; 2 edition, 2010, ISBN: 978-1430229469. 3. Joan Casteel, Oracle 11G: SQL, Course Technology; 2 edition, 2009, ISBN: 978-1439041284. 4. Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi, Prentice Hall; 10 edition, 2010, ISBN: 978-0136088394. 5. Carlos Coronel, Steven Morris, Peter Rob, Database Systems: Design, Implementation, and Management, Course Technology; 9 edition, 2009, ISBN: 978-0538469685. 6. Sam Alapati, Expert Oracle Database 11g Administration, Apress; 1 edition, 2008, ISBN: 978-1430210153. 7. Steven Feuerstein, Bill Pribyl, Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2, O'Reilly Media; Fifth Edition edition, 2009, ISBN: 978-0596514464. 8. Web Sitelerindeki Kaynaklar.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Questions/Answers,Problem Solving
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