| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| - | BTP1107 | 1. Semester | 3 + 1 | 4.0 | 5.0 |
| Prerequisite Courses | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | face to face |
| Course Coordinator |
Lect. Hüsrev YILDIZ |
| Instructor(s) |
Hüsrev YILDIZ |
| Assistants | |
| 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. |
| Learning Outcomes |
- 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 add, delete, update and list data in a table. - 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 | Course Hours Practice |
| 2. Week | Basic SQL Commands | Practice Course Hours |
| 3. Week | Selecting and Filtering Data | Course Hours Practice |
| 4. Week | Advanced Selection Procedures | Course Hours Practice |
| 5. Week | Working with Multiple Tables | Course Hours Practice |
| 6. Week | Subqueries and Nested Queries | Practice Course Hours |
| 7. Week | Data Grouping and Aggregation Functions | Course Hours Practice |
| 8. Week | Database Design | Course Hours Practice |
| 9. Week | Storage and Data Backup | Course Hours Practice |
| 10. Week | Views and Stored Procedures | Course Hours Practice |
| 11. Week | Triggers and Actions | Course Hours Practice |
| 12. Week | Security and Authorization | Course Hours Practice |
| 13. Week | Performance Optimization | Course Hours Practice |
| 14. Week | Project Work and General Evaluation | Course Hours Practice |
| Özseven T.,Veritabanı Yönetim Sistemleri 1, Murathan Yayınevi, Trabzon |
| www.w3schools.com |
| Veritabanı ve Uygulamaları, Papatya Yayınevi |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | Measurement Method |
|---|---|---|---|---|---|---|---|---|
| PY1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 40,60 |
| PY4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 40,60 |
| PY13 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY14 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 40,60 |
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Course Hours | 14 | 4 | 56 |
| Preparation, After Class Study | 14 | 1 | 14 |
| Research | 10 | 1 | 10 |
| Other Activities | 8 | 1 | 8 |
| Midterm 1 | 2 | 1 | 2 |
| Midterm 2 | 5 | 2 | 10 |
| Final | 2 | 1 | 2 |
| Total Workload | 102 | ||
| ECTS Credit of the Course | 5.0 | ||
