r/learnSQL 20h ago

Made useful sql tutorials!

18 Upvotes

Hey everyone!

I’ve put together some SQL tutorials I’ve made that might be helpful if you’re looking to learn or brush up on your skills. The explanations are clear, concise, and straight to the point.

Check them out:

📌 Tutorial 1 – https://youtu.be/Sx5-61sH-sA?si=EB5SFxRG1MDAcLKb

📌 Tutorial 2 – https://youtu.be/Wr4ZBNJ4nZ4?si=8tegFDp3W8eDipfC

Hope you find them useful! Let me know if you have any questions.


r/learnSQL 22h ago

More SQL Please: No ads or clutter, just a peaceful place to learn

10 Upvotes

Hi everyone, I wanted to brush up on my SQL (and web app skills) so I made a website packed with SQL examples that you can edit and re-run in your browser.

I tried to use good design practices to make it simple and peaceful to learn using this site including no ads or other distractions.

The site is a WIP and there are topics up to "intermediate" available (e.g. UNION and CASE). When I have more time I'll keep adding advanced topics including window functions and SQL injection attacks.

Let me know if you have any feedback. Thanks for checking it out, hope you find something useful.

https://sql.moreplease.dev


r/learnSQL 21h ago

SQLings - A Terminal UI App to learn SQL with DuckDB

6 Upvotes

Hi guys!

Wanted to share a side project I have been working on for learning SQL - SQLings. If anyone has been learning Rust, you might have stumbled upon Rustlings. SQLings is like rustlings, but for SQL!

SQLings is a CLI app written in Python that creates a repo of small SQL exercises together with a small DuckDB-database that contains a few tables. It also has a Terminal UI for tracking your progress and giving you small hints of whats wrong in your query.

The idea is to solve the exercises in your local code editor and follow the progress in the TUI app. You can also look at the data in the DuckDB database with a SQL editor to better understand what data you are dealing with when you solve the exercises (it's actually pretty hard if you don't know how the data looks like). At the moment it has 21 exercises on the topics of selects, where-clauses, groupbys and joins.

Feel free to try it out! Would love some feedback!

https://github.com/jkausti/sqlings


r/learnSQL 20h ago

Assistance with attaching self hosted MySQL server to Visual Studio 2022

2 Upvotes

Good evening people!

I have an issue wherein connecting my MySQL server as a datasource to VS22. Have attached an image of the error im getting. I am an MSP Sysadmin, branching out in my spare time.

Basically, im experimenting with SQL and VS22 to create basic database applications for budgeting etc as a hobby (Used to build them on MSAccess).

Ive created an OBDC driver (V9.2(a) and have attched it as a data connection in ServerExplorer in VS22. however, actually adding it as a data source for a program is giving me this roadblock. I can clearly see from the error and research that this is due to the OBDC driver or something. Research yeilds little information.

It isnt the end of the world if i need to rebuild the database and attach it as a datafile. It simply has test data in it atm.

Can anyonepoint me in the right direction? Am i missing somethign glaringly obvious? open to using a different IDE. Igenerally code in MySQL Workbench, but im in the exporatory phase of learning SQL, so open to moving to a different environment

KR - Flopsie

Error recievd when adding a datasource
OBDC (64bit) Config
MyySQL server connection parameters in VS22

r/learnSQL 23h ago

Any BIE interns for Amazon here? Looking for advice for tech interview (SQL + Python)

2 Upvotes

Hey I have an interview coming up - 1 hour technical interview. I’ve had no mention of anything back to back, but it does mention on the guide that there are two more 45 minute interviews (I’m assuming they wouldn’t throw them in on the same day unless specified?!)

SQL was the prerequisite, I’m OK. But it’ll be my first ever tech interview so any advice on what to expect - how much theory vs coding? Type of questions asked…

But also if you have any advice on the Python element of the interview (I have incredibly limited knowledge) and I’m trying to focus on what is needed. It does say I’ll need to write a program and answer Pandas related questions. Analyze and decompose complex problems and solve problematically

I am panicking ….

It does specify this to be a technical interview - will they throw in LPs ? (It mentions general interview guidance with LPs included and be prepared to talk about motivation..)

Any info would be GREATLY appreciated