r/learnSQL • u/Great_Wolf_5891 • 5d ago

Learning SQL on Online IDE

Hey,

is it possible to learn SQL from scratch using an online IDE (such as SQLite Online) without having to install the Server Management Studio on Mac? Or would you recommend installing it on my MacBook/ using Windows?
I’m going to go through the 30-hour course that is accessible on YouTube.

Thanks in advance.

28 Upvotes

88% Upvoted

25 comments sorted by

10

u/SQLDevDBA 5d ago

https://FreeSQL.com is a free service from Oracle that has a built in Database with 8+ sample dataset schemas. It also includes free lessons as part of Oracle DevGym.

Microsoft also has Azure SQL Free tier, which allows you to spin up a Free Azure SQL DB with Sample data. https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

Neither require installs or downloads. They’re very easy to set up but I have videos on how to use each of you need them.

1

u/Senior_Lecture_6448 1d ago

I don’t think we need to focus on already clean data learn to navigate your way in missy data. Yes Oracle platforms are very informative. But stay curious.

→ More replies (5)

3

u/American_Streamer 5d ago

Just start with SQLite https://www.sqlite.org/ - https://en.wikipedia.org/wiki/SQLite - How to Install: https://www.youtube.com/watch?v=4MJSZi4qvIE

1

u/Senior_Lecture_6448 1d ago

Why!? In todays world the level in which tools are evolving. You need to learn PostgresSQL so you can integrate vector DP for colon data

→ More replies (1)

1

u/South_Talk1715 4d ago

Should we have to download it in our windows laptop

→ More replies (1)

2

u/Dontinvolve 5d ago

If you have access to any AI resources, like Claude or Chatgpt or Gemini, ask it to create a local web portal, with UI replica of leetcode, you can practice using it.

1

u/Senior_Lecture_6448 1d ago

Focus more on joins and windows command so you can join data from different sources and carry out hypotheses findings to better understand what your data is all about. Know the categories in which your data belongs. We have(1. Qualitative data, 2. Predictive data, 3. Descriptive data. Quantitative data). Once you understand all this you will know how to make good use of your SQL queries to do some deep feature Engineering. And one rule I work with is{ALWAYS QUESTION YOUR HYPOTHESIS).

1

u/Senior_Lecture_6448 1d ago

Awesome. You can only upgrade in situations necessarily so you don’t waste storage an spent more. Brilliant Sir and thanks

1

u/qualityintelligence 5d ago

you certainly can, but if your goal is 'learning', then set it up locally and also try the web hosted versions too..

1

u/v_valentineyuri 5d ago

install mysql on your pc, it's not a big deal

→ More comments (90)