Oracle PL/SQL syntax'ı kullanılmıştır. Temel SQL konseptleri tüm veritabanı sistemleri için geçerlidir.
| Gün | Konu | Dosya |
|---|---|---|
| 🗓️ Gün 1 | Veritabanı Temelleri, DBMS, Primary/Foreign Key | Gun_01 |
| 🗓️ Gün 2 | SQL Veri Tipleri, CREATE TABLE, INSERT INTO | Gun_02 |
| 🗓️ Gün 3 | UPDATE SET, DELETE, TRUNCATE, DROP, SELECT, WHERE | Gun_03 |
| 🗓️ Gün 4 | ORDER BY, ALIASES, GROUP BY, HAVING | Gun_04 |
| 🗓️ Gün 5 | UNION, INTERSECT, MINUS, JOINS, SELF JOIN | Gun_05 |
| 🗓️ Gün 6 | EXISTS, BETWEEN, Wildcards, REGEXP_LIKE | Gun_06 |
| 🗓️ Gün 7 | PIVOT, DISTINCT, ALTER TABLE | Gun_07 |
| 🗓️ Gün 8 | ROWNUM, OFFSET FETCH, MOD, İleri Sorgular | Gun_08 |
| 🗓️ Gün 9 | Genel Tekrar & Kapsamlı Alıştırmalar | Gun_09 |
Gün 1: Temel Kavramlar (DB, DBMS, Keys)
↓
Gün 2: Tablo Oluşturma (CREATE, INSERT)
↓
Gün 3: Veri İşleme (UPDATE, DELETE, SELECT)
↓
Gün 4: Gruplama (ORDER BY, GROUP BY, HAVING)
↓
Gün 5: Birleştirme (UNION, JOINS)
↓
Gün 6: Filtreleme (EXISTS, BETWEEN, Wildcards)
↓
Gün 7: Gelişmiş İşlemler (PIVOT, ALTER TABLE)
↓
Gün 8: İleri Düzey Sorgular
↓
Gün 9: 🎉 Genel Tekrar
Oracle PL/SQL syntax is used. Core SQL concepts apply to all database systems.
| Day | Topic | File |
|---|---|---|
| 🗓️ Day 1 | Database Fundamentals, DBMS, Primary/Foreign Key | Day_01 |
| 🗓️ Day 2 | SQL Data Types, CREATE TABLE, INSERT INTO | Day_02 |
| 🗓️ Day 3 | UPDATE SET, DELETE, TRUNCATE, DROP, SELECT, WHERE | Day_03 |
| 🗓️ Day 4 | ORDER BY, ALIASES, GROUP BY, HAVING | Day_04 |
| 🗓️ Day 5 | UNION, INTERSECT, MINUS, JOINS, SELF JOIN | Day_05 |
| 🗓️ Day 6 | EXISTS, BETWEEN, Wildcards, REGEXP_LIKE | Day_06 |
| 🗓️ Day 7 | PIVOT, DISTINCT, ALTER TABLE | Day_07 |
| 🗓️ Day 8 | ROWNUM, OFFSET FETCH, MOD, Advanced Queries | Day_08 |
| 🗓️ Day 9 | General Review & Comprehensive Exercises | Day_09 |
Day 1: Core Concepts (DB, DBMS, Keys)
↓
Day 2: Table Creation (CREATE, INSERT)
↓
Day 3: Data Manipulation (UPDATE, DELETE, SELECT)
↓
Day 4: Grouping (ORDER BY, GROUP BY, HAVING)
↓
Day 5: Combining (UNION, JOINS)
↓
Day 6: Filtering (EXISTS, BETWEEN, Wildcards)
↓
Day 7: Advanced Operations (PIVOT, ALTER TABLE)
↓
Day 8: Advanced Queries
↓
Day 9: 🎉 General Review
git clone https://github.com/pinhanderler/SQL-Notes.git
cd SQL-Notes
# Türkçe notlar
cd Turkish
# English notes
cd English💡 GitHub'da direkt tarayıcıdan okuyabilirsiniz! You can read directly in your browser on GitHub!
Gamzenur Uzunlu Data Engineer | SQL Notes
⭐ Faydalı bulduysan star ver! / Star if you found it useful!