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.

Leave a Reply
You must be logged in to post a comment.