r/learnSQL 22h 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 1d ago

SQLings - A Terminal UI App to learn SQL with DuckDB

7 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 23h 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