Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
3BIL 205Veri Tabanı Uygulamaları1+2+02303.08.2026
Course Details
Language of Instruction Turkish
Level of Course Unit Associate Degree
Department / Program Web Design and Development
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course The aim of this course is to provide students with the knowledge and skills required to design, develop, and manage relational database systems, develop database applications using SQL, and effectively perform database management processes.
Course Content This course covers the fundamental concepts of database systems, DBMS architecture, and data types. Basic and advanced SQL queries (SELECT, INSERT, UPDATE, DELETE, JOIN, GROUP BY, and subqueries) are implemented through practical applications. Database design based on ER diagrams and normalization principles, stored procedures, views, indexes, triggers, transaction management based on ACID principles, user authorization, data security, backup, and recovery are also covered.
Course Methods and Techniques Lecture
Question and Answer
Laboratory Practice
Demonstration
Computer-Assisted Instruction
Problem Solving
Case Study
Individual Practice
Project-Based Learning
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Instructor filiz gürbüz
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Ayık, Y. Z. Veri Tabanlarında Bilgi Yönetimi, Güvenlik ve Performans. Nobel Bilimsel Eserler. Kıran, S. (2021). İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme. Ankara: Nobel Akademik Yayıncılık. Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson. Microsoft. (2024). SQL Server Documentation. https://learn.microsoft.com/sql
Course Notes Lecture notes and laboratory worksheets prepared by the instructor.
Microsoft SQL Server and SQL Server Management Studio (SSMS) documentation.
Sample databases, SQL applications, and project files.
Microsoft Learn SQL Server documentation and supplementary digital learning materials.


Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 30
Assignment 1 % 20
Final examination 1 % 50
Total
3
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Assignments 1 7 7
Mid-terms 1 7 7
Laboratory 12 2 24
Final examination 1 10 10
Total Work Load   Number of ECTS Credits 3 90

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
2 Applies basic data querying and data manipulation operations (SELECT, INSERT, UPDATE, DELETE) using SQL.
3 Performs  JOIN  operations, subqueries, and grouping operations on multiple tables.
4 Designs relational databases by creating Entity–Relationship (ER) diagrams and applying normalization rules.
5 Creates and manages database objects such as stored procedures, views, indexes, and triggers.
6 Ensures data integrity by applying transaction management and ACID principles.
7 Plans and implements user authorization, security, backup, and recovery procedures.
Bilgi 
1 Explains the fundamental concepts of database systems, DBMS architecture, and data types.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Database Fundamentals Review the fundamental concepts related to database fundamentals. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
2 Basic SQL Queries Review the fundamental concepts related to basic sql queries. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
3 Advanced SQL Queries Review the fundamental concepts related to advanced sql queries. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
4 Database Design and Normalization Review the fundamental concepts related to database design and normalization. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
5 Fundamentals of Database Security Review the fundamental concepts related to fundamentals of database security. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
6 Database Security Threats Review the fundamental concepts related to database security threats. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
7 Database Backup and Recovery Review the fundamental concepts related to database backup and recovery. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
8 Midterm Examination Review the topics covered in previous weeks. Lecture notes, sample questions, and review materials.
9 Database Auditing and Monitoring Review the fundamental concepts related to database auditing and monitoring. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
10 Data Privacy and Encryption Review the fundamental concepts related to data privacy and encryption. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
11 Database Penetration Testing Review the fundamental concepts related to database penetration testing. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
12 Application Development and Database Security Review the concepts covered in previous weeks. Sample applications, lecture notes, and study materials.
13 Database Security Standards and Compliance Review the fundamental concepts related to database security standards and compliance. Lecture slides, practice notes, sample SQL scripts, and technical documentation.
14 Sample Application Review the concepts covered in previous weeks. Sample applications, lecture notes, and study materials.
15 General Review Review the concepts covered in previous weeks. Sample applications, lecture notes, and study materials.
16 Final Examination Review the topics covered in previous weeks. Lecture notes, sample questions, and review materials.

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 P13 P14 P15 P16
C2 5 5 5 5 5 5
C3 5 5 5 5 5 5
C4 5 5 5 5 5 5
C5 5 5 5 5 5 5
C6 5 5 5 5 5 5
C7 5 5 5 5 5 5
In1 5 5 5 5 5 5

  Contribution: 1: Very Slight 2:Slight 3:Moderate 4:Significant 5:Very Significant