SQL

This repository contains a collection of SQL scripts and resources for learning, practicing, and applying SQL concepts. The workspace is organized into several directories, each focusing on different topics and case studies.

Directory Structure

• aircraft_case_study/

  • SQL scripts and data for an aircraft load data case study.
    • aircraft_load_data.sql
    • aircraft_query.sql
    • aircraft_schema.sql
    • aircraft.sql
    • aircrafts.sql
    • data/DelayedFlights.csv

• hands-on-sql-cookbook/

  • Practical SQL exercises and examples.
    • .env
    • employees.csv
    • inserting_updating_deleting.sql
    • joins.sql
    • main.py
    • retriving_and_sorting.sql
    • README.md

• Learning SQL/

  • SQL scripts for learning and reference.
    • mySQL.sql
    • sakila_data_query.sql
    • Learning SQL/sakila_data_query.sql:
      A comprehensive collection of SQL queries and techniques using the Sakila sample database, including:
    • Joins, subqueries, CTEs, window functions, analytical queries, data manipulation, and reporting
    • Examples of error handling, conditional logic, and view creation
    • Useful for both learning and interview preparation

• sql_basics/

  • Foundational SQL scripts covering basics, datatypes, functions, error handling, and more.
    • basics.sql
    • datatypes.sql
    • functions.sql
    • functions_2.sql
    • handling_errors.sql
    • metadata.sql
    • operators.sql
    • pgsql.sql
    • ...

Getting Started

1. Clone this repository.
2. Explore the directories for topic-specific SQL scripts.
3. Use your preferred SQL database (PostgreSQL, MySQL, etc.) to run and experiment with the scripts.