Data Analysis and Database Management with SQL

My medium link to follow the articles with simultaneously. https://mehmetali-kaya.medium.com/

TOPICS THAT I COVERED IN THE MEDIUM ARTICLES

1. BASIC SQL

2. *CASE-WHEN

Medium Link : https://mehmetali-kaya.medium.com/t-sql-ile-case-when-yap%C4%B1s%C4%B1-bf7efd5d6742

3. *Reporting Data With SQL

Medium Link(First Article of Reporting) : https://mehmetali-kaya.medium.com/sql-ile-raporlama-1-b9578272456c

Medium Link(Second Article of Reporting) : https://mehmetali-kaya.medium.com/sql-i%CC%87le-birden-fazla-%C3%B6l%C3%A7%C3%BC-olu%C5%9Fturma-3a1261dcb7e6

4. *Common Table Expressions with SQL

Medium Link: https://mehmetali-kaya.medium.com/sql-ile-multi-level-aggregation-e5caf1d440be

5. *Window Functions With SQL

Medium Link(First Article) : https://mehmetali-kaya.medium.com/sql-i%CC%87le-window-functions-over-3aa175bbe80d

Medium Link(Second Article) : https://mehmetali-kaya.medium.com/sql-i%CC%87le-window-functions-over-ve-partition-by-eafe43a9162e

Medium Link(Third Article) : https://mehmetali-kaya.medium.com/sql-i%CC%87le-window-functions-rank-dense-rank-row-number-ntile-542d98f64f32

6. *LAG, LEAD, FIRST_VALUE, LAST_VALUE

Medium Article : https://mehmetali-kaya.medium.com/window-functions-lead-ve-lag-7bf01cdb6279