Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

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,854 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?

3 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/

I can't remember how to write code. You should freestyle.