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.
Syllabus
-
Introduction
- Database management with DBeaver
- What you should know
- Using the exercise files
- What is DBeaver?
- Touring the interface
- Explore the DBeaver sample database
- Create your own database connections
- Add a PostgreSQL connection
- 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
- 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
- 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
- View and understand an ER diagram
- Configure an ER diagram
- Save and print an ER diagram
- 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
- Creating charts from data results
- Build queries with a visual editor
- Generate sample data for testing
- Compare two data sources
- Next steps
