dvd-rental

DVD rental database to test purposes

Website for DVD Rental Store made for DBMS Project (CS222)

simulates the “Bouncing DVD Logo”

Production-ready SQL & PostgreSQL lab featuring multi-table relational schema design, advanced analytical queries, window functions, CTEs, conditional aggregations, data modeling, CSV bulk import/export, and Python database connectivity (psycopg2). Includes Shopping Mall, Academic, and Sakila DVD Rental database projects.

Patika.dev SQL Bootcamp — Ödev 11: UNION/INTERSECT/EXCEPT ALL küme işlemleriyle sonuç birleştirme (DVD Rental örnek DB).

Data analysis for the Sakila Database which is a nicely normalised schema modelling a DVD rental store, featuring things like films, actors, film-actor relationships, and a central inventory table that connects films, stores, and rentals using tools like Excel used to view the data and create insert queries for all the tables and then by using SQL

With SQL queries I explore the Sakila DVD Rental database, to present insights about customer behavior and rental patterns.

Patika.dev SQL Bootcamp — Ödev 6: AVG, COUNT, MAX ve DISTINCT toplama fonksiyonlarıyla özet istatistik (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 5: ORDER BY, LIMIT ve OFFSET ile sıralama ve sayfalama (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 1: SELECT/WHERE ve mantıksal operatörlerle filtreleme (DVD Rental örnek DB).

This is the ASP.NET web project based on Entity framework.

Patika.dev SQL Bootcamp — Ödev 7: GROUP BY ve HAVING ile gruplama ve grup bazlı filtreleme (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 12: Skaler alt sorgular (subquery) ve JOIN + GROUP BY ile analiz (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 3: LIKE/ILIKE ve joker karakterlerle desen eşleştirme (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 2: BETWEEN, IN ve AND ile aralık/liste filtreleme (DVD Rental örnek DB).

Patika.dev SQL Bootcamp — Ödev 4: DISTINCT ve COUNT ile benzersiz değerler ve koşullu sayım (DVD Rental örnek DB).

Анализ базы данных DVD Rental с использованием PostgreSQL, SQL, Python, Pandas и Matplotlib