Duyurular & Dokümanlar

Deney Föyü 3

Database Management Systems - Student Workbook 1
Deney Föyü
1.09.2025

This workbook contains 20 applied SQL scenarios designed for in-class practice and self-study. Each section presents a realistic business or database scenario, provides detailed explanations, and leaves space for you to write the SQL statement. All scenarios are based on the W3Schools Sample Database.


Database Management Systems - Student Workbook 2
Deney Föyü
1.09.2025

In this lab, you will build a complete course registration system using SQLite. You will:

  • Create tables with primary and foreign keys,
  • Model many-to-many relationships,
  • Insert and query data,
  • Modify a schema using ALTER TABLE,
  • Add a new related table and update existing ones.

Database Management Systems- Transaction and Concurrency Control
Deney Föyü
1.09.2025

The objective of this laboratory session is to examine Transaction management, ACID principles, and Locking mechanisms on PostgreSQL. Students will observe how the database handles concurrent access, conflicts, and isolation anomalies through practical scenarios.


Sunum 1

KPDS - Student Guidance
Sunum
2.09.2024

Career Path & Planning Course guidance for students.