| Learning Outcomes |
PO |
MME |
| The students who succeeded in this course: |
|
|
| LO-1 |
Can establish a database |
PO-16 Make installations, maintenance and checks in database.
|
Examination
|
| LO-2 |
Can do basic table operations |
PO-10 Designs and manages databases
PO-16 Make installations, maintenance and checks in database.
|
Examination
|
| LO-3 |
Can forward to table operations |
PO-10 Designs and manages databases
PO-16 Make installations, maintenance and checks in database.
|
Examination
|
| LO-4 |
Can manage the database server |
PO-10 Designs and manages databases
PO-16 Make installations, maintenance and checks in database.
|
Examination
|
PO: Programme Outcomes
MME:Method of measurement & Evaluation |
| Course Contents |
| Establish a panel, database management, database users to create and define the
Create a database and identify users, identify the tables and diagrams to manage
Data transfer to operations, the existing database, create a new database
Views, triggers, and indexes to edit subroutines
Terms and edit the default values??, data replication operations and maintenance plan to make
Performance analysis and to make improvements |
| Weekly Course Content |
| Week |
Subject |
Learning Activities and Teaching Methods |
| 1 |
At least two different manufacturers to establish an industry standard server software |
Practice writing the program |
| 2 |
Establish a panel, database management, database users to create and define the |
Practice writing the program |
| 3 |
Create a database and identify users, identify the tables and diagrams to manage |
Practice writing the program |
| 4 |
Diagram to identify and manage tables, making the data transfer operations |
Practice writing the program |
| 5 |
Data transfer to operations, the existing database, create a new database
|
Practice writing the program |
| 6 |
Existing database, create a new database, view, triggers, and indexes to edit subroutines |
Practice writing the program |
| 7 |
Views, triggers, and indexes to edit subroutines
|
Practice writing the program |
| 8 |
mid-term exam |
|
| 9 |
Views, triggers, and indexes to edit subroutines, user roles, user-defined data types to edit |
Practice writing the program |
| 10 |
User roles, user-defined data types to edit
|
Practice writing the program |
| 11 |
Terms and edit the default values
|
Practice writing the program |
| 12 |
Terms and edit the default values, data replication operations and maintenance plan to make
|
Practice writing the program |
| 13 |
Operations and maintenance plan to make data replication
|
Practice writing the program |
| 14 |
Performance analysis and to make improvements
|
Practice writing the program |
| 15 |
Performance analysis and to make improvements |
Practice writing the program |
| 16 |
final exam |
|
| Recommend Course Book / Supplementary Book/Reading |
| 1 |
Turgut ÖSEVEN.(2020).Veritabanı Yönetim Sistemleri 2.Ekin Yayınevi |
| 2 |
Çoruh, P. D. M. (2017). Veritabanı:" Felsefesi, Tasarımı ve Yönetimi": MS-Access ve SQL Server Projeleri. eKitap Projesi & Cheapest Books. |
| Required Course instruments and materials |
|
