How can I implement SQL with data? Do I use Excel, or some other spreadsheet program? Or can I use HTML/JS data?

Question

I am still very new to data science, I have been learning for a month and now I want to implement my knowledge. Still confused on how to do so since I'm brand new at this. Any help would be appreciated! Thank you all in advance!

Answer 1

Yeah, looks like I still have a lot more to learn! Thanks for the help!

Answer 2

There's a lot of options.

You can have all your data on a txt or csv file.
Build an SQL scrip for creating tables, after that create a simple application that accesses those tables, and allows the user to make simple operations like insert data, remove, search and so on.

Answer 3

Try for example to create an app based on solo learn and how you think the logical model of the database they're using was implemented.

Answer 4

So the tables can be on a txt or csv file? Would I have to create a program for me to use SQL??? I'm still trying to understand databases in and of themselves.

Answer 5

Yes, you would need to write a program using another language, not that it is the only way, if all you want to do is use SQL you can just create a script to create the tables,
another script to insert values in the tables, and then just query the DB, but that wouldn't be much interesting.
To understand databases and how they are structured you have articles and books online you can consult.