{"repo":"Dogkann/sql-calisma-ornekleri","free":true,"listed":false,"github":"https://github.com/Dogkann/sql-calisma-ornekleri","clone":"git clone https://github.com/Dogkann/sql-calisma-ornekleri.git","description":"Örnek SQL sorguları, T-SQL pratikleri ve Northwind veritabanı çalışmaları.","language":"TSQL","stars":254,"topics":["coding","database","northwind","sql","tsql"],"license":null,"category":"databases-storage","readme_excerpt":"🗄️ SQL & Database Study Library This repository contains queries, database designs, and complex T-SQL examples developed during my SQL learning journey. It is created both as a guide for beginners and to track my own progress.. 🗺️ Database Architecture (ER Diagram) --- 🚀 Table of Contents - 📚 SQL Cheat Sheet: A comprehensive reference guide covering fundamental to advanced SQL commands (SELECT, JOINS, DDL, CTEs, Window Functions). - 📊 Basic Queries: Usage of SELECT , WHERE , and ORDER BY . - 🔗 Table Joins: Scenarios for INNER JOIN , LEFT JOIN , and RIGHT JOIN . - 🛠️ Data Management: INSERT , UPDATE , and DELETE operations. - 🧠 Advanced SQL: Examples of Stored Procedures , Triggers , and Views . - 🗃️ Project Applications: Northwind samples and custom database blueprints. - 🔌 Backend Integration: Guide on connecting to SQL Server via C# (.NET) and Node.js. - 🛠️ Advanced Level: Examples of automated inventory tracking (Trigger) and dynamic reporting (Stored Procedure). --- 🛠️ Advanced Scenarios Automation: TR UpdateStock trigger structure designed for inventory tracking. Reporting: SP GetYearlyReport procedure for extracting annual sales analytics. Security: User authorization and Role-Based Access Control (RBAC) examples. --- 🛠️ Tech Stack --- 📖 How to Use 1. You can Fork this repository using the button in the top right corner. 2. Run the .sql files within the folders in any SQL editor (SSMS, Azure Data Studio, etc.). 3. Develop your own queries based on the prov","default_branch":null,"files":null,"tree":[],"storefront":"/r/Dogkann","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Dogkann/sql-calisma-ornekleri/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}