DBeaver Essential Training

Focused View

Adam Wilbert

3:14:12

0 View

[1] Introduction

[1] Database management with DBeaver.mp4

01:10

[2] What you should know.mp4

00:40

[3] Using the exercise files.mp4

00:33

[2] 1. Getting to Know DBeaver

[1] What is DBeaver.mp4

05:46

[2] Touring the interface.mp4

07:02

[3] Explore the DBeaver sample database.mp4

10:04

[4] Create your own database connections.mp4

07:17

[5] Add a PostgreSQL connection.mp4

08:15

[3] 2. Organize the Workspace with Projects

[1] Create and manage DBeaver projects.mp4

10:11

[2] Store bookmarks to database objects.mp4

04:35

[3] Set an active project.mp4

01:34

[4] Add and link external files to the project.mp4

03:38

[5] Customize the project explorer.mp4

03:17

[6] Export and import projects.mp4

03:21

[4] 3. Working with Tabular Data

[1] View and organize table data.mp4

09:17

[2] Filter rows shown in the results.mp4

06:29

[3] Apply custom column filters.mp4

03:22

[4] Finding specific values in the results.mp4

03:02

[5] View summary statistics with the Calc panel.mp4

04:02

[6] Obtain group statistics for a dataset.mp4

03:24

[7] View execution history with the Query Manager.mp4

02:31

[8] Edit data values.mp4

04:37

[5] 4. Database Objects and Structures

[1] Explore and modify object properties.mp4

07:22

[2] Create a new table object.mp4

03:36

[3] Compare table structures.mp4

04:46

[4] Export data from a table.mp4

06:22

[5] Import data to a table.mp4

04:25

[6] Generate valid SQL commands.mp4

02:44

[6] 5. Entity Relationship Diagrams

[1] View and understand an ER diagram.mp4

05:05

[2] Configure an ER diagram.mp4

07:20

[3] Save and print an ER diagram.mp4

01:18

[7] 6. Writing Commands with the SQL Editor

[1] SQL scripts and the SQL console.mp4

04:36

[2] Execute queries using the SQL console.mp4

06:10

[3] Useful query writing techniques.mp4

04:39

[4] Create and save project scripts.mp4

04:39

[5] Save time with SQL templates.mp4

04:59

[6] Improve legibility by formatting scripts.mp4

02:40

[8] 7. Additional Features of Enterprise Edition

[1] Creating charts from data results.mp4

04:40

[2] Build queries with a visual editor.mp4

05:45

[3] Generate sample data for testing.mp4

03:55

[4] Compare two data sources.mp4

03:56

[9] Conclusion

[1] Next steps.mp4

01:08

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.