The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

How a dataset is filled in SQL?

How a dataset is filled in SQL?

0
Votes
1
Answer

I was wondering how a dataset is filled beforehand manipulating it with SQL. Although SQL has commands to create a database, I believe the optimal way to fill in that database is not manually through coding in SQL, right?
so, which is the common way in which a database is filled with records? and who is in charge of it? 
In order to get a clear idea, SQL is meant to organize and retrieve data from a full dataset loaded beforehand?
 
Thank you

1 Answer

365 Team
0
Votes

Hi Marta!
Thanks for reaching out.
In order to get a clear idea, SQL is meant to organize and retrieve data from a full dataset loaded beforehand?
Yes, as well as set up a database/dataset to work with. 
 which is the common way in which a database is filled with records? 
There are various ways to import data into MySQL. One can import a dump file, or a *.dat file, or import code containing the relevant queries that will fill the database with relevant data. 
and who is in charge of it?
Normally the database administrators, but also other operators such as database the creators. 
Hope this helps.
Best,
Martin

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF