SQL Practice Queries

Project Overview

This project contains SQL practice queries developed using PostgreSQL to strengthen SQL fundamentals through hands-on practice. It covers SQL concepts from basic to intermediate level with well-organized query files designed for learning, practice, and portfolio development.

---

Topics Covered

• Database Creation
• Database Operations
• Data Manipulation
• Basic SQL Queries
• Aggregate Functions
• SQL Joins
• Set Operators
• Subqueries & Common Table Expressions (CTEs)
• Window Functions
• String & Date Functions
• Views

---

Database Tables

• Departments
• Employees
• Customers
• Products
• Orders
• Sales

---

SQL Concepts Used

• SELECT
• WHERE
• ORDER BY
• LIMIT & OFFSET
• GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN
• SELF JOIN
• UNION
• UNION ALL
• INTERSECT
• EXCEPT
• Subqueries
• Common Table Expressions (CTEs)
• Window Functions
• String Functions
• Date Functions
• Views

---

Tools & Skills

• PostgreSQL
• pgAdmin 4
• Visual Studio Code
• SQL
• Database Management
• Query Writing
• Data Analysis

---

Purpose

This project was created to strengthen SQL fundamentals through hands-on practice while building a practical SQL portfolio for data analytics.