Git Basics SQL Practice

A small, safe practice repository for the Git Basics course.

Use this repository to practice the Git/GitHub collaboration loop with realistic analyst work:

1. Pull the latest changes.
2. Create a branch.
3. Edit a SQL query, data dictionary, or analysis note.
4. Review your changes with git status and git diff.
5. Stage and commit a small change.
6. Push your branch to GitHub.
7. Open a pull request.
8. Respond to review feedback.
9. Merge and sync your local main branch.

What is in this repository?

queries/             Example SQL files using fictional tables
analysis-notes/      Short notes about query intent and findings
data-dictionary/     Plain-language definitions for fictional fields
troubleshooting/     Notes for common Git and SQL practice issues

Safety note

This repository uses fictional data structures only. Do not add:

• real client, patient, or participant data
• credentials, passwords, tokens, or connection strings
• private server names or internal hostnames
• screenshots containing private information

Suggested first practice change

Open queries/01-count-visits.sql and make a small improvement, such as adding a comment that explains what the query counts.

Then use the course checklist to commit, push, and open a pull request.