SQL Data Investigation Project for Application Support

This project simulates real-world Application Support Analyst work by investigating data issues in a small Order Management System. It includes:

• A database schema with sample data (including intentional errors)
• Fake support tickets based on realistic user complaints
• SQL queries used to investigate each issue
• A written analysis explaining findings and recommended next steps

The goal of this project is to demonstrate SQL troubleshooting, root cause analysis, and clear communication — all essential skills for an Application Support Analyst.

Project Files

• schema_and_data.sql
  Contains the database structure (tables) and sample data used for testing.

• tickets.md
  A set of realistic support tickets describing issues reported by users or internal teams.

• troubleshooting_queries.sql
  SQL queries written to investigate each support ticket.

• analysis.md
  A detailed explanation of the findings for each ticket, including root cause and recommended next steps.

Database Overview

The project uses two tables:

customers

• customer_id
• customer_name
• region

orders

• order_id
• customer_id
• order_date
• amount
• status

Intentional data issues were added to simulate real support scenarios, such as:

• Invalid customer IDs
• Negative amounts
• Zero-dollar pending orders
• Unusually high amounts

Skills Demonstrated

• SQL querying and data investigation
• Identifying data integrity issues
• Root cause analysis
• Reproducing and validating user-reported issues
• Writing clear technical documentation
  -Demonstrating/thinking as an Application Support Analyst

How to Run This Project

1. Open any SQL environment (such as an online SQL editor).
2. Copy and run the contents of schema_and_data.sql to create the tables and load the sample data.
3. Run the queries in troubleshooting_queries.sql to investigate each issue.
4. Review analysis.md to understand the findings and recommended next steps.

Screen Shots