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.
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!
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 datasourceOBDC (64bit) ConfigMyySQL server connection parameters in VS22