AI Assistants for Coding
from first prompt to a production-grade PoC
AI coding assistants have changed how software gets built. Instead of writing every line yourself, you direct an AI pair programmer that writes code, finds bugs, generates tests and helps you move from idea to working system in a fraction of the usual time.
But fast is not the same as good. This course teaches you to use AI assistants the way professionals do: with version control, written specs, automated tests, security checks and a proper deployment, so what you build is something you can trust and show to others.
You start simple, with the tools inside VS Code and PyCharm, Claude, ChatGPT and open-source assistants you can run privately on your own machine. Then you put everything together in a four-week capstone: a database chatbot that lets people ask questions about their data in plain language, built with AI, tested, secured and deployed live on a VPS. Every session is hands-on, and you finish with a working project and a repository you can present to employers or clients.
Who this course is for
- Developers and students who know basic Python and want to build faster and better with AI
- Freelancers and small teams who want to deliver working prototypes to clients quickly
- Anyone who has tried AI coding tools and wants a reliable, repeatable workflow instead of trial and error
What you'll learn
By the end, you'll have a live database chatbot running on your own server, and the skills to build the next one faster.
Master your AI pair programmer
- Get more from Copilot, Claude, ChatGPT and JetBrains AI inside VS Code and PyCharm
- Debug fast by giving the AI the right logs, errors and context
- Refactor and generate tests without breaking what already works
- Keep the AI consistent across a whole project with instruction files
Turn ideas into specs, and specs into working code
- Write a clear spec so the AI builds the right thing the first time
- Have the AI critique your design before a single line is written
- Break big features into small, checkable steps instead of one giant prompt
- Choose the right model (Claude, GPT or open-source) for each task
Delegate to AI agents, and stay in control
- Hand off multi-file tasks and review the changes before accepting them
- Spot when an agent has gone off track, and steer it back
- Automate repetitive work so you spend your time on decisions, not typing
Ship with a safety net
- Use Git so any bad AI change can be undone in seconds
- Add automated tests and quality checks that run on every push
- Set up a GitHub Actions pipeline so broken code never reaches your server
Lock it down before it goes live
- Keep passwords and API keys out of your code and your history
- Catch insecure defaults and made-up or unsafe packages that AI can suggest
- Understand prompt injection, and why it matters when AI reads files and data
- Give your app the least access it needs, and nothing more
Keep sensitive code and data private
- Run AI assistants on your own machine with Ollama and Continue
- Compare local and cloud models on quality, speed, cost and privacy
- Classify your data, so you know what can go to the cloud and what never leaves your laptop
Let people talk to their data
- Turn plain-language questions into safe database queries
- Block dangerous queries, cap runtime and limit results
- Handle vague, unanswerable and malicious questions gracefully
- Build a test set of questions with known answers so quality never quietly slips
Build real software, not demos
- Add login, per-user permissions and an audit trail of every question asked
- Manage database changes safely with versioned migrations
- Handle errors without crashing or exposing internals to users
- Track what every AI question costs and set spending limits
- Write documentation someone else can actually follow
Go live, and stay live
- Package your app with Docker so it runs the same everywhere
- Deploy to a VPS with HTTPS, a firewall and a health check
- Set up automatic backups, test a restore, and roll back a bad deploy
- Get an alert the moment your app goes down
- Run a 16-point production-readiness checklist before you call it done
Build a working PoC in hours
- Take the same workflow to a database you have never seen, against the clock
- Show an organization a working system, not a slide deck
- Know exactly when a proof of concept is ready to trust, and when it isn't
Week by week, building real skills
Two live lessons each week — a Saturday lesson introducing fresh material and a Sunday guided lab to embed it.
Week 1 · AI assistants and IDE integration
Week 2 · Claude, ChatGPT and JetBrains AI
Week 3 · Open-source and local assistants, plus security
Week 4 · Agentic workflows and automation
Week 5 · Capstone: spec, architecture and data layer
Week 6 · Capstone: natural language to SQL
Week 7 · Capstone: interface, users and observability
Week 8 · Capstone: deploy, harden, document and demo
Production-ready checklist
Your capstone project is graded against this 16-point checklist.
- Code is in Git with meaningful commits and no secrets in history
- Database access uses a read-only role with least privilege
- Every generated SQL statement is validated before execution
- Query timeouts and row limits are enforced
- Authentication and per-user permissions work
- Every question and query is written to an audit log
- An automated evaluation set and unit tests pass in CI
- Linting and formatting checks pass in CI
- The application runs from Docker Compose with one command
- It is deployed on a VPS over HTTPS with a working health check
- Errors are handled gracefully and logged, with no stack traces shown to users
- A README lets someone else install, run and understand it
- Schema changes are managed through versioned migrations
- Database backups run automatically and a restore has been tested
- AI usage and cost per question are logged, with a spending cap
- Uptime monitoring sends an alert when the app fails
Your live classroom
Free demo & orientation
Join us before anything begins — meet your instructor, watch a live sample lesson and get all your questions answered. No commitment required.
AI assistants and IDE integration
Claude, ChatGPT and JetBrains AI
Open-source and local assistants, plus security
Agentic workflows and automation
Capstone: spec, architecture and data layer
Capstone: natural language to SQL
Capstone: interface, users and observability
Capstone: deploy, harden, document and demo
Live lessons
Learn together, online
Live Google Meet classroom
Every lesson happens in a private Google Meet room with screen sharing, code-alongs and instant help.
WhatsApp study group
Stay connected between sessions — homework help, classmates and weekly reminders in one group.
What you'll work with
Ready to start building?
Pre-book your seat for the 3 October cohort — or join the free demo and see for yourself.