SQL Server Administration
Automation with SQL and Jobs
Tuition reference: 650,000 KRW
Idempotent scripts, job ownership, and change tickets that operations teams actually want to merge.
Overview
You ship small automation PRs against a classroom repo with reviewers who behave like busy DBAs. Emphasis is on readability, rollback notes, and pairing with app teams without heroics.
Included focus areas
- Pull request checklist tuned for ops repos
- Idempotent bootstrap script patterns
- Job owner and secret rotation storylines
- Change ticket template with rollback column
- Pairing simulation with app engineer persona
Outcomes you can evidence
- Plan maintenance windows with documented checklists.
- Explain architecture choices to peers using diagrams you produce in class.
- Ship a capstone lab report reviewers can follow without extra clarification.
Primary mentor
Hina Okada
Senior database instructor with multi-vendor production background and mentor hours for cohort labs.
Learner notes
PR checklist alone justified the enrollment; reviewers stopped bouncing my automation PRs for style reasons.
Common questions
We touch pipeline hooks lightly; a dedicated pipeline course is planned separately.