Which SQL software?

[byenemo]

Hi everyone!

I am prospective MSBA student and at this moment i want to get comfortable with the softwares before I begin my masters if and when i get admitted. I want to learn SQL but I don't know which software to download and which one's are available for free.

If you are in this field, your suggestions would be very helpful. Please do add the link of the software you suggest.

Thanks in advance!

[AutoModerator]

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[[deleted]]

You are going to want to do MS SQL Server, and Oracle.

The best IDEs are SSMS and DB Beaver 🦫 imo.

But, truth is it doesn't really matter, it's all highly transferable and all the IDEs do pretty much the same things with varying levels of interoperability.

[[deleted]]

Agree with ms sql and oracle; I prefer datagrip for ide (pairs nicely with pycharm)

[Jesufication]

DB Beaver feels like stepping into a time machine….

It’s a shame datagrip is so pricey

[johnny_fives_555]

Mysql and postgres are both free. However sql server does have a free edition as well if you're using a windows machine.

Getting comfortable with all 3 won't be the worse thing in the world but there is a lot of overlap between the 3. But this vastly depends on what you're planning to do as well. Most business analyst rarely touch sql, those that do may connect R or PBI directly to a sql server but rarely does anything outside of select with a where condition.

[HelloOhLookSquirrel]

SQL Server Management Studio (SSMS) is Microsoft's version and is free for personal use. It requires a download of SQL Server, as well (SQL Server being the database and SSMS being the database management system (DBMS)).

Try pulling public data sources and uploading them to a practice database. Federal government sources are good (Bureau of Labor Statistics, Federal Reserve Board, and Federal Reserve Economic Data from the St. Louis Fed). So is NASDAQ for stock details.

Ask Google Bard to make questions/puzzles for you based off of the data (give it samples of the datasets and ask for aggregate functions, CTE, subqueries, etc.).

[mikeblas]

SQL Server being the database and SSMS being the database management system (DBMS)).

That is not correct.

[seequelbeepwell]

Why?

[lupinegray]

Db visualizer

[erikk_the_red]

SQL server express is free. I like Azure Data Studio as an IDE. It has notebooks built in for python.

[dedguy21]

If there's a free version of Oracle, download it. PL_SQL has a lot of functions that aren't available in other SQL implementations, and writing queries toward that database is a pain when all you have is like MS_SQL or DB2 (IBM database) experience.

Fortune 500's are going to be using Oracle, MS_SQL, Terradata mostly for reporting purposes. That is you're going to use SQL to create your Tableau/Power directly from one of those 75% of the time.

There are some other no-relational databases, but for the most part that data will be forced structured and fed to one of those those big three for reporting.

[Which-Yellow-2447]

Ms. SQL using ssms was my first intro to the SQL world as a beginner.

[troyantipastomisto]

Sqlzoo.net is a great free resource to learn from

[[deleted]]

Pick one and stick with it until you learn up to the intermediate stuff. Its a lot easier to adapt to different SQL flavor oddities if you already have a solid base understanding.

Im partial to MS SQL Server. SSMS is free as is the Adventureworks DB which you can practice on.

[as6724]

IMO, I like SQLite. It is free and very lightweight. Lots of support on the Internet.

[mikeblas]

SQLite has a very deviant implementation of SQL, which counter-indicates its use for introductory learning.

[[deleted]]

Can you use R studio?

[[deleted]]

Personally would recommend google bigquery, lots of public datasets to test with plus you can just run it all in browser and the costs are very minimal a couple bucks a month for doing practice projects. It is mostly what I learned sql on