Course Overview

Learn the basics of using the popular DBeaver universal database client. This course focuses on the DBeaver application, not on database development or writing SQL queries.

Course Circullum

Introduction

Database management with DBeaver
What you should know
Using the exercise files

1. Getting to Know DBeaver

What is DBeaver?
Touring the interface
Explore the DBeaver sample database
Create your own database connections
Add a PostgreSQL connection

2. Organize the Workspace with Projects

Create and manage DBeaver projects
Store bookmarks to database objects
Set an active project
Add and link external files to the project
Customize the project explorer
Export and import projects

3. Working with Tabular Data

View and organize table data
Filter rows shown in the results
Apply custom column filters
Finding specific values in the results
View summary statistics with the Calc panel
Obtain group statistics for a dataset
View execution history with the Query Manager
Edit data values

4. Database Objects and Structures

Explore and modify object properties
Create a new table object
Compare table structures
Export data from a table
Import data to a table
Generate valid SQL commands

5. Entity Relationship Diagrams

View and understand an ER diagram
Configure an ER diagram
Save and print an ER diagram

6. Writing Commands with the SQL Editor

SQL scripts and the SQL console
Execute queries using the SQL console
Useful query writing techniques
Create and save project scripts
Save time with SQL templates
Improve legibility by formatting scripts

7. Additional Features of Enterprise Edition

Creating charts from data results
Build queries with a visual editor
Generate sample data for testing
Compare two data sources

Conclusion

Next steps

Adam Wilbert

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: