Data Management / Database Administration

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

• 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

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.

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

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.