 |
Description of Individual Course Units| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BİL2009 | DATABASE 2 | Elective | 2 | 3 | 4 |
| | Level of Course Unit | | Short Cycle | | Objectives of the Course | | With this course the student, managing the database and servers aimed to gain relevant qualifications. | | Name of Lecturer(s) | | Lec. Fahri YILMAZ | | Learning Outcomes | | 1 | the database can | | 2 | Basic table operations can | | 3 | Advanced table operations can | | 4 | The database server can manage |
| | Mode of Delivery | | Formal Education | | Prerequisites and co-requisities | | None | | Recommended Optional Programme Components | | None | | Course Contents | | Industry-standard server software, install at least two different manufacturers
Establish a panel database management, database users to create and define the
Create the database and identify users, identify the tables and diagrams to manage
Diagram to identify and manage tables, perform the tasks in the data transfer
Data transfer to operations, the existing database to create a new database
Existing database to create a new database, Views, triggers, and indexes to edit subroutines
Views, triggers, and indexes to edit subroutines, user roles, user-defined data types, edit the
User roles, user-defined data types, edit the
Rule and edit the default values, data replication operations and maintenance plan to do
Data replication operations and maintenance plan to do
Performance analysis and to improve the
| | Weekly Detailed Course Contents | |
| 1 | Industry-standard server software, install at least two different manufacturers | | | | 2 | Establish a panel database management, database users to create and define the | | | | 3 | Create the database and identify users, identify the tables and diagrams to manage | | | | 4 | Diagram to identify and manage tables, perform the tasks in the data transfer
| | | | 5 | Data transfer to operations, the existing database to create a new database | | | | 6 | Existing database to create a new database, Views, triggers, and indexes to edit subroutines
| | | | 7 | Views, triggers, and indexes to edit subroutines | | | | 8 | Middle term exam | | | | 9 | Views, triggers, and indexes to edit subroutines, user roles, user-defined data types, edit the
| | | | 10 | User roles, user-defined data types, edit the | | | | 11 | Rule and edit the default values | | | | 12 | Rule and edit the default values, data replication operations and maintenance plan to do
| | | | 13 | Data replication operations and maintenance plan to do | | | | 14 | Performance analysis and to improve the | | | | 15 | Performance analysis and to improve the | | | | 16 | Fianal Exam | | |
| | Recommended or Required Reading | | The textbook, books and other resources to help | | 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 | 15 | 15 | | Final Examination | 1 | 25 | 25 | | Attending Lectures | 14 | 2 | 28 | | Practice | 14 | 2 | 28 | | Laboratory | 14 | 2 | 28 | |
| Contribution of Learning Outcomes to Programme Outcomes | | LO1 | 4 | | | | | | | | | | 3 | | 3 | | LO2 | 4 | | | | | | | | | | 3 | | 3 | | LO3 | 4 | | | | | | | | | | 3 | | 3 | | LO4 | 4 | | | | | | | | | | 3 | | 3 |
| | * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |
| Yozgat Bozok University, Yozgat / TURKEY • Tel (pbx): +90 354 217 86 01 • e-mail: uo@bozok.edu.tr |
|
|