Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

Stheven Cabral
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Stheven Cabral
Full Stack JavaScript Techdegree Graduate 29,841 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

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).

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

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