Statement vs. Batch Execution
Understand the difference between statement execution (Ctrl+Enter) and sequential batch scripts (Alt+X).
Structured Learning Syllabus
The Complete Database Programming Curriculum
Four progressive learning tracks designed to take you from writing basic SQL queries to architecting enterprise schemas and diagnosing microsecond query bottlenecks.
Level 01
SQL Scripting, Variables & Batch Execution
Master the core mechanics of DBeaver's SQL editor. Learn how to control execution streams, handle multi-statement delimiters, bind dynamic variables, and protect production databases.
Custom Delimiters in DBeaver
Configure --delimiter // and DELIMITER $$ to prevent parser collisions in multi-statement triggers.
Client-Side Variables & Parameters
Define reusable script values with @set and bind interactive values with :param prompts.
Level 02
Stored Procedures, Functions & Interactive Debugging
Write enterprise procedural routines in PL/pgSQL, PL/SQL, and T-SQL. Leverage DBeaver's debugger to place breakpoints, inspect memory frames, and step through routines.
Authoring Stored Routines
Create functions with input parameters, loop cursors, and table return types. Inspect compiler diagnostics.
PostgreSQL & Oracle Debugger Setup
Configure pldbgapi and debugger extensions to connect DBeaver's GUI to the database execution daemon.
Breakpoints, Stepping & Variables
Master F5, F6, and F7 stepping controls while watching live variables in the Variables View.
Level 03
Database Modeling, ER Diagrams & Architecture
Reverse-engineer physical database catalogs into Crow's Foot ER diagrams, define virtual constraints, and export clean DDL code.
Schema Reverse Engineering
Generate instant topological maps of foreign key relationships across entire database schemas.
Virtual Foreign Keys
Model logical joins on sharded or microservices databases without altering physical tables or schemas.
Exporting Models & DDL Generation
Export vector SVG architecture diagrams for team wikis and generate complete SQL DDL migration files.
Level 04
Query Optimization & Visual Explain Plans
Analyze execution trees, spot costly sequential scans, evaluate join strategies (Hash, Merge, Nested Loop), and eliminate disk spills.
Generating Visual Explain Plans
Invoke Ctrl+Shift+E to inspect optimizer trees, operator cost weights, and estimated row counts.
Diagnosing Bottlenecks & Scans
Identify full table scans, in-memory sorting spills to disk, and stale optimizer statistics.
SQL Refactoring Recipes
Practical patterns for converting correlated subqueries into high-speed hash aggregate joins.