| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database Management Systems II | BLG1252 | 2. Semester | 2 + 2 | 3.0 | 5.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | Online |
| Course Coordinator |
Lect. Adem OKUMUŞ |
| Instructor(s) |
Tuba PALA |
| Assistants | |
| Goals | The aim of the course is to teach the basic concepts of database, the principles of relational data model, relational database design, creating and using database objects. In this course, students will learn how to design a database step by step. |
| Course Content | Database Management Systems and Basic Concepts, Data Models, Relational Database Model, Entity-Relationship Model, Database Tables, SQL Structured Query Language, SQL Operators, Advanced SELECT Queries, Virtual Tables, Advanced Operators, SQL Functions, DML Operations, TSQL Expressions, User Defined Functions, Stored Procedures, Views Triggers. |
| Learning Outcomes |
- Knows the basics of database - Database Design - Creates/Uses Database Objects - Knows/Uses Structured Query Language |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Basic concepts | |
| 2. Week | DDL, DML and Arithmetic Operators | |
| 3. Week | Ready Functions | |
| 4. Week | Merge Tables | |
| 5. Week | Grouping | |
| 6. Week | Subqueries | |
| 7. Week | Views | |
| 8. Week | Temporary Tables and Merging Query Results | |
| 9. Week | Procedural Structures | |
| 10. Week | Stored Procedures | |
| 11. Week | Triggers | |
| 12. Week | Functions | |
| 13. Week | Error Management, Backup and Restore | |
| 14. Week | Project Presentations |
| SQL Server 2017; İsmail ADAR; Abaküs |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | Measurement Method |
|---|---|---|---|---|---|---|
| PY1 | 5 | 0 | 0 | 0 | 0 | - |
| PY10 | 5 | 0 | 0 | 0 | 0 | - |
| PY11 | 5 | 0 | 0 | 0 | 0 | - |
| PY12 | 2 | 0 | 0 | 0 | 0 | - |
| PY13 | 3 | 0 | 0 | 0 | 0 | - |
| PY15 | 5 | 0 | 0 | 0 | 0 | - |
| PY16 | 5 | 0 | 0 | 0 | 0 | - |
| 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) |
|---|---|---|---|
| Midterm 1 | 1 | 12 | 12 |
| Final | 1 | 20 | 20 |
| Practice | 1 | 40 | 40 |
| Classroom Activities | 14 | 4 | 56 |
| Total Workload | 128 | ||
| ECTS Credit of the Course | 5.0 | ||
