DBEAVER TUTORIAL PLUS

Inside of the Chapter 2 folder, you'll find a project file that we can work with for the Two Trees Olive Oil company. Then I need to browse to the file that I want to connect to.

And if you're not seeing it right there, you can just search for it or find it inside of the SQL group there. We're going to add a connection to a SQLite database, so I'll choose that option here from the list. Right-click on the Connections container, point to Create and choose Connection. Now let's add a database connection to the project. And I can see that we have Connections, Bookmarks, ER Diagrams and Script folders already set up. Now we have our new Two Trees Olive Oil company project listed here inside of the Projects view. I'll leave the rest of the default options as they are, and just come down and press the Finish button. Then I'll press the Select Folder button, and it'll place that file path here into this location's bar right there. I'll press New Folder button there, and I'll call it Two Trees Olive Oil. To do that, once it's unchecked, you can click on this Browse button, and then I'll browse out to my desktop, go into Exercise Files, Chapter 2, and I'm going to create a new folder here. I'm actually going to untick this checkbox that says, use default location, and place my project inside of the course's Exercise Files folder. And you can see the URL for that right here. You could choose to store the project in the default DBeaver workspace. I'm going to create a new project for the Two Trees Olive Oil company.

DBEAVER TUTORIAL PLUS

It has a little box with a plus symbol icon. To create a new project, click on this button up here on the Projects tool bar. It's often useful to create projects for different clients that you might work with or to organize sets of resources for different departments within your organization. Now you can create as many projects as you'd like. Now beyond these three folders that we have here at the bottom, you can add in additional folders to organize your content however you'd like, and either store copies or links to any files on your local computer. I often use just the Projects view since it gives me access to everything in a single location. All the same features are available in any of these view tabs. So you can choose to use whichever view you find most useful. And the other three folders inside of this project are also available down in the Project view down here at the bottom of my screen. The Contents folder shows the same connections that are available inside of the Database Navigator view. Now you may have realized that the Project view that we're looking at right now is duplicating access to your content that's available in the other views that we have here in DBeaver. And the Scripts folder is used to organize structured query language script files, so you can save and re-execute frequently used queries and commands without having to rewrite them over and over again. The ER Diagrams folder will store a customized entity relationship diagrams that you create for your databases. The Bookmarks folder is used to store quick links to data tables and views that you want to access regularly. The other three folders that we have inside of our General project are used to organize related resource files that are stored on our local file system outside of any database. In fact, if you open it up, you'll find that it already contains all of the database connections that we've previously established. The Connections folder works exactly like the Database Navigator view. When you expand it, you'll find that we have four folders inside of it, that groups some of our resources together. In the Projects view, if I switch over to it, you'll find that we already have a default project called General. And the DBeaver Projects feature allows you to bring together and organize all of your resources in a single location. In data science, it's common to need to work with a mixture of database and external files that are stored on your local computer.

Dbeaver tutorial