Grade 13 · a vocational technology learning center, by urbanicity

newSchoolWorks › VoTechWorks › Technology & Design › Data Management / Database Administration › Courses

Technology & Design · course plan

Data Management / Database Administration

12 courses · 1,350 clock hours · 6–9 mo full-time. Grading is competency-based: each course requires the written exam, a competent skills demonstration with zero safety faults, a signed log, and a passed safety audit; percentage weights only rank performance above the competency floor.

$13,190program tuition

12courses

83lessons

1,350hours

43assessments

TEC-DATA86-01 Universal core

Universal Core: Safety, Math, Communication & Career

148 hr · $1,185

Shared first block for every VoTechWorks program. OSHA 10 (30 for construction management), first aid/CPR/AED, applied trade math and measurement, technical reading and writing, digital literacy, and career readiness. Completed before students enter the lab and live systems unsupervised.

Outcomes

Hold an OSHA 10 card and current CPR/AED certification
Convert, measure and estimate with trade units, fractions, percentages and basic geometry
Read a specification, code excerpt or manual and write a clear technical report
Use email, spreadsheets, and the program's digital job-management tools
Present a resume, portfolio and interview answers to an employer panel

Course text

How the course runs. 7 blocks: OSHA 10: introduction, rights, hazard recognition; First aid, CPR and AED; Applied trade math I: units, fractions, conversion; Applied trade math II: geometry, ratio and estimating; Technical reading and writing; Digital literacy for the trade; Career readiness: resume, portfolio, interview.

Lessons · 7 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	OSHA 10: introduction, rights, hazard recognition	10	theory	Complete the OSHA 10-hour outreach course.	Authorized trainer sessions Hazard recognition walk Card exam	OSHA outreach materials	OSHA card issued
2	First aid, CPR and AED	8	practice	Respond to a collapse, bleed, burn or choke until help arrives.	Skills stations: CPR, AED, bleeding control Scenario drills Certification skills check	Manikins, AED trainer, first-aid kit	AHA/Red Cross card issued
3	Applied trade math I: units, fractions, conversion	20	theory	Convert, add and scale measurements used in the trade.	Measurement warm-ups from the shop Fraction and decimal drill Conversion problems from real orders	Trade math workbook, tape measures, calculators	Quiz ≥ 70%
4	Applied trade math II: geometry, ratio and estimating	20	theory	Lay out from a drawing and estimate quantity, time and cost.	Layout geometry: squares, angles, arcs Ratio and percentage: mixes, markups, loads Estimate a small job start to finish	Drawings, estimating sheets	Estimate within 10% of the key
5	Technical reading and writing	30	theory	Read a specification or manual and write a clear technical report.	Reading a spec: find the requirement, restate it Report structure: problem, standard, method, result Write and revise a report on a shop task	Spec excerpts, report template	Report rubric ≥ 3/4
6	Digital literacy for the trade	30	lab	Use email, spreadsheets, and the trade's job-management tools.	Email and calendar for a job Spreadsheet: a materials list with totals The program's job app: ticket, photos, sign-off	Lab computers/tablets, the job app	IC3/MOS-style practical passed
7	Career readiness: resume, portfolio, interview	30	practice	Present yourself to an employer panel.	Resume and portfolio build Mock interviews with feedback Employer panel	Portfolio templates, employer volunteers	Panel pass

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
OSHA 10 and first-aid written exams	Written exam	25%	OSHA card issued; CPR/AED card issued	Authorized outreach trainer exam plus AHA/Red Cross skills check. Accuracy · Safety · Communication · Professionalism
Applied math & measurement exam	Written exam	25%	70%	Timed exam: conversions, layout math, estimating from a drawing or recipe/order. Accuracy · Safety · Communication · Professionalism
Technical report	Project	25%	Rubric ≥ 3 of 4 on every criterion	A written report on a real task from the trade: problem, standard, method, result. Accuracy · Safety · Communication · Professionalism
Employer panel interview	Oral / panel	25%	Panel pass	Resume, 3-minute portfolio walk-through, and interview with two employer advisors. Accuracy · Safety · Communication · Professionalism

TEC-DATA86-02 Trade course

Relational design & normalization

92 hr · $1,105

Competency course in Relational design & normalization for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in Relational design & normalization and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern Relational design & normalization
Select and safely use the tools, equipment and materials for Relational design & normalization
Perform the core tasks of Relational design & normalization to the standard, within time, without rework
Identify faults, hazards and non-conformities in Relational design & normalization work and correct them
Document Relational design & normalization work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, relational design & normalization is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

How the course runs. 8 blocks of about 11.5 hours: orientation and safety first, then the tools and the vocabulary, then the standard that governs the work. Guided practice becomes independent practice; measurement and inspection teach the student to judge their own work; the fault lab teaches what failure looks like before it happens on a job. A timed production run and the documentation block close the loop, and the course ends with the written exam and the observed skills demonstration.

What competent looks like. The student can explain relational design & normalization, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for relational design & normalization	11.5	theory	State the hazards of relational design & normalization work and the controls for each; pass the safety brief.	Walk the lab: where relational design & normalization work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of relational design & normalization	11.5	demo	Name, select and care for the tools and materials of relational design & normalization; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in relational design & normalization, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for relational design & normalization, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in relational design & normalization	11.5	practice	Perform the core tasks of relational design & normalization step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in relational design & normalization	11.5	practice	Perform the core tasks of relational design & normalization to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in relational design & normalization	11.5	lab	Measure, lay out and inspect relational design & normalization work; decide accept/reject against tolerance.	Measuring instruments for relational design & normalization: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in relational design & normalization	11.5	lab	Identify defective or unsafe relational design & normalization work, explain the cause, and correct it.	Fault gallery: photographs and samples of relational design & normalization failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in relational design & normalization	11.5	theory	Record relational design & normalization work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: relational design & normalization	11.5	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Relational design & normalization: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for Relational design & normalization. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Relational design & normalization: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of Relational design & normalization against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Relational design & normalization: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Relational design & normalization: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing Relational design & normalization work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-03 Trade course

PostgreSQL admin

91 hr · $1,090

Competency course in PostgreSQL admin for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in PostgreSQL admin and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern PostgreSQL admin
Select and safely use the tools, equipment and materials for PostgreSQL admin
Perform the core tasks of PostgreSQL admin to the standard, within time, without rework
Identify faults, hazards and non-conformities in PostgreSQL admin work and correct them
Document PostgreSQL admin work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, postgreSQL admin is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

How the course runs. 8 blocks of about 11.4 hours: orientation and safety first, then the tools and the vocabulary, then the standard that governs the work. Guided practice becomes independent practice; measurement and inspection teach the student to judge their own work; the fault lab teaches what failure looks like before it happens on a job. A timed production run and the documentation block close the loop, and the course ends with the written exam and the observed skills demonstration.

What competent looks like. The student can explain postgreSQL admin, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for postgreSQL admin	11.4	theory	State the hazards of postgreSQL admin work and the controls for each; pass the safety brief.	Walk the lab: where postgreSQL admin work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of postgreSQL admin	11.4	demo	Name, select and care for the tools and materials of postgreSQL admin; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in postgreSQL admin, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for postgreSQL admin, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in postgreSQL admin	11.4	practice	Perform the core tasks of postgreSQL admin step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in postgreSQL admin	11.4	practice	Perform the core tasks of postgreSQL admin to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in postgreSQL admin	11.4	lab	Measure, lay out and inspect postgreSQL admin work; decide accept/reject against tolerance.	Measuring instruments for postgreSQL admin: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in postgreSQL admin	11.4	lab	Identify defective or unsafe postgreSQL admin work, explain the cause, and correct it.	Fault gallery: photographs and samples of postgreSQL admin failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in postgreSQL admin	11.4	theory	Record postgreSQL admin work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: postgreSQL admin	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
PostgreSQL admin: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for PostgreSQL admin. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
PostgreSQL admin: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of PostgreSQL admin against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
PostgreSQL admin: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
PostgreSQL admin: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing PostgreSQL admin work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-04 Trade course

Backup/recovery

91 hr · $1,090

Competency course in backup/recovery for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in backup/recovery and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern backup/recovery
Select and safely use the tools, equipment and materials for backup/recovery
Perform the core tasks of backup/recovery to the standard, within time, without rework
Identify faults, hazards and non-conformities in backup/recovery work and correct them
Document backup/recovery work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, backup/recovery is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain backup/recovery, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for backup/recovery	11.4	theory	State the hazards of backup/recovery work and the controls for each; pass the safety brief.	Walk the lab: where backup/recovery work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of backup/recovery	11.4	demo	Name, select and care for the tools and materials of backup/recovery; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in backup/recovery, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for backup/recovery, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in backup/recovery	11.4	practice	Perform the core tasks of backup/recovery step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in backup/recovery	11.4	practice	Perform the core tasks of backup/recovery to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in backup/recovery	11.4	lab	Measure, lay out and inspect backup/recovery work; decide accept/reject against tolerance.	Measuring instruments for backup/recovery: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in backup/recovery	11.4	lab	Identify defective or unsafe backup/recovery work, explain the cause, and correct it.	Fault gallery: photographs and samples of backup/recovery failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in backup/recovery	11.4	theory	Record backup/recovery work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: backup/recovery	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Backup/recovery: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for backup/recovery. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Backup/recovery: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of backup/recovery against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Backup/recovery: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Backup/recovery: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing backup/recovery work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-05 Trade course

Security & roles

91 hr · $1,090

Competency course in security & roles for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in security & roles and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern security & roles
Select and safely use the tools, equipment and materials for security & roles
Perform the core tasks of security & roles to the standard, within time, without rework
Identify faults, hazards and non-conformities in security & roles work and correct them
Document security & roles work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, security & roles is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain security & roles, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for security & roles	11.4	theory	State the hazards of security & roles work and the controls for each; pass the safety brief.	Walk the lab: where security & roles work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of security & roles	11.4	demo	Name, select and care for the tools and materials of security & roles; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in security & roles, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for security & roles, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in security & roles	11.4	practice	Perform the core tasks of security & roles step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in security & roles	11.4	practice	Perform the core tasks of security & roles to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in security & roles	11.4	lab	Measure, lay out and inspect security & roles work; decide accept/reject against tolerance.	Measuring instruments for security & roles: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in security & roles	11.4	lab	Identify defective or unsafe security & roles work, explain the cause, and correct it.	Fault gallery: photographs and samples of security & roles failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in security & roles	11.4	theory	Record security & roles work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: security & roles	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Security & roles: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for security & roles. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Security & roles: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of security & roles against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Security & roles: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Security & roles: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing security & roles work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-06 Trade course

ETL pipelines

91 hr · $1,090

Competency course in ETL pipelines for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in ETL pipelines and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern ETL pipelines
Select and safely use the tools, equipment and materials for ETL pipelines
Perform the core tasks of ETL pipelines to the standard, within time, without rework
Identify faults, hazards and non-conformities in ETL pipelines work and correct them
Document ETL pipelines work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, eTL pipelines is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain eTL pipelines, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for eTL pipelines	11.4	theory	State the hazards of eTL pipelines work and the controls for each; pass the safety brief.	Walk the lab: where eTL pipelines work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of eTL pipelines	11.4	demo	Name, select and care for the tools and materials of eTL pipelines; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in eTL pipelines, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for eTL pipelines, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in eTL pipelines	11.4	practice	Perform the core tasks of eTL pipelines step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in eTL pipelines	11.4	practice	Perform the core tasks of eTL pipelines to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in eTL pipelines	11.4	lab	Measure, lay out and inspect eTL pipelines work; decide accept/reject against tolerance.	Measuring instruments for eTL pipelines: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in eTL pipelines	11.4	lab	Identify defective or unsafe eTL pipelines work, explain the cause, and correct it.	Fault gallery: photographs and samples of eTL pipelines failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in eTL pipelines	11.4	theory	Record eTL pipelines work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: eTL pipelines	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
ETL pipelines: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for ETL pipelines. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
ETL pipelines: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of ETL pipelines against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
ETL pipelines: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
ETL pipelines: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing ETL pipelines work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-07 Trade course

Data governance & quality

91 hr · $1,090

Competency course in data governance & quality for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in data governance & quality and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern data governance & quality
Select and safely use the tools, equipment and materials for data governance & quality
Perform the core tasks of data governance & quality to the standard, within time, without rework
Identify faults, hazards and non-conformities in data governance & quality work and correct them
Document data governance & quality work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, data governance & quality is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain data governance & quality, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for data governance & quality	11.4	theory	State the hazards of data governance & quality work and the controls for each; pass the safety brief.	Walk the lab: where data governance & quality work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of data governance & quality	11.4	demo	Name, select and care for the tools and materials of data governance & quality; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in data governance & quality, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for data governance & quality, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in data governance & quality	11.4	practice	Perform the core tasks of data governance & quality step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in data governance & quality	11.4	practice	Perform the core tasks of data governance & quality to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in data governance & quality	11.4	lab	Measure, lay out and inspect data governance & quality work; decide accept/reject against tolerance.	Measuring instruments for data governance & quality: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in data governance & quality	11.4	lab	Identify defective or unsafe data governance & quality work, explain the cause, and correct it.	Fault gallery: photographs and samples of data governance & quality failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in data governance & quality	11.4	theory	Record data governance & quality work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: data governance & quality	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Data governance & quality: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for data governance & quality. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Data governance & quality: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of data governance & quality against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Data governance & quality: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Data governance & quality: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing data governance & quality work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-08 Trade course

Cloud storage

91 hr · $1,090

Competency course in cloud storage for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in cloud storage and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern cloud storage
Select and safely use the tools, equipment and materials for cloud storage
Perform the core tasks of cloud storage to the standard, within time, without rework
Identify faults, hazards and non-conformities in cloud storage work and correct them
Document cloud storage work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, cloud storage is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain cloud storage, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for cloud storage	11.4	theory	State the hazards of cloud storage work and the controls for each; pass the safety brief.	Walk the lab: where cloud storage work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of cloud storage	11.4	demo	Name, select and care for the tools and materials of cloud storage; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in cloud storage, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for cloud storage, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in cloud storage	11.4	practice	Perform the core tasks of cloud storage step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in cloud storage	11.4	practice	Perform the core tasks of cloud storage to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in cloud storage	11.4	lab	Measure, lay out and inspect cloud storage work; decide accept/reject against tolerance.	Measuring instruments for cloud storage: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in cloud storage	11.4	lab	Identify defective or unsafe cloud storage work, explain the cause, and correct it.	Fault gallery: photographs and samples of cloud storage failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in cloud storage	11.4	theory	Record cloud storage work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: cloud storage	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Cloud storage: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for cloud storage. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Cloud storage: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of cloud storage against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Cloud storage: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Cloud storage: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing cloud storage work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-09 Trade course

Bash automation

91 hr · $1,090

Competency course in Bash automation for the Data Management / Database Administration program. Instruction moves from demonstration to supervised practice to independent performance in the lab and live systems, measured against vendor documentation and industry standards. Students configure, secure and troubleshoot real work in Bash automation and keep a lab notebook signed off by the instructor.

Outcomes

Explain the principles, terminology and standards that govern Bash automation
Select and safely use the tools, equipment and materials for Bash automation
Perform the core tasks of Bash automation to the standard, within time, without rework
Identify faults, hazards and non-conformities in Bash automation work and correct them
Document Bash automation work in the lab notebook to industry format

Course text

Why it matters. In Data Management / Database Administration, bash automation is not a chapter to pass through but a skill an employer will pay for on day one; every credential exam in this program tests it directly or assumes it. The course runs in lab, against vendor documentation and the standard, with the lead engineer as the standard of judgment.

What competent looks like. The student can explain bash automation, set up for it safely, perform it to the standard within time, spot and correct what is wrong, and write it up so that a stranger could verify the work.

Lessons · 8 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Orientation and safety for bash automation	11.4	theory	State the hazards of bash automation work and the controls for each; pass the safety brief.	Walk the lab: where bash automation work happens, PPE station, emergency stops, first aid Hazard hunt: students list every hazard they can see and the control for it Safety brief and quiz; sign the safety agreement	PPE set, hazard cards, the program safety manual	Safety quiz 100% (retake until perfect); PPE donned correctly on demand
2	Tools, materials and terminology of bash automation	11.4	demo	Name, select and care for the tools and materials of bash automation; use the trade vocabulary correctly.	Instructor demonstration: every tool and material in bash automation, what it does, how it fails Tool card exercise: match tool to task to hazard Care and storage: clean, inspect, return; a tool log entry	Full tool kit for bash automation, material samples, tool cards	Oral check: 20 tools/terms named and their use stated
3	Fundamentals I: guided practice in bash automation	11.4	practice	Perform the core tasks of bash automation step by step under direct supervision.	Instructor demo of the core task, slowed and narrated Students repeat each step with checklist in hand; instructor corrects at the step Log entry: what was done, what the standard was, what was learned	Practice stock/consumables, step checklists, the log	Checklist completed with instructor initials on every step
4	Fundamentals II: independent practice in bash automation	11.4	practice	Perform the core tasks of bash automation to the standard with the instructor observing, not assisting.	Task ticket issued; student plans the job before touching a tool Independent performance, timed Self-assessment against the rubric, then instructor assessment; compare	Task tickets, rubric, timer, practice stock	Rubric ≥ 3/4 on every line; time within 150% of the standard
5	Measurement, layout and quality checks in bash automation	11.4	lab	Measure, lay out and inspect bash automation work; decide accept/reject against tolerance.	Measuring instruments for bash automation: calibration and reading Layout exercise from a drawing/order; check against the instructor's key Inspection lab: 10 samples, accept or reject with a reason	Measuring instruments, drawings/orders, sample set	Inspection lab 9/10 correct with correct reasons
6	Faults, hazards and rework in bash automation	11.4	lab	Identify defective or unsafe bash automation work, explain the cause, and correct it.	Fault gallery: photographs and samples of bash automation failures Diagnosis drill: cause → consequence → correction Rework lab: repair a planted fault to standard	Fault samples, diagnosis sheets, rework stock	Rework accepted by the lead engineer on inspection
7	Documentation: the log and the report in bash automation	11.4	theory	Record bash automation work in the industry format so a stranger could verify it.	Anatomy of the trade's paperwork: log, report, sign-off, hours evidence Write the report for the production run Peer review against the documentation rubric	Report template, the certifying body's hours form	Report accepted by instructor; hours form correctly completed
8	Written exam and skills demonstration: bash automation	11.4	assessment	Pass the course's written exam and the observed skills demonstration.	Written exam (see assessment plan) Skills demonstration, observed and scored Results conference: what the credential exam will ask of this skill	Exam, checklist, all tools and stock for the demonstration	Written ≥ 75%; demonstration competent on every critical step with zero safety faults

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Bash automation: written exam	Written exam	25%	75%	Theory, terminology, standards and safety for Bash automation. Multiple choice plus short calculation/interpretation items drawn from the certification body's task list. Standard met · Safety · Time · Quality/finish · Documentation
Bash automation: skills demonstration	Skills demonstration	45%	Competent on every critical step; zero safety faults	Observed, timed performance of the core tasks of Bash automation against a checklist. A critical-step miss or a safety fault stops the assessment; re-attempt after remediation. Standard met · Safety · Time · Quality/finish · Documentation
Bash automation: lab notebook	Log	15%	Complete, signed, ≥ 90% attendance of lab hours	Daily entries: task, standard, method, result, time; instructor sign-off. Serves as hours evidence for the licensing/certifying body. Standard met · Safety · Time · Quality/finish · Documentation
Bash automation: safety audit	Safety audit	15%	Pass/fail — must pass	Unannounced audit of PPE, housekeeping, lockout/guarding, and hazard communication while performing Bash automation work. Standard met · Safety · Time · Quality/finish · Documentation

TEC-DATA86-10 Capstone

Capstone Project

162 hr · $1,620

An integrated, assessed piece of real work that draws on every trade course in Data Management / Database Administration: planned, estimated, executed and documented by the student, reviewed by an employer advisor. Capstones are shown in the Student Yard or the Museum of VoTech where the work allows.

Outcomes

Plan and estimate a complete job from a specification
Execute the job to standard within the estimate
Present the finished work and its documentation to an employer panel

Course text

How the course runs. 4 blocks: Capstone brief and specification; Capstone build I; Capstone build II; Capstone presentation and defense.

Lessons · 4 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Capstone brief and specification	40.5	theory	Read the capstone specification and plan the job.	Spec walkthrough with the employer advisor Work breakdown and schedule Materials and cost estimate	Capstone spec, estimating sheets	Plan and estimate approved
2	Capstone build I	40.5	practice	Execute the first half of the capstone to standard.	Daily start-up brief Build, with log kept live Mid-point inspection	All materials per estimate	Mid-point inspection passed
3	Capstone build II	40.5	practice	Complete the capstone to standard within the estimate.	Build to completion Self-inspection against the spec Documentation package assembled	As above	Work complete; package complete
4	Capstone presentation and defense	40.5	assessment	Present the finished work and its documentation to the panel.	15-minute presentation Panel questions Scoring and feedback	Presentation space, the finished work	Rubric ≥ 3/4 on every criterion

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Capstone: finished work + documentation	Project	60%	Rubric ≥ 3 of 4 on every criterion	Employer advisor + instructor score the finished work against the specification, the estimate, and the documentation package. Meets specification · Within estimate · Workmanship · Safety · Documentation
Capstone: portfolio	Portfolio	20%	Complete	Photos/drawings/logs of every course skills demonstration plus the capstone, in the program portfolio format. Completeness · Organization · Evidence quality
Capstone: defense	Oral / panel	20%	Panel pass	15-minute presentation and questions from the panel. Explains decisions · Answers technical questions · Professional communication

TEC-DATA86-11 Externship / clinical

Externship / Worksite Placement

243 hr · $970

Supervised placement with an employer partner in Data Management / Database Administration work. Hours are logged against the certifying body's task list; the employer evaluates against the same rubric used in the shop.

Outcomes

Perform the trade's tasks in a real workplace under supervision
Meet employer expectations for attendance, safety and conduct
Log hours and tasks in the format the certifying body accepts

Course text

How the course runs. 4 blocks: Placement orientation; Supervised work: weeks 1–2; Supervised work: weeks 3–4; Supervised work: final weeks.

Lessons · 4 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	Placement orientation	60.8	theory	Know the site, its rules, and the competency list you will be evaluated on.	Site orientation and safety induction Competency list review with the supervisor Logging procedure	Site handbook, competency list, hours log	Induction signed
2	Supervised work: weeks 1–2	60.8	field	Perform entry tasks under close supervision.	Shadow and assist First independent tasks Weekly log review	Hours log	Log current; supervisor initials
3	Supervised work: weeks 3–4	60.8	field	Perform the trade's routine tasks with normal supervision.	Routine tasks assigned as to a new hire Mid-point evaluation Remediation targets if any	Hours log, evaluation form	Mid-point evaluation satisfactory
4	Supervised work: final weeks	60.8	field	Meet employer expectations for a new hire on the competency list.	Full task load Final evaluation Hours verified and submitted	Evaluation form, hours verification	Final evaluation satisfactory on every competency; hours verified

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Employer evaluation	Skills demonstration	70%	Satisfactory on every competency	Mid-point and final evaluation by the site supervisor on the program competency list. Competency · Safety · Attendance · Conduct · Initiative
Hours & task log	Log	30%	Required hours complete and verified	Signed log of hours and tasks; verified by the registrar for the board/certifying body. Complete · Verified

TEC-DATA86-12 Exam prep

Certification Exam Preparation

68 hr · $680

Structured preparation for DAMA CDMP Associate; Microsoft DP-300; Oracle DBA CA; PostgreSQL CE (EDB): content review mapped to the exam blueprint, timed practice exams, practical-exam rehearsal, and registration/eligibility paperwork with the registrar.

Outcomes

Score ≥ 80% on two timed mock exams
Complete the eligibility application and hours verification
Rehearse the practical exam format to time

Course text

How the course runs. 4 blocks: The exam blueprint; Mock exam I and review; Practical exam rehearsal; Mock exam II and registration.

Lessons · 4 blocks

#	Lesson	Hr	Type	Objective	Activities	Materials	Check
1	The exam blueprint	17	theory	Map the credential exam blueprint to what you have learned.	Blueprint walkthrough Self-rating by domain Study plan	Published blueprint, study plan template	Study plan on file
2	Mock exam I and review	17	assessment	Sit a timed full-length mock and review every miss.	Timed mock Item-by-item review Targeted study assignments	Mock exam, answer keys	Score recorded; review complete
3	Practical exam rehearsal	17	practice	Rehearse the practical/skills portion to the exam's time and format.	Format briefing Timed rehearsal Feedback	Practical exam materials	Rehearsal within time, no critical misses
4	Mock exam II and registration	17	assessment	Sit the second mock and complete exam registration.	Timed mock II Eligibility application and hours verification with the registrar Exam date booked	Registration forms, hours evidence	≥ 80%; registration submitted

Assessments

Assessment	Type	Weight	Pass standard	Method & rubric
Mock certification exam (×2)	Mock certification exam	100%	≥ 80% on both	Full-length timed mocks built from the certifying body's published blueprint; second attempt after targeted review. Score · Time management

Program completion

External credential: DAMA CDMP Associate; Microsoft DP-300; Oracle DBA CA; PostgreSQL CE (EDB)

The program completion credential(s). Sat at the school's authorized testing center or the body's test site; results recorded in the student record and reported in the annual outcomes report. Pass standard: Credential issued by the body.

Back to Data Management / Database Administration · How the school gets authority to award these credentials