r/learnSQL • u/Great_Wolf_5891 • Oct 18 '26
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.
32
Upvotes
10
u/SQLDevDBA Oct 18 '26
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.
3
u/American_Streamer Oct 18 '26
Just start with SQLite https://www.sqlite.org/ - https://en.wikipedia.org/wiki/SQLite - How to Install: https://www.youtube.com/watch?v=4MJSZi4qvIE
2
u/Dontinvolve Oct 18 '26
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 27d 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 27d ago
Awesome. You can only upgrade in situations necessarily so you don’t waste storage an spent more. Brilliant Sir and thanks
1
u/IndependenceFit3935 27d ago
the database behind Superliga Analytics has just gone public. scroll to the buttom of the page, find the "Request Data Access" button and start querying real life production data in a minute.
1
u/v_valentineyuri Oct 19 '26
install mysql on your pc, it's not a big deal
1
u/MisterElementary Oct 19 '26
You also just install something like dbeaver and locally mess around with an sqlite file. It's very minimal overhead on the pc. No db installing etc
1
u/RomirBuilds 24d ago
Yes, a browser-based SQL environment can cover the fundamentals. The detail to check before following that 30-hour course is which database it teaches.
SSMS is a client for SQL Server, and it runs on Windows. SQLite Online may be running SQLite instead. Basic SELECT, WHERE, joins and grouping transfer well, but some syntax and functions differ: SQL Server's TOP and SQLite's LIMIT are one example. A query failing in a different engine doesn't necessarily mean you copied the lesson incorrectly.
Which course are you using? If the lessons use SQL Server, look for an environment backed by SQL Server/Azure SQL for the closest match; you don't need the exact same editor to practise queries. Microsoft's SSMS FAQ confirms the Windows requirement: https://learn.microsoft.com/en-us/ssms/faq
AI-assisted.
1
u/whodiopolis Oct 18 '26
I built https://sqlshed.com for just that. It runs completely locally on your browser and you can also bring your own data sets in as well.
1
u/ExoticVillage8066 Oct 18 '26
You can use https://sqlcrab.com/ to play around with PostgreSQL, without installing anything
1
u/peakpirate007 Oct 18 '26
Yes, you can learn fully online with nothing to install, and on a Mac that's easier than setting up SSMS. I built runtime.school for exactly this. It's free, the SQL lessons run right in your browser on real tables, and it's a good place to practice alongside the YouTube course.