My Favourite SQL Tool - Navicat Tutorial

[@blakevorwerk4732]

I’ve been waiting so patiently🎉😇

[@definitelynorandomvideos24]

Thanks for the great video Adam. I use different tools for professional or private projects but your explanation helped in also understanding some fundamentals that I didn't really consider yet or simply didn't know yet (e.g. default ports). Your videos are truly amazing!

[@LearnBI]

Thank you 🙏🏻

[@Adiyat_Coto]

Hi Adam, thank you! Will use this way of explanation to my team.

[@ahmadsaeb5659]

Thanks Mr.Adam it was so useful!❤

[@danielgutzz]

Very helpful dude! Thank you

[@LearnBI]

You’re welcome!

[@junelpoblete6211]

Hi sir, I've learned more about utilizing Navicat. By the way, do you have any idea how to use Navicat Cloud?

[@LearnBI]

I don't use it myself but I may be researching and making a video on it in the coming weeks.

[@finldavi]

Thanks for this. I am on the fence between buying Navicat or FlySpeed SQL Query. Do you have any experience with the latter?

[@LearnBI]

No, I’m afraid not.

[@GeanissaUtami]

Hallo sir, thank you for your videos. I wanna asking you something. I've used navicat premiun version 11, yups the old version of navicat premium. My problem is, sometimes when I copy data from server one to another server on my navicat premium, the data can't to replace/copy? maybe you have some experience like it. thank you sir, have a good day!

[@LearnBI]

I recommend you contact Navicat support 👍🏻

[@Eeatch]

I also have a problem where connction is crreated but after execution of sql file it does not appear in my connection UPD: I just needed to create a db first and name it as an desired executable sql file, and doubleclick on a created database and then rightclick on it, and select in a dropdown menu Execute SQL... So it is working now. And no errors occured during execution

[@JobsonAndradeFilho]

Show!!!! Tanks, Agradecido, Merci...

[@LearnBI]

My pleasure!

[@hanasamamori4293]

hello I have a question. i can buy 1 license standard for logout pc and login notebook again?

[@LearnBI]

This might help: help.navicat.com/hc/en-us/articles/217757208-Can-I-deploy-one-license-for-both-Desktop-and-Laptop#:~:text=Please%20note%20that%20each%20license,Navicat%20on%20the%20primary%20computer.

[@dannitangherli]

Everyt ime I try to create a new connection it tells me "Test Failed". I followed all the steps but I think there is an issue with the host. Please help. I cant find any videos or posts to help me.

[@LearnBI]

I’m sorry but unless I have a lot more information about what you’re working with and what you’ve done so far, it’s impossible for me to help.

[@SYNC4646]

I also can't create a new connection for my SQL. Every time it gives me the error which says (can't connect to the localhost)

[@harrydmonel]

i have problem with importing data dump using navicat. Can you make a video tutorial?

[@LearnBI]

What seems to be the problem?

[@harrydmonel]

@@LearnBI thank you for replying my question. i have 50GB data dump (export with oracle). When i want to import the data using navicat, i did these steps: 1. Create new connection > Oracle 2 after connection created, i go to oracle connection and click data pump 3. I confused to do the next step, I have looked for the next steps to do on youtube, but there are no videos that can explain this

[@LearnBI]

@@harrydmonel have you tried contacting Navicat support?

[@sabuein]

Thank you.

[@LearnBI]

You’re welcome

[@abiola4710]

How do I stop a query from running in Navicat? In MySQL Workbench all I need to do is simply end the query with a semi-colon and enter the new query on the next line and run it. Doing same in Navicat gives an error. It also gives an error if I don't add a semi-colon. Pls help

[@LearnBI]

There are no semi-colons. Each query tab should contain a single query. If you do this and the query still fails, there’s a problem with the query itself.

[@abiola4710]

@@LearnBI That's exactly what I'm trying to avoid; writing a single query in a single tab.

[@Mah45565]

Which one is better Navicat or DBevear

[@LearnBI]

Considering the title of the video, I think you can probably guess my favorite 😉

[@Andre-dn7dk]

Yaaaas!

[@j.p8091]

Imagine a user that clicks on your video to learn SQL. All we want is an explanation of setting up the IDE in order to move on to learning SQL. An overview of Navicat and its plans is a waste of our time.

[@LearnBI]

I sincerely apologize, J. P. I will take down the video immediately and give myself 50 lashes!

[@j.p8091]

@@LearnBI Good, good, I expect nothing less. Acknowledgement is the first step on the long path to Tutorial video redemption. A+ for the self flagellation