This repository contains my daily SQL practice exercises and notes throughout my learning journey. Queries are added gradually over time.
The purpose of this work is to build and reinforce a solid understanding of fundamental SQL concepts using a single sample table.
- SELECT / TOP
- ORDER BY
- DISTINCT
- WHERE
- LIKE
- AND / OR / NOT
- INSERT INTO
- UPDATE
- DELETE
- NULL kontrolleri (IS NULL / IS NOT NULL)
- DROP TABLE
- Aggregate Fonksiyonları (MIN, MAX, COUNT, SUM, AVG)
- IN / NOT IN
- IN (SELECT) – Alt sorgular (Subqueries)
- BETWEEN
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- UNION / UNION ALL
- GROUP BY
- HAVING
- CASE / WHEN / THEN
- Constraints(Kısıtlamalar) - (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, DEFAULT)
- ALTER TABLE (ADD, DROP, ALTER COLUMN)
- TRUNCATE TABLE
- Tarih ve Zaman Fonksiyonları (DATENAME, DATEPART vb.)
- İç İçe Sorgular ve Türetilmiş Tablolar (Derived Tables)