| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| - | BTG1107 | 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. Adem OKUMUŞ, Öğr. Gör. Tuba PALA |
| Instructor(s) | Öğr. Gör. Adem OKUMUŞ (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 | |
| 2. Week | Basic SQL Commands | |
| 3. Week | Selecting and Filtering Data | |
| 4. Week | Advanced Selection Procedures | |
| 5. Week | Working with Multiple Tables | |
| 6. Week | Subqueries and Nested Queries | |
| 7. Week | Data Grouping and Aggregation Functions | |
| 8. Week | Database Design | |
| 9. Week | Storage and Data Backup | |
| 10. Week | Views and Stored Procedures | |
| 11. Week | Triggers and Actions | |
| 12. Week | Security and Authorization | |
| 13. Week | Performance Optimization | |
| 14. Week | Project Work and General Evaluation |
| Program Requirements | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 |
|---|
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Sınavlar |
Midterm 1 | 2 | 1 | 2 |
| Midterm 2 | 5 | 2 | 10 | |
| Final | 2 | 1 | 2 | |
| Total Workload | 14 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 5.0 | ||
