This repository contains various database management and security projects built using Microsoft SQL Server.
📊 Common Dataset Used: All projects are based on the Airbnb Open Data dataset from Kaggle, which includes property listings, host details, prices, availability, and review data.
-
Database Performance Optimization and Monitoring
SQL query optimization, index tuning, DMV monitoring, and performance analysis techniques. -
Database Security and Access Control
Implementation of SQL injection prevention, user access control, authentication, and permission management. -
ETL Processes and Data Cleaning
Full ETL pipeline implementation using T-SQL: data loading, cleaning, transformation, and reporting. -
Project 4 – General SQL Tasks: Project-4.sql
Includes foundational SQL operations for table creation, data manipulation, and querying. -
Project 5 – Backup and Disaster Recovery: Proje-5.sql
Scheduled full, differential, and transaction log backups using SQL Server Agent. -
Project 6 – User and Role Management: Proje-6.sql
Creating logins, users, database roles, and granting/revoking permissions securely. -
Project 7 – Security Policies and Auditing: Proje-7.sql
Defining security policies, auditing schema changes, and login tracking.
Each project folder or SQL script includes well-documented T-SQL code and real-world use cases tailored for database management education and hands-on practice.