How to Download SQLite & A Sample Database: SQL for Beginners (Lesson 1)

Tutorial on how to download SQLite, SQLite Studio, and a Sample Database, Chinook. This is necessary for the future SQL lessons in this series. In order to follow along in subsequent videos please download the following:
SQLite: www.sqlite.org/download.html
SQLite Studio: sqlitestudio.pl/
Sample Database: database.guide/2-sample-datab...

[@warrenricketts4086]

Amazing, thank you. Only one that worked for me too...

[@learningwithjelly]

Thanks Warren for the comment

[@andressatricolor]

Your video should have SO MANY more views! Thanks so much for the excellent explanation!!!!

[@learningwithjelly]

You are sooooo welcome!!!!

[@samoliver5177]

Thanks! Followed on Windows machine, and the tutorial was straightforward. Always helps having a video tutorial for these kinds of installations.

[@littleguy434]

I must have watched / read 5 different tutorials on this and yours is the only one that has made it work (even though I've got a newer version of SQLite Studio!). Thanks so much!!

[@learningwithjelly]

Thanks for this comment Jeremy glad it worked for you!

[@sirenasings6]

As my son would say, "I did it!" It took a lot of trial and error (my error, you did great) but I made it through. Thank you so much for making this video. I have been stalling my own success because I couldn't find a comprehensive tutorial on how to do this on my MacBook. Thank you thank you thank you. I feel so much more excited now

[@learningwithjelly]

You are soooo welcome!!!! So proud

[@Oranges364]

Thank you for this comprehensive video!

[@user-wz8ju1uo5y]

Thanks Jelly! This was really helpful

[@padmaramamurthy8834]

Thank you Jelly!! It was really helpful.

[@learningwithjelly]

You are welcome

[@adilysramirez5311]

THANK YOUUUU!!! I FINALLY GOT IT! THANK YOU, JESUS AND @LEARNINGWITHJELLY :D

[@learningwithjelly]

You are soooo welcome!

[@kellykeegan3926]

Thank you!

[@learningwithjelly]

Thanks for watching:)

[@aaaversion23]

Hi Jelly, thanks for the video! Following along made sense but when I got to the "Add a database" section, for some reason I'm not able to select the .db file. When I manually input the file path, and hover over the small red exclamation circle in the File slot, I get the message: "This database is already on the list..." but I don't see the database anywhere in SQLiteStudio. Any recommendations?

[@learningwithjelly]

Hmmm hard to tell without a screenshot when you open up sqlite studio do you see the database on the left hand side? Try googling the error or uploading a screenshot.

[@aaaversion23]

@@learningwithjelly I seem to have fixed the problem but admittedly I'm not sure what I did (so a screenshot wouldn't help now). Basically, the first time I tried, "Chinook" wasn't automatically appearing in the upper-left dropdown menu. And then when I tried to select the file path, I wasn't allowed to select any files (even .db files). I adjusted some settings, however, and the "Chinook" started appearing in the box, but I never actually selected a file path. At one point I gave SQLite permission to access the entire folder containing the .db file, so maybe doing that led to the program automatically incorporating the .db file?

[@user-zp5hr5fs2x]

Hi Jelly, thanks for the video. I have an error in SQLite studio when i want to add a database , i chose an address and write a name to create a new database but i got an error "Could not add database /Users/arya/Documents/sqlite-tools: Could not open database: unable to open database file" . Any recommendations?

[@learningwithjelly]

Is the file actually saved as a .db and located inside that directory aka is it in the sqlite-tools folder?? If not move the database there. If that doesn't work try searching on stackoverflow

[@user-zp5hr5fs2x]

@@learningwithjelly thanks but it doesn't create .db file now i create a .db file with DB Browser for SQLite and then open with SQLite studio . it was the only way i found to work with SQLite studio

[@AdumbWillSun]

I'm having issues linking the terminal to my Documents folder for some reason. I've noticed that your terminal had (base) listed in front of the name of your computer and mine does not. I'm not sure where to go from here. I followed your directions and am pretty confident I didn't stray from them. If you could offer any guidance that would be much appreciated!

[@learningwithjelly]

What path does your terminal say you are in? Maybe best to send me an email with a screenshot of the issue.

[@AdumbWillSun]

@@learningwithjelly Appreciate the prompt reply!! What's your email and I'll email you the screenshot of my terminal. Thanks again!

[@alexsforbes3861]

For some reason when I downloaded SQLite studio and clicked on add data base I get the pop up window like you but in my window I don’t have that green icon next to the folder. Is there a solution to this issue?

[@learningwithjelly]

Try going to the "View" tab and click on Databases ----to make sure your databases are turned on. If that doesn't work try to look at this solution link or do a Google search for your specific issue: stackoverflow.com/questions/57720228/sqlite-studio-cannot-load-database-red-exclamation-marks

[@alexsforbes3861]

Thank you I fixed it. Another question I’m trying to query data that’s in excel format, would I be able to use it in SQLite if I convert to a csv file.

[@learningwithjelly]

@@alexsforbes3861 no it has to be saved as a .db file

[@HoustonisFire]

Hello. Any idea why my Chinook database is saving as txt instead of sql?

[@learningwithjelly]

Unfortunately no. I can't see your screen. Did you save it as a .txt vs a database?

[@HoustonisFire]

@@learningwithjelly thanks for replying. All I did was copy and right click to download and save it. And it just keeps saving as txt