Databases SQL Basics Getting Data from a Database Tools We'll be Using

Stheven Cabral
Stheven Cabral
5,302 Points

What program do analysts use to write SQL?

Apologize for the beginner question. What program do analysts use to write SQL? For example, programmers use sublime or atom to write python code? Is it similar for SQL? Does one need a text editor in order to write SQL? If yes, what text editors are the most common? If no, where do you actually write SQL?

2 Answers

adrian miranda
adrian miranda
12,196 Points

As Jan already said, you can use many different editors to create SQL. There isn't any one editor that most people use.

Perhaps the most obvious place to start looking is with your Database vendor. Many of them provide free editors that are fairly decent, eg Oracle provides sqldeveloper, and Mysql provides "mysql workbench". These tools are very common. They don't just allow you to easily format your code, but they can also connect to the database and run your code. They can usually show you the output in neatly formatted tables, and can also give you information about how well your SQL ran.

Another thought is to use your favorite editor, if it has support for SQL (many do, though not all).

Jan Oberreiter
Jan Oberreiter
69,420 Points

you can write it with any editor, but those are especially for SQL:

https://www.comparitech.com/net-admin/best-sql-software-tools/