SQL Fundamentals

Welcome to the SQL Fundamentals repository! This project serves as a practical, hands-on guide covering basic to intermediate SQL querying techniques.

📂 Repository Contents

As shown in image_d6901a.png, this repository contains the following core files:

• saas_sales_data.csv: The primary dataset containing SaaS sales records used to execute and test the queries.
• BASIC.sql & BASIC_test.sql: Scripts covering foundational SQL commands (e.g., SELECT, WHERE, GROUP BY, ORDER BY).
• join.sql & join_test.sql: Queries demonstrating how to combine relational data across multiple tables using various JOIN operations.
• WIN_FUNCTIONS.sql: Intermediate-level scripts focusing on SQL Window Functions for advanced analytics and aggregations.

🚀 Getting Started

1. Clone the repository: Download these files to your local machine.
2. Set up the database: Import the saas_sales_data.csv file into your preferred SQL database management system (e.g., MySQL, PostgreSQL, or SQLite).
3. Run the scripts: Execute the provided .sql files against the imported dataset to explore how the queries function.

🛠️ Skills Demonstrated

• Data extraction, filtering, and manipulation.
• Relational database management and table joining.
• Advanced analytical querying utilizing Window Functions.