| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BLG2092010773 | DATABASE II | Compulsory | 2 | 3 | 4 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| In this course students will gain sufficiencies of managing database and database servers |
| Name of Lecturer(s) |
| Öğr. Gör. Murat ÇETİNKAYA |
| Learning Outcomes |
| 1 | The client / server database software to comprehend the logic of programming. | | 2 | The client / server search a database of hundreds of special (form) can be prepared. | | 3 | Client / server-featured database gains the ability to prepare reports. | | 4 | | | 5 | |
|
| Mode of Delivery |
| Formal Education |
| Prerequisites and co-requisities |
|
| Recommended Optional Programme Components |
|
|
| Course Contents |
| Installing database management system, Making basic table operations, Making advanced table operations, Managing database server |
| Weekly Detailed Course Contents |
|
| 1 | Installing two servers created by different producers compatible with industrial standard | | | | 2 | Installing database management panel, creating database and defining users | | | | 3 | Creating database and defining users, Defining tables and managing diagrams | | | | 4 | Defining tables and managing diagrams, Making data transfer operations | | | | 5 | Making data transfer operations, | | | | 6 | Creating a database from existing database, | | | | 7 | Editing views, triggers, stored procedures and indexes | | | | 8 | Editing views, triggers, stored procedures and indexes | | | | 9 | Editing user roles and user-defined data types | | | | 10 | Editing rules and default values | | | | 11 | Making replication and maintenance plan | | | | 12 | Making replication and maintenance plan | | | | 13 | Making performance analysis and optimizations
| | | | 14 | Making performance analysis and optimizations | | | | 15 | | | | | 16 | | | |
|
| Recommended or Required Reading |
| Course book, auxiliary book and other sources |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| SUM | 0 | |
| SUM | 0 | | Yarıyıl (Yıl) İçi Etkinlikleri | 40 | | Yarıyıl (Yıl) Sonu Etkinlikleri | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 2 | 2 |
| Attending Lectures | 14 | 4 | 56 |
| Self Study | 13 | 3 | 39 |
| Individual Study for Homework Problems | 5 | 2 | 10 |
| Individual Study for Mid term Examination | 2 | 2 | 4 |
| Individual Study for Final Examination | 4 | 2 | 8 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 4 | | | 5 | | | | | | | | | | | | | | | | | | | | | | | | | | LO2 | | | 4 | | | | | | | | | | | | 5 | | | | | | | | | | | | | | | LO3 | | | | 5 | | | | | | | 5 | | | | | | | | | | | | | | | | | | | LO4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | LO5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|
|
|
Ordu University Rectorate Building ,Cumhuriyet Campus , Center / ORDU / TURKEY • Tel: +90 452 226 52 00
|