DBeaver Tutorial - How to Use DBeaver (SQL Editor)

[@DatabaseStar]

Do you want to save time with DBeaver? Get my DBeaver Cheat Sheet here: databasestar.mykajabi.com/lpkj-dbeaver-cheat-sheet/?

[@Tranquility_00]

This is a very good quality video. Very focused, no time wasted. Thank you so much.

[@DatabaseStar]

Thanks Daniel! Glad you found it useful.

[@aliahyar3174]

simple tutorial, straight to the point and it's very clear. Thank you so much for this!!!!

[@DatabaseStar]

Thanks, glad you like it!

[@ecofirewall6676]

THANK YOU for this the import/export section was all that i was looking for & it really helped

[@DatabaseStar]

Great to hear that it helped!

[@PeterThornton]

This is just what i was looking for, clear and to the point. Thank you

[@DatabaseStar]

Glad it helped!

[@jcanino20]

Thank you for this. It was extremely helpful and informative, and I will be watching it again!!

[@DatabaseStar]

Thanks! Glad it was helpful. Are there any features in DBeaver you would like to see a tutorial on?

[@manishpatel2125]

Can it run PL/SQL

[@lekham4824]

@@DatabaseStar Can you make from scratch DBeaver full series playlist. Include each and every details and all we can do using DBeaver.

[@moatef1586]

This is a perfect tutorial. Thank you so much.

[@DatabaseStar]

You're welcome!

[@Програмистпограмистев]

Thank you very much for this good quality video. I both respect and appreciate the effort stands behind such a quality!

[@DatabaseStar]

Glad you enjoyed it!

[@Ironwally]

Thanks for the great video! Very nice exlanations and style of talking.

[@DatabaseStar]

Glad you liked it!

[@alexlee9773]

Thanks you very much for you detailed explanation and good quality video!!!!!

[@DatabaseStar]

Glad it was helpful!

[@olatunji2542]

This video was very helpful. Thank you so much

[@DatabaseStar]

Glad it was helpful!

[@charlsroy5830]

Great video, helpful. Thank you :)

[@DatabaseStar]

Glad it was helpful!

[@rafaelfonseca7942]

Got a new subscriber. Thanks for this video!

[@DatabaseStar]

Glad it was helpful!

[@shakazullu7734]

Muito bom este video. Obrigado 👍

[@DatabaseStar]

Thanks! You’re welcome.

[@Kennerdoll]

But how do you start by creating a Table minus the database itself? I was expecting to see CREATE DATABASE `DB Name`; as a first line

[@DatabaseStar]

Good point. This assumes you already have a database. If not, you'll need the Create Database command as you mentioned.

[@munyul]

Hi ... I'd really like to see a tutorial for the "Projects" tab, did you ever make one? A quick search through your videos didn't turn up anything. I'm new to DBeaver and am trying to setup a Project - the issue I have is that the scripts never open with a valid connection, so I can't run them - I have no idea what is going wrong there.

[@DatabaseStar]

I haven't made one yet, but I'll add it to my list of future videos. Thanks for reminding me!

[@boulettefranck2627]

Thank you for your excellent work !

[@DatabaseStar]

You’re welcome!

[@jillian-gallays]

Great video. I followed your steps BUT when I go to schemas - public - tables: there is nothing inside. I dont have a list like yours (Adress, address_status....test_tables) How do I get that list?

[@DatabaseStar]

Thanks! Oh those tables are there because I had already created them on the database, probably to set up data for other videos. If you don’t see them it’s because your database and tables would be different to mine, and that’s ok.

[@Thebubble77]

Great video, very helpful. Thank you!

[@DatabaseStar]

Glad it was helpful!

[@abdurrazzak1612]

I installed today. Its awesome

[@DatabaseStar]

Glad to hear!

[@rajatsharma5892]

Awesome! Thanks, This video helped me a lot.

[@DatabaseStar]

Glad it helped!

[@joshuakaufmann4081]

That was very helpful. Thankyou

[@DatabaseStar]

Glad it was helpful!

[@nicog_99]

I accidently closed the database navigator... Where can i open it again? Cant find it

[@DatabaseStar]

I think you can open it again from Windows - Database Navigator.

[@axelef2344]

It's very promising. Big gain of knowledge in short time. I'll try to stick to your channel in spite of my ADD😅

[@DatabaseStar]

Thanks!

[@igorhefner]

great quality, subscribed!

[@DatabaseStar]

Much appreciated!

[@jlbardinas1]

Can you please show how to create a Database Dump in Dbeaver-CE?

[@DatabaseStar]

Sure, good idea!

[@prashlovessamosa]

Thank you 🙏

[@DatabaseStar]

You’re welcome!

[@Bammmmmmm]

very nice video, what is the possibility of creating a database dump and loading onto AzureSQL using DBeaver, thank you!

[@DatabaseStar]

Thanks! You can use the DBeaver import process to load a dump into a database if you need.

[@korleone72]

thank you for the review

[@DatabaseStar]

No problem!

[@machocorpse6929]

Why is my select not capitalized, how can I fix this?

[@DatabaseStar]

There's a setting in DBeaver: Go to Preferences > General > Editors > SQL Editor > SQL Formatting. Then under Auto Format there is a box for Convert Keyword Case.

[@machocorpse6929]

@@DatabaseStar thanks

[@PhNg1111]

Hi, I got trouble in running cte in DBeaver. My cte name is not recognized at main query, even though the query still works. This problem causes me to have to enter column names letter by letter instead of using tabs.

[@DatabaseStar]

Oh that's odd. Perhaps there's a caching issue with the name of the subquery not being recognised. Or perhaps DBeaver doesn't recognise it - as in, it's a bug in DBeaver.

[@mohammadzacharyabidin9780]

Hey, I wonder.. How can I download all the query codes from dbeaver?

[@DatabaseStar]

You can save the SQL queries you write as SQL files on your computer.

[@willywooca]

Can I run 2 queries together, and display the 2 results together at the bottom(one after the other)? Similar to what SSMS does?

[@DatabaseStar]

You may be able to do this if you select both queries and click the Execute button.

[@y-dv6qo]

How can I create a chart after executing a SQL query please?

[@DatabaseStar]

There may be a DBeaver feature for this, otherwise I think you would have to use a tool like Excel.

[@sorapple1129]

Thanks for good tutorial. What is the issue for all tables under public/tables are not showing any table name (postgresql db). Thanks

[@DatabaseStar]

Thanks, glad you like it!

[@codingjhames]

Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Connection refused Connection refused

[@DatabaseStar]

I assume this is Postgres? Is your database running, and is it on that port?

[@mohammedalsarraj9963]

Could we connect it with ms access?

[@DatabaseStar]

Possibly, I'm not sure and I haven't tried it, but it might be possible.

[@firojtasildar6367]

Can you make a video on how to make connection to oracle database

[@DatabaseStar]

Sure! I've got one here using SQL Developer: kzbin.info/www/bejne/iqXdlGWNeLCWhNE But I don't have one for using DBeaver.

[@SalvadorEspinosa-b9k]

at 1:25 what is the password here? also considering that iam using a work laptop, am I still able to download it? Because i have user admin password access. but still not sure which password to use here. iam getting the following error when testing connecting:" Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Connection refused: no further information Connection refused: no further information" tysm

[@DatabaseStar]

The password is the one for your database when it was set up, either by you or by people at work. It would be different to the password I am using. You may be able to download it, but you should check your IT policy to see if you’re allowed to download applications that may not be approved.

[@MBorky2]

Connection refused: connect I just installed postgradeSQL 14 and DBBeaver, but Iam not able to conneted according this video.

[@DatabaseStar]

Oh. Is there any other information about the connection error?

[@giridhark1280]

How to unlock a table in DBeaver if its get locked?

[@DatabaseStar]

I think it depends on your database vendor, but it should unlock when the transaction that is locking it has finished.

[@vineethreddy7072]

how to solve this "dbeaver error can't init data transfer Reason can't create or update target table"

[@DatabaseStar]

Oh I'm not sure how to resolve that, but there's probably an answer to it on StackOverflow.

[@the3amverses839]

Thank you!

[@DatabaseStar]

You're welcome!

[@francoiscoetzee9452]

Thank you

[@DatabaseStar]

You're welcome

[@chrispotterfan]

What management software is the best for the database firebird? I'm used to SSMS for microsoft sql servers.

[@DatabaseStar]

I haven't used Firebird at all, so I'm not sure what would be the best. However, DBeaver is pretty good, so if it works for Firebird you could try that.

[@ZillianRain-pd7jk]

how to write a query from difference database in dbeaver

[@DatabaseStar]

What do you mean?

[@ZillianRain-pd7jk]

@@DatabaseStar , from different micro service database

[@LotusSoftPvtLtd]

Great tutorial.

[@DatabaseStar]

Thanks!

[@s734music]

Great explanation. I'm disappointed that DBeaver locks up basic and essential stuff like ERD behind the pricey Enterprise subscriptions. New users will find themselves paying way more than they ever expected to get necessary functions or having to switch to something free like PGAdmin that includes a visual ERD tool in every install.

[@DatabaseStar]

Thanks! Yeah that is disappointing for something that is a common feature

[@YogiGhorecha]

I can not see relationship between tables

[@DatabaseStar]

It could be that there are no foreign key constraints in the tables.

[@deenaa_0193]

amazing content

[@DatabaseStar]

Thanks!

[@paulobiscocho9042]

Great video!

[@DatabaseStar]

Thanks!

[@rahulagarwal968]

Can i install DBeaver even if I have already installed xamp for mysql and pgadmin for postgres. Since DBeaver supports both. Which GUI software will you suggest me to use as a beginner ?

[@DatabaseStar]

Yes you can install dbeaver if you have those installed. Dbeaver is a good tool to use as a beginner, I find it easy to use and it’s quite popular so there is a lot of support if you have issues.

[@firstsurname2478]

so ultimately this piece of software CANNOT save database schema? I wasted a day on this with no luck

[@DatabaseStar]

What do you mean by "save database schema"? Do you mean save the data into your tables within a schema? Or save the SQL script you use to set up your database? Or something else?

[@74Bagas]

wow.. thank you

[@DatabaseStar]

No problem!

[@barbierubogdan4619]

sa ...I don't even have a available device where i can download it

[@DatabaseStar]

Ah well that would make it hard to use DBeaver...

[@khushdeepsingh8778]

Can anyone please help, if i want to join table x from db1 with table y from db2. Is this possible with dbeaver?

[@DatabaseStar]

I think so, but it would depend on the database vendor you're using and if those features are supported. In Oracle, for example, you can use a concept called a "database link" to query a table from another database.

[@oshoosho4604]

query builder!!!!!!

[@DatabaseStar]

Do you mean, you’d like a tutorial on query builder?

[@oshoosho4604]

@@DatabaseStar obviously

[@ianrickey208]

Subscribed.

[@DatabaseStar]

Thanks!

[@sumeennaazshaik1214]

helpful

[@DatabaseStar]

Thanks!

[@Music-tp8gg]

nice video

[@DatabaseStar]

Thanks

[@karandullet380]

I just wanted to edit game stats 🥲

[@DatabaseStar]

You can use SQL to edit game stats, assuming you have the data in an SQL database. Where is the data now?

[@azizbekmaqsudov8742]

when i press sapce after writing any word with uppercase it turns into lower case letters. why?

[@DatabaseStar]

I am guessing it's some kind of auto-format feature within DBeaver..