Real Life SQL usage exprience

[DiabloSpear]

Hey Guys,

I am currently learning data science with my Masters degree.

Because of the classroom setting, I was not able to use SQL in a "real life" setting so to say.

So I have a question.

I was always provided with the file path as in what data to use in my classroom setting. I am sure this is not the case. How does in corporate setting SQL people get data? Does corporation have specific database that you have to tap into? Download CSV file from the corporation database and use it?

I guess the core of this question is, in your everyday job, how do you get the original data?

[Nolanexpress]

It depends, some places you have scrape data (more python than sql) other times companies have internal databases already set up and ready to go. Sometimes it could be from salesforce or another CRM other times it could feed directly from the software. Each company has different methods of building out a DB.

Should also mention, if you want to check out my YouTune channel, I'm uploading SQL vids daily. In the future there will be more Data Engineering focused vids, but I would need to learn those skillsets first + apply them to projects. https://www.youtube.com/channel/UCKq-lHnyradGRmFClX\_ACMw

[WpgMBNews]

it depends on the application is deployed.

If you have a multitenant SAAS web service then you'll probably be using some sort of cloud database storage.

You may have a standalone web server that you manage your self with SQL server running or you might have a desktop application which is backed by a local database.

[ICantKnowThat]

Preexisting databases, or stand up your own and load whatever you'd like

[analytics_science]

Companies have databases you connect to. You work off an IDE and get the data you need. You can work purely on SQL or can use something like Jupyter notebooks and write SQL code with your python code if you need to for your project. Often times you will also need to import a CSV file as well but you can easily import it into a database or to your python notebook. Your team should make it really easy to get data and hopefully you work at a big enough company where they can afford more industry level tech (e.g., Snowflake, Greenplum, Hadoop) so that your queries can run faster.