| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BT205B3 | Database II | Compulsory | 2 | 3 | 5 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| This course aims to acquire competencies related to managing students, databases and servers. |
| Name of Lecturer(s) |
| Öğr. Gör. Ahmet DEVELİ |
| Learning Outcomes |
| 1 | Create Database Management System | | 2 | Understanding transaction processes | | 3 | Learning user defined functions on database | | 4 | Learning database triggers | | 5 | Database server to manage. |
|
| Mode of Delivery |
| Normal Education |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| Defining tables and managing diagrams, Defining tables and managing diagrams, Performing data transfer operations, Creating new database from existing database, Creating new database from existing database, Creating database and defining users, Defining tables and managing diagrams, Defining tables and managing diagrams Create database, view, trigger, subprograms and indexes, organize user roles, user defined data types, organize rules and default values, perform data replication operations and maintenance plan, perform performance analysis and improvements |
| Weekly Detailed Course Contents |
|
| 1 | Establish server software of at least two different industry standard industry vendors | Establish server software of at least two different industry standard industry vendors | Establish server software of at least two different industry standard industry vendors | | 2 | To set up database administration panel, to create database and to define users. | To set up database administration panel, to create database and to define users. | To set up database administration panel, to create database and to define users. | | 3 | Database transaction processes | Database transaction processes | Database transaction processes | | 4 | Database programming | Database programming | Database programming | | 5 | Database programming | Database programming | Database programming | | 6 | Database programming | Database programming | Database programming | | 7 | Database programming | Database programming | Database programming | | 8 | Midterm | | | | 9 | Learning database triggers | Learning database triggers | Learning database triggers | | 10 | Learning database triggers | Learning database triggers | Learning database triggers | | 11 | Semistructure data models, XML | Semistructure data models, XML | Semistructure data models, XML | | 12 | XML,XPATH | XML,XPATH | XML,XPATH | | 13 | XML, XPATH programming | XML, XPATH programming | XML, XPATH programming | | 14 | New generation Database Systems (NoSQL) | New generation Database Systems (NoSQL) | New generation Database Systems (NoSQL) | | 15 | Performing performance analysis and improvements | | | | 16 | Final Exam | | |
|
| Recommended or Required Reading |
| Veri Tabanı Yönetim Sistemleri - II – Turgut ÖZSEVEN
Veri Tabanı Yönetim Sistemleri PostreSQL- Yasin TATAR, Ahmet FİNCAN |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| Midterm Examination | 1 | 100 | | SUM | 100 | |
| Final Examination | 1 | 100 | | SUM | 100 | | Term (or Year) Learning Activities | 40 | | End Of Term (or Year) Learning Activities | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | | None |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 2 | 2 |
| Attending Lectures | 14 | 4 | 56 |
| Practice | 14 | 2 | 28 |
| Self Study | 14 | 2 | 28 |
| Individual Study for Mid term Examination | 7 | 2 | 14 |
| Individual Study for Final Examination | 7 | 3 | 21 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 3 | 4 | 3 | 5 | 3 | 5 | 1 | 5 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | | LO2 | 5 | 4 | 3 | 1 | 3 | 5 | 1 | 5 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | | LO3 | 5 | 4 | 3 | 1 | 3 | 5 | 1 | 5 | 4 | 1 | 1 | 4 | 1 | 1 | 1 | | LO4 | 5 | 4 | 3 | 1 | 3 | 5 | 1 | 5 | 4 | 1 | 1 | 4 | 1 | 1 | 1 | | LO5 | 5 | 4 | 5 | 5 | 3 | 5 | 1 | 5 | 4 | 1 | 1 | 4 | 1 | 1 | 1 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |