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 trialStheven Cabral
Full Stack JavaScript Techdegree Graduate 29,854 PointsWhat 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
adrian miranda
13,561 PointsAs 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
78,020 Pointsyou can write it with any editor, but those are especially for SQL:
https://www.comparitech.com/net-admin/best-sql-software-tools/
Codi Hasbrouck
41 PointsI can't remember how to write code. You should freestyle.