SQL for Data Analysis & Reporting3 Sections21 Lessons10 Weeks
Curriculum
- 3 Sections
- 21 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Day 1: SQL for Data Analysis & Reporting fundamentals7 Items
- 1.11. SQL for Data Analysis & Reporting: purpose, scope and workplace relevance.
- 1.22. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 1.33. Review relevant evidence, trade-offs and limitations associated with sql for data analysis & reporting: purpose, scope and workplace relevance.
- 1.44. Relational data structures and query design.
- 1.55. Work through a supplied scenario that requires decisions about relational data structures and query design.
- 1.66. Review relevant evidence, trade-offs and limitations associated with relational data structures and query design.
- 1.7Practical workshop: Complete linked exercises: identify a realistic sql for data analysis & reporting requirement, role and source of evidence; analyse a supplied scenario and document assumptions, limits and critical details.
- Day 2: Joins, grouping and analytical queries7 Items
- 2.11. Joins, grouping and analytical queries.
- 2.22. Work through a supplied scenario that requires decisions about joins, grouping and analytical queries.
- 2.33. Review relevant evidence, trade-offs and limitations associated with joins, grouping and analytical queries.
- 2.44. Data quality and safe reporting practices.
- 2.55. Examine the quality and completeness of evidence or records used for data quality and safe reporting practices.
- 2.66. Review relevant evidence, trade-offs and limitations associated with data quality and safe reporting practices.
- 2.7Practical workshop: Complete linked exercises: compare methods or evidence with an approved guidance example or safe case; interpret results, note uncertainties and explain defensible decisions.
- Day 3: Insight queries and reproducible reporting7 Items
- 3.11. Insight queries and reproducible reporting.
- 3.22. Examine the quality and completeness of evidence or records used for insight queries and reproducible reporting.
- 3.33. Review relevant evidence, trade-offs and limitations associated with insight queries and reproducible reporting.
- 3.44. SQL for Data Analysis & Reporting: case assessment, review and next steps.
- 3.55. Integrate course evidence, review a realistic sql for data analysis & reporting: case assessment, review and next steps and explain the recommendations.
- 3.66. Review relevant evidence, trade-offs and limitations associated with sql for data analysis & reporting: case assessment, review and next steps.
- 3.7Practical workshop: Complete linked exercises: develop a concise improvement, study or quality assurance recommendation; present a case response and convert feedback into an action plan.
Practical workshop: Complete linked exercises: compare methods or evidence with an approved guidance example or safe case; interpret results, note uncertainties and explain defensible decisions.
Prev 2. Examine the quality and completeness of evidence or records used for insight queries and reproducible reporting.
Next 
