Assignment Reference:

  • Purpose: Create a SQLbased business report that answers a realworld business question.
  • Data Design: Build one detailed table (granular data) and one summary table (aggregated results).
  • SQL Work: Write original queries, userdefined functions, triggers, and a stored procedure to transform, load, and refresh the data.
  • Automation: Identify a job scheduling tool to run the refresh process automatically.
  • Documentation: Explain the business question, data sources, transformations, table usage, and refresh frequency in a written report.
  • Demonstration: I will record a video showing the SQL code running and producing the report.
  • Skills Assessed: SQL analysis, database design, data transformation, automation, and professional communication.

WRITE MY PAPER