| Course Type | Elective Course |
|---|
| Course Level | Associate Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Basic concepts of relational databases and their role in information management will be understood.
- Students will gain competence in writing SQL queries to retrieve, manipulate and manage data in relational databases.
- Gain the ability to design and implement normalized relational database schemas.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | - |
|---|
| Course Description | The course aims to teach relational database concepts, SQL querying, database design, management and security, and to provide students with a basic understanding of database management systems. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Introduction to Databases and Database Management Systems |
|
2nd Week |
Relational Database Basics |
|
3rd Week |
SQL Basics and Data Retrieval |
|
4th Week |
SQL Queries: Joins and Subqueries |
|
5th Week |
SQL Queries: Aggregation and Grouping |
|
6th Week |
Database Design: Normalization |
|
7th Week |
Database Design: Entity-Relationship Modeling |
|
8th Week |
Midterm Exam |
|
9th Week |
Database Management: Backup and Recovery |
|
10th Week |
Database Management: Performance Tuning |
|
11th Week |
Database Security: Access Control |
|
12th Week |
Database Security: Encryption |
|
13th Week |
Advanced Database Concepts: Transactions and Concurrency Control |
|
14th Week |
Advanced Topics in Database Management |
|
| Recommended or Required Reading | |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Discussion
- Questions/Answers
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
40 |
| Total(%) |
|
40 |
| Contribution of In-term Studies to Overall Grade(%) |
|
40 |
| Contribution of Final Examination to Overall Grade(%) |
|
60 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
1 |
1 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
14 |
3 |
42 |
| Preparation for Final exam |
14 |
2 |
28 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
14 |
2 |
28 |
| Laboratory (including preparation) |
|
|
|
| Final exam |
1 |
1 |
1 |
| Homework |
|
|
|
| Total Work Load | 142 |
| Total Work Load / 30 (h) | 4.73 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
