| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| - | BTP1107 | Turkish | Compulsory | 1. Semester | 3 + 1 | 4.0 | 5.0 |
| Prerequisite Courses | |
| Course Level | Associate |
| Mode of delivery | face to face |
| Course Coordinator | Öğr. Gör. Hüsrev YILDIZ |
| Instructor(s) | Öğr. Gör. Hüsrev YILDIZ (Güz) |
| Goals | The aim of this course is to enable students to gain basic and intermediate level knowledge and skills in relational database design, management and querying. |
| Course Content | Students can install and basic configuration of MSSQL or MySQL database management systems. Students can perform database operations using basic SQL commands. Students can work with multiple tables and use subqueries and data grouping techniques. Students can design a relational database, apply normalization rules, and create a database schema. Students can gain knowledge about database security and user authorization and perform data backup/restore operations. Students can use indexing and query optimization techniques to improve query performance. Students can develop a comprehensive database solution by applying the knowledge they have learned in a real project work. |
| # | Öğrenme Kazanımı |
| 1 | Students can install and basic configuration of MSSQL or MySQL database management systems. |
| 2 | Students can perform database operations using basic SQL commands |
| 3 | Students can work with multiple tables and use subqueries and data grouping techniques. |
| 4 | Students can design a relational database, apply normalization rules, and create a database schema. |
| 6 | Students can add, delete, update and list data in a table. |
| 7 | Students can develop a comprehensive database solution by applying the knowledge they have learned in a real project work. |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | Introduction and Setup | Practice |
| 2. Week | Basic SQL Commands | Practice |
| 3. Week | Selecting and Filtering Data | Practice |
| 4. Week | Advanced Selection Procedures | Practice |
| 5. Week | Working with Multiple Tables | Practice |
| 6. Week | Subqueries and Nested Queries | Practice |
| 7. Week | Data Grouping and Aggregation Functions | Practice |
| 8. Week | Database Design | Practice |
| 9. Week | Storage and Data Backup | Practice |
| 10. Week | Views and Stored Procedures | Practice |
| 11. Week | Triggers and Actions | Practice |
| 12. Week | Security and Authorization | Practice |
| 13. Week | Performance Optimization | Practice |
| 14. Week | Project Work and General Evaluation | Practice |
| No | Program Requirements | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | They have basic, current and practical knowledge about their profession. | ✔ | |||||
| 4 | Uses professional-related information technologies (software, hardware, programs, animations, etc.) effectively. | ✔ | |||||
| 13 | Performs database design and management. | ✔ | |||||
| 14 | Tests software and fixes bugs. | ✔ | |||||
| Program Requirements | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 |
|---|---|---|---|---|---|---|
| PY1 | 1 | 1 | 1 | 1 | 1 | 1 |
| PY4 | 2 | 2 | 2 | 2 | 2 | 2 |
| PY13 | 5 | 5 | 5 | 5 | 5 | 5 |
| PY14 | 3 | 3 | 3 | 3 | 3 | 3 |
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| Güz Dönemi | |||
| Responsible Personnel | Grup | Evaluation Method | Percentage |
|---|---|---|---|
| Öğr. Gör. Hüsrev YILDIZ | Vize | 25.00 | |
| Öğr. Gör. Hüsrev YILDIZ | Quiz | 10.00 | |
| Öğr. Gör. Hüsrev YILDIZ | Ödev | 15.00 | |
| Öğr. Gör. Hüsrev YILDIZ | Final | 50.00 | |
| Toplam | 100.00 | ||
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 4 | 56 |
|
Ders Dışı |
Preparation, After Class Study | 14 | 1 | 14 |
| Research | 10 | 1 | 10 | |
| Other Activities | 8 | 1 | 8 | |
|
Sınavlar |
Midterm 1 | 2 | 1 | 2 |
| Midterm 2 | 5 | 2 | 10 | |
| Final | 2 | 1 | 2 | |
| Total Workload | 102 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 5.0 | ||
