Training course · Claude Code · SQL & Databases

Claude Code for SQL and Database Professionals

Agentic coding with Claude Code in the terminal and IDE: CLAUDE.md, subagents, hooks, MCP, CI pipelines and secure permissions.

Duration
2 days (14 hrs)
Format
Online or on-site
Language
German or English
Participants
open dates or exclusive for your team
Certificate
Certificate of attendance

Overview

“Claude Code for SQL and Database Professionals” is a hands-on course for roles such as Database and SQL developers, Database administrators for PostgreSQL, SQL Server, Oracle or MySQL and Backend developers responsible for data models and ORM layers. Rather than learning Claude Code in the abstract, you work on tasks from your daily routine – with examples, exercises and templates from SQL & Databases.

Claude Code is Anthropic’s agentic coding assistant, working directly in your terminal and in popular IDEs. Rather than completing individual lines, it reads your repository, plans changes across multiple files, runs commands, executes tests and prepares commits. Over two days you will learn to use it with deliberate control: clear project instructions in CLAUDE.md, careful context management, and a workflow in which you set the direction as a developer and can trace every change the agent makes back to a clear intention.

The course is built around real engineering work: diagnosing bugs, delivering features, refactoring legacy code and filling gaps in test coverage. You will configure subagents for specialised tasks, enforce quality checks with hooks, connect external systems through the Model Context Protocol (MCP) and capture team knowledge as reusable skills. Finally, you will run Claude Code headless in CI pipelines and define permissions, sandboxing and approval rules so that its use remains defensible even in security-sensitive environments.

Databases are the memory of every application, and their performance, consistency and security determine whether entire systems succeed. AI coding assistants and agents support database developers and DBAs in writing complex queries, reading execution plans, designing schemas and index strategies and migrating between database platforms. They translate business questions into SQL, refactor sprawling stored procedures and generate test data. One principle still holds: a syntactically valid query is not necessarily a correct one, and an agent with write access to production data is a serious risk. In this course you learn to use AI productively with schema context, execution plans and tests, and to design access so that your data stays protected at all times.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Who is this course for?

  • Database and SQL developers
  • Database administrators for PostgreSQL, SQL Server, Oracle or MySQL
  • Backend developers responsible for data models and ORM layers
  • Data engineers and analytics engineers
  • BI developers working with complex reporting queries

Typical challenges we address

  • Slow queries and load spikes whose causes are hidden in execution plans
  • Sprawling stored procedures and triggers without documentation or tests
  • Risky schema changes and migrations on live systems
  • Different SQL dialects during platform changes or in multi-database estates

What you will be able to do

  • You use Claude Code for multi-step development tasks while keeping full control over every change.
  • You maintain a CLAUDE.md that effectively conveys project conventions, commands and architectural guidance to the agent.
  • You extend Claude Code with subagents, hooks, MCP servers and skills tailored to your team.
  • You integrate Claude Code into Git workflows and CI pipelines with traceable, test-backed results.
  • Optimise queries and indexes with AI support based on execution plans rather than guesswork.
  • Plan and test schema changes and database migrations using generated scripts and rollback strategies.
  • Design database access for AI agents securely, with least privilege, read replicas and traceable queries.

Course outline

Day 1

Module 1 How Claude Code works
  • Installation, sign-in and use in the terminal, VS Code and JetBrains IDEs
  • Understanding the agentic loop: read, plan, act, verify
  • Using plan mode to agree on an approach before any code changes
  • Writing effective task briefs with goal, context and acceptance criteria
Module 2 Project context with CLAUDE.md and context management
  • Structuring CLAUDE.md at project, directory and user level
  • Documenting build, test and style conventions so the agent follows them reliably
  • Managing the context window with targeted file references, compaction and fresh sessions
  • Resuming sessions and breaking long tasks into manageable stages
Module 3 Extending Claude Code with subagents, hooks, MCP and skills
  • Defining subagents for code review, research or test generation
  • Using hooks to enforce formatting, linting or checks before and after tool calls
  • Connecting MCP servers for issue trackers, databases or internal documentation
  • Creating custom slash commands and skills for recurring team workflows
Module 4 Git workflows, testing and quality assurance
  • Creating branches, meaningful commits and pull requests with Claude Code
  • Test-first work: have tests written before the implementation
  • Reviewing diffs systematically and rejecting or refining changes
  • Organising parallel work with Git worktrees and multiple sessions

Day 2

Module 5 Headless operation, CI and security
  • Running Claude Code non-interactively in scripts and CI pipelines
  • Automated reviews and issue handling in GitHub or GitLab workflows
  • Configuring permission modes, allow and deny rules, and sandboxing
  • Handling secrets, prompt injection risks and organisation-wide policies
Module 6 Practice lab: SQL & Databases
  • Optimising SQL queries
  • Designing and reviewing schemas
  • Refactoring stored procedures
  • Planning migrations safely
  • Translating dialects
  • Generating test data
Module 7 Data protection, quality & transfer to daily work
  • Databases often hold personal and business-critical data: you learn to give AI tools schemas and anonymised samples instead of production data, manage credentials securely and implement GDPR requirements such as data minimisation and deletion policies.
  • Ground rules for safe AI use in your team
  • Checking results: facts, sources, tests and the four-eyes principle
  • Personal action plan for the next 30 days
  • Open questions, outlook and resources for further learning

Practical scenarios from your field

Optimising SQL queries

Have execution plans from EXPLAIN ANALYZE or Query Store interpreted, identify bottlenecks such as full table scans or poor join orders and get rewritten queries and suitable indexes with a clear rationale.

Designing and reviewing schemas

Derive normalised data models with keys, constraints and data types from requirements, review existing schemas for redundancy and missing integrity rules and generate ER diagrams.

Refactoring stored procedures

Explain large PL/SQL or T-SQL procedures, convert cursor loops into set-based logic, standardise error handling and add tests with frameworks such as tSQLt or pgTAP.

Planning migrations safely

Generate versioned migration scripts for Flyway or Liquibase, design zero-downtime strategies such as expand and contract and assess rollback paths as well as effects on locking and replication.

Translating dialects

Migrate queries, functions and data types between Oracle, SQL Server, PostgreSQL and MySQL, account for differences in date functions, sequences and transaction behaviour and test for identical results.

Generating test data

Create realistic synthetic datasets that respect constraints, distributions and edge cases without using personal production data, for load tests and development environments. Generators live in the repository under version control.

Possible hands-on projects

Slow query analyser

A script that processes the slow query log or statistics views, groups the most expensive queries and reports concrete index and rewrite suggestions.

Schema documentation generator

A tool that reads a database schema and produces searchable documentation with table descriptions, relationships and an ER diagram. It refreshes automatically after each migration.

Text-to-SQL assistant

A small web app with read-only access to a reporting database that turns business questions into checked SQL and shows both query and result transparently.

Prerequisites

You have hands-on programming experience in at least one language and are comfortable with Git and the command line. You write SQL regularly, understand joins, aggregations and indexes and work with at least one relational database system.

Technical requirements

Your own laptop with admin rights, Git, a Node.js runtime and an up-to-date editor; a Claude subscription or Anthropic API access is required for the exercises.

Data protection & compliance

Databases often hold personal and business-critical data: you learn to give AI tools schemas and anonymised samples instead of production data, manage credentials securely and implement GDPR requirements such as data minimisation and deletion policies.

Suggested dates

All dates are suggestions – your preferred date is always possible.

  • Mon, 23 November 2026 – Tue, 24 November 2026 Online Request
  • Mon, 30 November 2026 – Tue, 1 December 2026 Augsburg Request
  • Tue, 15 December 2026 – Wed, 16 December 2026 Online Request
  • Wed, 13 January 2027 – Thu, 14 January 2027 Online Request
  • Tue, 26 January 2027 – Wed, 27 January 2027 Kaiserslautern Request
  • Mon, 8 February 2027 – Tue, 9 February 2027 Online Request

Frequently asked questions

How is Claude Code different from traditional code completion?

Code completion suggests the next few lines, whereas Claude Code acts as an agent that handles whole tasks: it searches the repository, plans changes across several files, runs tests and commands, and corrects itself based on the results. You define the goal and review the outcome instead of steering every single line yourself.

Is Claude Code secure enough for enterprise use?

By default, Claude Code asks for approval before editing files or running commands. Permission rules, sandboxing, managed settings and hooks let you define precisely what the agent may do. During the course you learn to configure these mechanisms to match your security and data protection requirements and to assess risks such as prompt injection.

Does Claude Code work with my language and tech stack?

Yes. Claude Code is language-agnostic because it works with files, terminal commands and your existing build and test tooling. Whether you use Python, Java, TypeScript, Go, SAP-related code or infrastructure as code, what matters most is a well-written CLAUDE.md describing your commands and conventions. Each course variant adds the relevant domain focus.

Should an AI agent access our database directly?

It can, but it needs careful planning. We recommend a dedicated read-only user, access to replicas or development databases rather than production, query timeouts and logging of every statement. Write changes go through versioned migration scripts with review. In the course you build exactly this safeguard, for instance through a restricted MCP server.

How reliable is AI-generated SQL?

It is usually syntactically correct, but semantic quality depends heavily on context: without the schema, relationships and business definitions, wrong joins or double counting creep in easily. With schema context, example queries and tests against known results, reliability rises considerably. You learn to validate generated queries systematically.

How much does “Claude Code for SQL and Database Professionals” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 2 training day(s) with a live trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. Our suggested dates are just a guide. In the request form you can always describe your preferred date or period in free text – we check availability and confirm within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart or Kaiserslautern. We can also run the course exclusively for your team.

More courses for SQL and Database Professionals

More Claude Code courses

All 77 Claude Code courses

Claude Code · MunichClaude Code · SalzburgClaude Code · BerlinClaude Code · AugsburgClaude Code · HanoverClaude Code · BremenClaude Code · StuttgartClaude Code · KaiserslauternClaude Code · Online