You can use my SQL spreadsheet app: https://superintendent.app I had a similar problem at work where I needed to do some formula on a 5 GB CSV file. Excel can't handle more than 1M rows. Database is too clunky. Eventually I built a GUI wrapper on SQLite, and it grew into Superintendent.app. - Source: Hacker News / 6 days ago

Desktop first made me think of Superintendant[0] which I’ve enjoyed using 0: https://superintendent.app/. - Source: Hacker News / 10 months ago

Project 3: Electron with typescripts. 15 paying users. Source: 11 months ago

That is exactly https://superintendent.app (disclaimer: I'm the creator). - Source: Hacker News / about 1 year ago

Well, shameless plug. https://superintendent.app (paid with free trial) enables you to load a bunch of CSVs and write SQL on those CSV files. It's a much faster to work with if you know SQL well. It can also handle millions of rows easily (e.g. Loading 1GB CSV file takes 10s on Macbook Pro). I initially built it because I had to identify the mismatched transactions between 2 giant CSVs using "full outer join". - Source: Hacker News / over 1 year ago

Tutorials: Many websites offer free SQL tutorials and exercises, such as SQLZoo and Mode Analytics. Source: about 1 year ago

Follow this tutorial. Sign up for a free account and follow along in the Mode report editor. Solve all the practice problems along the way. Source: over 1 year ago

If you are looking to practice your SQL skills, I like Mode to give you a good understanding of the basics as well as the advanced concepts. In this situation, I would simply learn to the test. Source: over 1 year ago

If youre learning SQL for the first time -> mode analytics is my favorite Especially for data analytics, great place to start and I recommend doing beginner and moderate levels. Source: over 1 year ago

I recommend this tutorial to all SQL beginners. My partner, who also had no background in programming, found this very helpful. Source: over 1 year ago