SQL Fundamentals Practice

Overview

This repository showcases my hands-on SQL practice using PostgreSQL.

The objective of this project was to strengthen my understanding of SQL fundamentals through practical exercises covering data definition, data manipulation, filtering, sorting, aggregation, and table modification.

---

Topics Covered

• CREATE TABLE

• PRIMARY KEY

• NOT NULL

• CHECK Constraint

• INSERT INTO

• SELECT

• WHERE

• UPDATE

• DELETE

• ORDER BY (ASC & DESC)

• Aggregate Functions

  • SUM()
  • AVG()
  • COUNT()

• GROUP BY

• HAVING

• LIMIT

• ALTER TABLE

  • ADD COLUMN
  • RENAME COLUMN
  • ALTER COLUMN
  • DROP COLUMN

---

Practice Questions Included

This project contains practical SQL exercises such as:

• Retrieve employee records
• Filter records using WHERE
• Update employee information
• Delete records
• Sort data using ORDER BY
• Calculate total and average salary
• Group employees by department
• Filter grouped data using HAVING
• Display Top-N records
• Modify table structure using ALTER TABLE

---

Tools Used

• PostgreSQL
• pgAdmin 4

---

Repository Structure

sql-fundamentals-practice
│
├── screenshots 
├── README.md
└── sql_fundamentals_practice.sql

---

Learning Outcome

Through this project, I gained practical experience with SQL fundamentals, including creating databases, managing records, querying data, and modifying database structures.

This repository serves as part of my journey toward becoming a Data Analyst.

---

Author

Mohan Thurpati

Aspiring Data Analyst

Currently Learning:

• SQL
• Power BI
• Excel
• Python