Information Package
baskent.edu.tr

Master's of Information Technology and System Management with Thesis

BTS542

DATABASE MANAGEMENT SYSTEMS II

Course Code
BTS542
Semester
-
Theory+Practice
3 + 0
ECTS
10
Course TypeElective Course
Course LevelMaster's Degree With Thesis
Year of Study-
Semester-
ECTS10
Name of Lecturer(s) -
Learning Outcomes

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 DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme ComponentsThere is no recommended optional programme component for this course.
Course DescriptionDatabases 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
Recommended or Required Reading1. 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 InstructionTurkish
Work Placement(s)No

Programme Qualifications / Learning Outcomes

LO1 LO2
K1 X
K2
K3 X
K4 X
K5 X
K6 X
K7 X
K8 X X
K9 X X
K10 X
K11