Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
2BIL 104Veri Tabanı Temelleri2+2+03531.07.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 enable students to understand the fundamental concepts of database management systems and the principles of relational database design, to acquire the skills to create, manage, and query databases using SQL Server, and to perform data definition, data manipulation, and data control operations with SQL while developing database applications.
Course Content This course covers database concepts, database management systems, database design, the entity–relationship model, and normalization. Students learn the installation and use of SQL Server, SQL data types, data integrity, and constraints. SQL Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) commands are applied. Querying single and multiple tables, functions, grouping operations, and subqueries are practiced through hands-on applications.
Course Methods and Techniques Lecture
Question and Answer
Demonstration
Laboratory Practice
Computer-Assisted Instruction
Problem Solving
Individual Practice
Case Study
Project and Application Development
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Instructor Filiz GÜRBÜZ https://ankarabilim.edu.tr/meslek-yuksekokulu/akademik/akademik-kadro filiz.gurbuz@ankarabilim.edu.tr
Instructor Emine İŞCAN https://ankarabilim.edu.tr/meslek-yuksekokulu/akademik/akademik-kadro emine.ozdamar@ankarabilim.edu.tr
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Kıran, S. (2021). İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme. Ankara: Nobel Akademik Yayıncılık.
Microsoft. (2024). SQL Server Documentation. https://learn.microsoft.com/sql
Date, C. J. (2019). An Introduction to Database Systems. Pearson.
Course Notes Lecture notes and presentations prepared by the course instructor.
Laboratory manuals and SQL Server examples.
Microsoft SQL Server Management Studio (SSMS) instructional materials.
Supplementary documents and sample databases.

Course Category
Mathematics and Basic Sciences %0
Engineering %20
Engineering Design %10
Social Sciences %0
Education %0
Science %0
Health %0
Field %70

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
Quizzes 1 % 20
Final examination 1 % 50
Total
3
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 1 14
Hours for off-the-c.r.stud 3 4 12
Assignments 1 1 1
Mid-terms 1 14 14
Practice 3 10 30
Laboratory 14 3 42
Final examination 1 17 17
Total Work Load   Number of ECTS Credits 5,09803921568627 130

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Explains the fundamental concepts, components, and purposes of database systems.
2 Explains the data models used in database design.
3 Applies normalization rules in database design.
4 Creates Entity–Relationship (ER) diagrams and transforms them into logical data models.
5 Creates database objects using a Database Management System (DBMS).
6 Performs data operations on databases using SQL commands.
7 Manages database objects and performs fundamental database applications.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 General Structure of Databases and Introduction to Database Software Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
2 Data Models Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
3 Entity–Relationship (ER) Diagrams Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
4 Relationship Types and Associations Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
5 Transformation from Conceptual Model to Logical Model Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
6 Normalization Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
7 Introduction to SQL and Database Server Installation Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
8 Midterm Exam Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
9 Basic SQL Commands (SELECT and INSERT) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
10 Basic SQL Commands (UPDATE and DELETE) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
11 Basic SQL Commands (ORDER BY, ASC, and DESC) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
12 Basic SQL Commands (WHERE, AND, and OR) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
13 Basic SQL Commands (ALTER TABLE and DROP TABLE) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
14 Basic SQL Commands (VIEW) Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
15 SQL Practice Applications Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.
16 Final Exam Review of the lecture notes and recommended references for the relevant week. Lecture slides, practice notes, sample applications, and digital course materials.

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

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