Skip to content

README.md

Latest commit

 

History

History
24 lines (16 loc) · 1.37 KB

README.md

File metadata and controls

24 lines (16 loc) · 1.37 KB
Raw

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.