🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Technology & Design › Data Management / Database Administration › Externship / Worksite Placement › Lesson 3
TEC-DATA86-11 · Lesson 3 · 81 clock hours · field

Mentor-Assigned Applied Project

Objective. The student plans, executes, and documents a focused applied project assigned by the employer mentor—such as automating a backup report, migrating a schema, building a small ETL pipeline, or auditing user permissions—and delivers a brief written project summary.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by an industry-certified professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

The Mentor-Assigned Applied Project

The applied project is the central deliverable of your externship placement. Rather than a practice exercise, this is real work with real consequences for the employer's data systems. A mentor or supervising DBA will assign you a focused task that fits within the organization's current needs—examples include automating a backup report, migrating a database schema to a new structure, building a small ETL (Extract, Transform, Load) pipeline, or auditing user account permissions. You are expected to plan the work carefully, execute it professionally, document your progress daily, and present your results clearly.

Step 1: Define and Document Project Scope

Before touching any system, sit down with your mentor and agree on exactly what the project will accomplish. Then capture that agreement in a one-page written project plan using the template provided by your program. Your plan must include:

Obtain your mentor's written signature on the plan before beginning any work. This sign-off protects you and the employer by ensuring expectations are aligned and that the scope is appropriate for your skill level and the available hours.

Step 2: Execute the Work Safely and Professionally

Once the plan is approved, execute each step according to the agreed sequence. Commit your SQL scripts, configuration files, and code to a version-controlled repository (Git is the standard; use the employer's approved system if Git is not available). Version control is not optional—it provides a recovery path if something goes wrong and demonstrates professional practice to your mentor.

Data safety is your top priority. Database work can cause irreversible data loss if done carelessly. Follow these principles throughout the project:

Think of version control and backups as the database equivalent of lockout/tagout in a physical trade: they isolate the system from harm before you work on it.

Step 3: Maintain Your Daily Field Log

For every day you spend on the project, write a progress note of three to five sentences in your field log workbook. Each note should answer three questions: What did I accomplish today? What obstacles did I encounter? How did I resolve them (or what is my plan to resolve them)?

These notes serve multiple purposes. They keep your mentor informed without requiring constant check-ins. They provide evidence of your professional practice for program evaluation. And they train a habit—experienced DBAs keep detailed runbooks and incident notes precisely because database problems often recur months or years later.

Step 4: Present and Submit Your Project Summary

When the project is complete, deliver a verbal presentation of ten to fifteen minutes to your mentor and, optionally, other team members. Structure your presentation around four points: the problem statement, your approach, the outcome, and lessons learned. Speak plainly and be prepared for questions.

Also submit a written project summary of one to two pages covering the same four points in slightly more detail. Your mentor will review this document, rate the project quality on the employer rubric, and sign the summary. A rubric score of 70% or higher ("Meets Expectations" or better) is required to pass this lesson.

Why This Matters for Your Credentials

Every major certification you are preparing for—the DAMA CDMP, Oracle DBA CA, Microsoft DP-300, and PostgreSQL CE—tests your ability to apply concepts in realistic scenarios, not just recall definitions. An applied project gives you a concrete example to draw on during scenario-based exam questions and, more importantly, gives future employers evidence that you have done real database work under professional supervision.

Key terms9

Project scopeA written definition of the boundaries of a project: what will be done, what tools will be used, what the success criteria are, and what is explicitly excluded from the work.
Success criteriaSpecific, measurable conditions that define when a project is considered complete and acceptable—agreed upon by the student and mentor before work begins.
Version controlA system (such as Git) that tracks every change made to files over time, allowing recovery of earlier versions and a clear audit trail of who changed what and when.
Least privilegeA security principle requiring that a database user or process is granted only the minimum permissions necessary to perform its intended function, reducing the risk of accidental or malicious data modification.
ETL pipelineA data integration process that Extracts data from a source, Transforms it to meet target requirements (cleaning, reformatting, aggregating), and Loads it into a destination system or database.
Runbook / SOPA Standard Operating Procedure document used by database and operations teams that records the exact steps for performing routine or emergency tasks, ensuring consistency and reducing human error.
Change managementA formal process organizations use to review, approve, schedule, and document changes to IT systems—including databases—in order to minimize unplanned outages and data loss.
Field logA workbook maintained by the student throughout the externship in which daily progress notes document tasks completed, obstacles encountered, and how those obstacles were addressed.
Employer rubricA structured evaluation form completed by the mentor that rates the quality of the student's project work against defined performance levels; a score of 70% or higher is required to pass.
In class: In consultation with the mentor, define project scope with a written one-page plan stating the business problem, tools to be used, steps, success criteria, and connection to at least one certification exam domain; obtain mentor approval before beginning work. · Execute the project across the allocated hours, committing work to a version-controlled repository or employer-approved documentation system, and maintain a daily progress note (3–5 sentences) in the field log describing what was accomplished, any obstacles encountered, and how they were resolved. · Present a 10–15 minute verbal summary of the completed project to the mentor (and optionally additional team members), covering the problem statement, approach, outcome, and lessons learned; submit a written project summary (1–2 pages) that the mentor reviews and signs.
Materials: Employer RDBMS and automation environment, version control system (Git or employer equivalent), field log workbook, project plan template (provided by program), employer runbook or SOP documentation
Check: Mentor signs the project plan before work begins; written project summary is submitted and mentor rates project quality at 'Meets Expectations' or higher on the employer rubric; field log shows daily progress notes for all project hours. Pass: mentor sign-off on summary and rubric score of 70% or higher.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

DAMA CDMP – Data Governance and Management Practice
1. Before beginning any hands-on work on the applied project, what must the student obtain?
Oracle DBA CA – Backup, Recovery, and Data Protection
2. A student's applied project involves dropping several obsolete tables from a database. What is the safest sequence of actions?
Microsoft DP-300 – Implement Security for Azure SQL (Security Domain)
3. Which of the following best describes the principle of least privilege as applied to a database project?
DAMA CDMP – Data Management Practices and Documentation
4. What is the primary professional purpose of maintaining a daily progress note in the field log?
Microsoft DP-300 – Data Integration and ETL Concepts
5. A student is building a small ETL pipeline as an applied project. Which step correctly describes the 'Transform' phase?
Oracle DBA CA – Security, Roles, and Privilege Management
6. The student's project plan must connect the work to at least one certification exam domain. Which of the following is a valid example of such a connection?
DAMA CDMP – Professional Competency and Evaluation
7. What score on the employer rubric is the minimum required for a student to pass the Mentor-Assigned Applied Project lesson?
PostgreSQL CE – Performance Tuning and Query Optimization
8. During the verbal presentation of the completed project, a student is asked why they chose a particular indexing strategy. This question most closely aligns with which certification exam domain?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →