Data & research
SQL & Relational Databases
Build an evidence-led SQL & Relational Databases foundation you can explain in a real workplace or interview.
Query, structure and protect data for practical business questions.
About this course
Build SQL thinking, data modelling, joins, quality checks, reporting logic and responsible database habits.
Career relevance
Where this can take you
Designed for learners exploring data careers and building a practical, honest portfolio.
Portfolio project: Create a SQL & Relational Databases capstone pack that documents your purpose, method, evidence, quality check and next action.
Skills you will gain
Practical skills, not just theory
What you will learn
Understand the core workflow behind sql & relational databases.
Create practical evidence using controlled, workplace-ready methods.
Make evidence-led decisions, communicate limitations and escalate appropriately.
Present a portfolio-ready capstone and development plan.
Objective map
A numbered, measurable syllabus
Every lesson, knowledge check and practical activity maps to the objectives below. Domain weights show how much of the programme each area represents.
Domain 1
SQL & Relational Databases: role and foundations to Structure
- 1.1Explain and distinguish sql & relational databases: role and foundations in a realistic sql & relational databases context: establish the purpose, professional boundaries and workplace context for sql & relational databases.
- 1.2Demonstrate query in a realistic sql & relational databases context: apply query to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
- 1.3Demonstrate structure in a realistic sql & relational databases context: apply structure to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
Domain 2
Protect data for practical business questions to Portfolio lab: SQL & Relational Databases case
- 2.1Demonstrate protect data for practical business questions in a realistic sql & relational databases context: apply protect data for practical business questions to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
- 2.2Apply and control integrated sql & relational databases workflow in a realistic sql & relational databases context: connect the programme topics into one controlled workflow with clear inputs, checks, handover points and escalation boundaries.
- 2.3Complete and defend portfolio lab: sql & relational databases case in a realistic sql & relational databases context: create a portfolio-safe sql & relational databases artefact from a realistic workplace scenario and explain the choices made.
Domain 3
Final SQL & Relational Databases capstone
- 3.1Complete and defend final sql & relational databases capstone in a realistic sql & relational databases context: complete and review an end-to-end sql & relational databases case with evidence, quality checks, limitations and a professional recommendation.
How the programme works
Learn, practise, explain and prove it
This is a long-form, eight-week guided programme rather than a stack of short articles. Each module contains six substantial lessons that move from concepts and methods into a worked case, a quality clinic, a workplace lab and assessed reflection.
1. Guided learning
Study the purpose, process, risks and professional standard through structured readings and active notes.
2. Worked cases
Compare plausible options, expose missing evidence and defend a decision under realistic constraints.
3. Quality clinics and labs
Diagnose weak work, revise it against a rubric and create portfolio evidence with a full audit trail.
4. Hard assessment
Pass applied checks and the final assessment at 85%, with no unresolved critical-error questions.
Curriculum
A complete programme, module by module
The curriculum below shows the actual learning pathway, objective and evidence for every module. Full lessons remain locked until enrolment.
Build the base
Standards, vocabulary and the core method you will use throughout the programme.
01SQL & Relational Databases: role and foundationsEstablish the purpose, professional boundaries and workplace context for sql & relational databases.+
Measured objectiveExplain and distinguish sql & relational databases: role and foundations in a realistic sql & relational databases context: establish the purpose, professional boundaries and workplace context for sql & relational databases.
Evidence you will produceA checked working paper, analysis or report for sql & relational databases: role and foundations, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
02QueryApply query to a realistic sql & relational databases brief, documenting the decision, evidence and next action.+
Measured objectiveDemonstrate query in a realistic sql & relational databases context: apply query to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
Evidence you will produceA checked working paper, analysis or report for query, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
Milestone: You can explain the fundamentals and complete a first guided task.
Develop core skills
The working skills and tools of the role, practised one at a time.
03StructureApply structure to a realistic sql & relational databases brief, documenting the decision, evidence and next action.+
Measured objectiveDemonstrate structure in a realistic sql & relational databases context: apply structure to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
Evidence you will produceA checked working paper, analysis or report for structure, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
04Protect data for practical business questionsApply protect data for practical business questions to a realistic sql & relational databases brief, documenting the decision, evidence and next action.+
Measured objectiveDemonstrate protect data for practical business questions in a realistic sql & relational databases context: apply protect data for practical business questions to a realistic sql & relational databases brief, documenting the decision, evidence and next action.
Evidence you will produceA checked working paper, analysis or report for protect data for practical business questions, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
Milestone: You can carry out routine work independently and check it properly.
Apply it in realistic scenarios
Case studies and simulations with competing priorities and incomplete information.
05Integrated SQL & Relational Databases workflowConnect the programme topics into one controlled workflow with clear inputs, checks, handover points and escalation boundaries.+
Measured objectiveApply and control integrated sql & relational databases workflow in a realistic sql & relational databases context: connect the programme topics into one controlled workflow with clear inputs, checks, handover points and escalation boundaries.
Evidence you will produceA checked working paper, analysis or report for integrated sql & relational databases workflow, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
06Portfolio lab: SQL & Relational Databases caseCreate a portfolio-safe sql & relational databases artefact from a realistic workplace scenario and explain the choices made.+
Measured objectiveComplete and defend portfolio lab: sql & relational databases case in a realistic sql & relational databases context: create a portfolio-safe sql & relational databases artefact from a realistic workplace scenario and explain the choices made.
Evidence you will produceA checked working paper, analysis or report for portfolio lab: sql & relational databases case, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
Milestone: You can make and justify decisions in realistic situations.
Prove it and plan your next step
Portfolio evidence, final review and a development plan you can show an employer.
07Final SQL & Relational Databases capstoneComplete and review an end-to-end sql & relational databases case with evidence, quality checks, limitations and a professional recommendation.+
Measured objectiveComplete and defend final sql & relational databases capstone in a realistic sql & relational databases context: complete and review an end-to-end sql & relational databases case with evidence, quality checks, limitations and a professional recommendation.
Evidence you will produceA checked working paper, analysis or report for final sql & relational databases capstone, including source data, assumptions, calculations, findings and limitations.
Six guided lessons + worked case + quality clinic + workplace lab + hard knowledge check
Milestone: You have portfolio-ready evidence and a clear next step.
Suggested pace
Eight-week study plan
Plan for roughly 5–9 hours each week across readings, worked cases, practice, portfolio production and assessment remediation. Repeat a week when the knowledge checks show a gap.
Week 1
SQL & Relational Databases: role and foundations
- •Complete the six guided lessons for SQL & Relational Databases: role and foundations and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the sql & relational databases: role and foundations portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 2
Query
- •Complete the six guided lessons for Query and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the query portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 3
Structure
- •Complete the six guided lessons for Structure and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the structure portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 4
Protect data for practical business questions
- •Complete the six guided lessons for Protect data for practical business questions and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the protect data for practical business questions portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 5
Integrated SQL & Relational Databases workflow
- •Complete the six guided lessons for Integrated SQL & Relational Databases workflow and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the integrated sql & relational databases workflow portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 6
Portfolio lab: SQL & Relational Databases case
- •Complete the six guided lessons for Portfolio lab: SQL & Relational Databases case and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the portfolio lab: sql & relational databases case portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 7
Final SQL & Relational Databases capstone
- •Complete the six guided lessons for Final SQL & Relational Databases capstone and build structured notes against the objective codes.
- •Analyse the worked case, compare two defensible options and submit a reasoned decision record.
- •Complete the quality clinic, correct the weak draft and document every revision against the rubric.
- •Produce the final sql & relational databases capstone portfolio evidence and complete the hard knowledge checks.
- •Review every incorrect answer, explain why each distractor fails and schedule targeted retrieval practice.
Checkpoint: Reach at least 85% on the week’s checks, resolve every critical error and save the reviewed portfolio evidence before continuing.
Week 8
Review and consolidation
- •Complete a cumulative, closed-notes retrieval review across all objectives studied so far.
- •Repair incomplete portfolio evidence and repeat the two lowest-scoring knowledge checks.
- •Ask for structured feedback, record the feedback and revise one artefact to professional standard.
Checkpoint: Submit the capstone evidence pack, defend the key decision, remediate every weak objective and pass the final assessment at 85% with no critical misses.
Data & research
Continue your learning path
Business Intelligence Dashboards
Design controlled dashboards that answer operational questions.
60–72 hours
Business Statistics
Use statistical thinking to interpret evidence for workplace decisions.
60–72 hours
Data Engineering Foundations
Understand how reliable data pipelines support analysis and products.
55–66 hours
Assessment and certificate
A scenario-led sql & relational databases case, practical portfolio review and final knowledge assessment. It is a UGEN ACADEMY completion record, not an external professional credential.
Who this is for
- ✓Learners exploring data careers.
- ✓Job seekers building practical sql & relational databases evidence.
- ✓Professionals developing a structured new capability.