Easy Way to Practice Your SQL Skills
SQL is a very valuable skill for all software developers. Here is a good way to brush up on it.
A client recently asked me some questions about databases. SQL is something I've used on several projects and it's not something I use every day. When I'm using it on a project I tend to do a deep dive and by the end of the project, I am pretty confident in SQL ability. Then I go several months without using it and some of the details get fuzzy.
I've been a big proponent of code katas in general - just periodically practicing some of those important skills that maybe we don't get to exercise every day. I was really excited when I found this kata on using SQLite. The exercises are simple and following the instructions, it is quick and easy to set up.
https://programmingheadache.com/2024/08/18/test-your-sql-skills-sql-katas-to-keep-you-in-shape/
I am going through the exercise just to practice my SQL query-writing abilities so I am just using DB Browser for SQLite. It's simple, free (although you should throw them a few dollars if you find it useful), and easy to use. You could also use Python or Dr Powell's SQLite toolkit for LabVIEW if you wanted practice integrating SQL with your favorite programming language.
I also like the fact that it emphasizes testing. There is a simple test script included. It's written in Bash, but you could also write a unit test in Python or LabVIEW. In fact, I may put together a simple version of this kata using SQLite in LabVIEW and publish it.
Want some guided practice?
If want some guided practice learning new techniques or refining existing ones, we are now offering Samman Coaching. If that sounds interesting let's talk. Reach out using the button below.
