Training course · Windsurf · SQL & Databases

Windsurf for SQL and Database Professionals

Develop with the Windsurf AI IDE and its Cascade agent: flows, memories, rules, workflows and safe use across the team.

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

“Windsurf for SQL and Database Professionals” is designed 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 and shows step by step how to use Windsurf productively, safely and transparently in SQL & Databases – from the fundamentals to advanced workflows.

Windsurf is an AI-powered development environment built around its agent, Cascade. Cascade understands the structure of your project, follows your actions in the editor and terminal, and works with you according to the flow principle: you and the agent take turns on the same task without having to re-explain context over and over. In this two-day course you will learn how to use Cascade effectively for features, debugging and refactoring, and how to make the most of intelligent completion in your daily development work.

To keep results consistent across a team, you steer Cascade with global and workspace rules, rely on memories for lasting project knowledge and automate recurring procedures with workflows that run from a slash command. You will connect external tools through MCP, control how terminal commands are executed and decide which data Cascade is allowed to see. Finally, you will define rules for code review, security and data protection so that Windsurf can be used responsibly within your organisation and its existing processes.

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 Cascade productively in flow for features, debugging and refactoring.
  • You steer Windsurf’s context precisely and keep sensitive content protected.
  • You maintain memories and rules that reliably enforce your project conventions.
  • You automate recurring procedures with workflows and connect external tools via MCP.
  • 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 Getting to know Windsurf and Cascade
  • Installation, importing existing editor settings and basic configuration
  • Cascade in code and chat mode: when the agent edits and when it only advises
  • The flow principle: how Cascade takes your editor and terminal actions into account
  • Intelligent completion and inline commands in everyday development
Module 2 Steering context
  • Understanding codebase indexing and referencing relevant files or directories
  • Bringing documentation, web sources and terminal output into context
  • Excluding sensitive content from context with ignore files
  • Structuring sessions and starting afresh when the topic changes
Module 3 Memories and rules for consistent results
  • Reviewing and maintaining auto-generated and manually created memories
  • Creating and versioning global and workspace rules
  • Expressing architecture, style and testing guidelines as effective rules
  • Activating rules selectively by file pattern or occasion
Module 4 Workflows and automation
  • Defining recurring procedures as workflows and launching them via slash command
  • Building workflows for release preparation, testing or code maintenance
  • Connecting MCP servers for issue trackers, databases or internal services
  • Controlling terminal command execution with allow and deny lists

Day 2

Module 5 Quality, review and governance
  • Tracing Cascade’s changes, accepting them partially or reverting them
  • Using a test-driven approach and preview features for verification
  • Team settings, data protection options and handling of secrets
  • Defining review processes and accountability for AI-generated code
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 program regularly in at least one language and are familiar with Git and a modern IDE. You write SQL regularly, understand joins, aggregations and indexes and work with at least one relational database system.

Technical requirements

Your own laptop with the Windsurf editor, Git and your usual toolchain installed; a Windsurf account with access to Cascade is required.

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.

  • Thu, 26 November 2026 – Fri, 27 November 2026 Online Request
  • Mon, 7 December 2026 – Tue, 8 December 2026 Stuttgart Request
  • Tue, 19 January 2027 – Wed, 20 January 2027 Online Request
  • Tue, 2 February 2027 – Wed, 3 February 2027 Berlin Request
  • Tue, 16 February 2027 – Wed, 17 February 2027 Online Request
  • Mon, 22 February 2027 – Tue, 23 February 2027 Munich Request

Frequently asked questions

What does Windsurf mean by flows?

Flows describe the close collaboration between you and Cascade. The agent observes what you do in the editor and terminal and takes those actions into account in its next steps. As a result you do not have to keep explaining where you are, and you can move smoothly between doing the work yourself and delegating it to the agent.

How do memories, rules and workflows differ?

Memories store knowledge that Cascade has gathered while working or that you have explicitly recorded. Rules are guidelines you write that shape the agent’s behaviour permanently. Workflows are reusable sequences of steps for recurring tasks, launched with a slash command. Together they keep results consistent across the whole team.

Can I use Windsurf with my existing projects and languages?

Yes. Windsurf is language-agnostic and works with your existing toolchain, including build tools, package managers and test frameworks. Whether you work on back end, front end, data processing or infrastructure code, what matters is giving Cascade good rules and clear context. Each course variant adds the specific focus for your field.

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 “Windsurf 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 Windsurf courses

All 32 Windsurf courses

Windsurf · MunichWindsurf · SalzburgWindsurf · BerlinWindsurf · AugsburgWindsurf · HanoverWindsurf · BremenWindsurf · StuttgartWindsurf · KaiserslauternWindsurf · Online