Dbeaver Database Tool Course

Lesson 1 • Configuring Preferences and Settings

Adjusts global preferences for fonts, themes, and auto-save behavior. Proper configuration reduces friction throughout the course.

Lesson 2 • Navigating the DBeaver Interface

Maps the main UI panels: Database Navigator, SQL Editor, and Properties view. Builds spatial familiarity before hands-on work begins.

Lesson 3 • Installing DBeaver on Your System

Guides installation on Windows, macOS, and Linux platforms. Ensures every student has a functional baseline installation.

Lesson 1 • Connecting to Cloud and Remote Databases

Configures SSH tunnels and cloud-hosted database endpoints. Extends connection skills to modern cloud infrastructure.

Lesson 2 • Creating a New Database Connection

Walks through the New Connection wizard step by step. Students create their first live connection to a relational database.

Lesson 3 • Understanding Connection Concepts

Explains JDBC drivers, connection strings, and authentication types. Provides the conceptual foundation for all connection tasks.

Lesson 4 • Managing Multiple Connections

Organizes connections into folders and switches between active sessions. Supports real-world workflows with many simultaneous databases.

Lesson 1 • Inspecting Tables and Columns

Opens table properties to review column definitions, data types, and constraints. Directly supports query writing in later chapters.

Lesson 2 • Browsing the Database Navigator

Uses the Navigator tree to expand schemas and locate objects. Establishes efficient object discovery habits.

Lesson 3 • Exploring Views, Indexes, and Sequences

Inspects non-table objects that affect query performance and data access. Broadens structural understanding beyond base tables.

Lesson 4 • Viewing Stored Procedures and Functions

Locates and reads stored routines within the Navigator. Prepares students to work with procedural database logic.

Lesson 1 • Using Auto-Complete and Code Assist

Leverages DBeaver's context-aware auto-complete for tables, columns, and keywords. Reduces typing errors and speeds query authoring.

Lesson 2 • SQL Editor Fundamentals

Introduces the SQL Editor's tabs, syntax highlighting, and keyboard shortcuts. Efficient editor use accelerates all query work.

Lesson 3 • Executing Queries and Reading Results

Runs single and multi-statement scripts and interprets the Results panel. Connects execution mechanics to result interpretation.

Lesson 4 • Managing SQL Scripts and History

Saves scripts to disk and retrieves past queries from execution history. Promotes reuse and auditability of SQL work.

Lesson 1 • Working with Large Text and Binary Data

Opens and edits CLOB, BLOB, and JSON column values using specialized editors. Handles data types that cannot be edited inline.

Lesson 2 • Using DML Statements in the Editor

Writes and executes INSERT, UPDATE, and DELETE statements in the SQL Editor. Reinforces SQL-based data manipulation alongside grid editing.

Lesson 3 • Understanding Transaction Control

Explains auto-commit mode versus manual transactions and their risks. Prevents accidental data loss during editing sessions.

Lesson 1 • Generating and Running SQL Dumps

Produces DDL and DML dump scripts for backup and migration purposes. Provides a portable, text-based data transfer method.

Lesson 2 • Copying Data Between Databases

Uses the Data Transfer tool to move data directly between two live connections. Eliminates intermediate file steps for cross-database migration.

Lesson 3 • Exporting Query Results

Exports result sets to CSV, JSON, Excel, and other formats via the export wizard. Covers the most common data-sharing workflow.

Lesson 1 • Creating Tables with the Visual Editor

Builds new tables by defining columns, types, and constraints in a form-based UI. Reduces DDL syntax errors for common table creation tasks.

Lesson 2 • Altering Existing Tables

Adds, renames, and drops columns and constraints on live tables. Supports iterative schema evolution during development.

Lesson 3 • Managing Indexes and Constraints

Creates and removes indexes, foreign keys, and unique constraints visually. Directly impacts query performance and data integrity.

Lesson 4 • Comparing and Synchronizing Schemas

Uses DBeaver's schema compare tool to diff two databases and generate sync scripts. Supports deployment and environment alignment workflows.

Lesson 1 • Reading Query Execution Plans

Interprets EXPLAIN and EXPLAIN ANALYZE output rendered in DBeaver's visual plan viewer. Identifies costly operations before optimization.

Lesson 2 • Using the Query Profiler

Captures execution time and resource metrics using DBeaver's profiling features. Quantifies performance before and after optimization changes.

Lesson 3 • Working with Query Parameters and Variables

Uses DBeaver's parameter binding and variable substitution in scripts. Enables reusable, injection-safe query templates.

Lesson 4 • Monitoring Active Sessions and Locks

Views active database sessions and lock conflicts through DBeaver's session manager. Enables real-time diagnosis of blocking and deadlock issues.