DBeaver Essential Training

Course details

Are you looking for an alternative to your database platform’s native tools? DBeaver is the universal database client that allows you to work with a wide variety of data platforms from a single interface. In this course, database expert Adam Wilbert shows you how to leverage this powerful tool. Adam gives you a tour of the interface and explains how to create your own database connections and add a PostgreSQL connection. He steps through how to use projects to organize your workspace, as well as the views, filters, and panels you might use when working with tabular data. After exploring how to create and modify database objects and structures, Adam covers how to configure, save, and print an entity relationship (ER) diagram. He offers useful tips on writing commands with the SQL Editor, then concludes with a discussion of some additional features that you might use in the Enterprise Edition.

Concepts

0. Introduction

01 - Database management with DBeaver
02 - What you should know
03 - Using the exercise files

1. Getting to Know DBeaver

04 - What is DBeaver
05 - Touring the interface
06 - Explore the DBeaver sample database
07 - Create your own database connections
08 - Add a PostgreSQL connection

2. Organize the Workspace with Projects

09 - Create and manage DBeaver projects
10 - Store bookmarks to database objects
11 - Set an active project
12 - Add and link external files to the project
13 - Customize the project explorer
14 - Export and import projects

3. Working with Tabular Data

15 - View and organize table data
16 - Filter rows shown in the results
17 - Apply custom column filters
18 - Finding specific values in the results
19 - View summary statistics with the Calc panel
20 - Obtain group statistics for a dataset
21 - View execution history with the Query Manager
22 - Edit data values

4. Database Objects and Structures

23 - Explore and modify object properties
24 - Create a new table object
25 - Compare table structures
26 - Export data from a table
27 - Import data to a table
28 - Generate valid SQL commands

5. Entity Relationship Diagrams

29 - View and understand an ER diagram
30 - Configure an ER diagram
31 - Save and print an ER diagram

6. Writing Commands with the SQL Editor

32 - SQL scripts and the SQL console
33 - Execute queries using the SQL console
34 - Useful query writing techniques
35 - Create and save project scripts
36 - Save time with SQL templates
37 - Improve legibility by formatting scripts

7. Additional Features of Enterprise Edition

38 - Creating charts from data results
39 - Build queries with a visual editor
40 - Generate sample data for testing
41 - Compare two data sources

Conclusion

42 - Next steps