SQL on computer


So several SQL resources on this website suggest you try them on a PC, yet there is no clear article detailing how to accomplish this. So I’ve installed Gitbash, all grand. I’ve installed SQLite on there as well, also grand.

Yet there’s no advice as to how to open things in this program. A vague YT video from this website indeed illustrates how to open a database, grand, yet this is assuming you know the names and the tables you can draw from. What if you’ve opened a database and don’t know where to draw from: you’re just there with sitting ducks with your terminal open.

Say, the World Populations exercise on this website. How would one go about and do this in a Github terminal with SQLite installed?


PS: no clue what’s meant with these tags on this forum, so I just picked something.