SQL

- [Voiceover] You don't have to be…working in data science very long…before you discover the importance of SQL, or "sequel."…Now let's go back to our Kdnugget Software Poll…and look at SQL's Place.…In the survey of data mining professionals,…SQL is third in terms of the programs with the languages…that they use most often in doing their work.…It's also the first database tool on the list.…Now the first thing to remember…is that SQL is a language, it's not an application itself.…

It's a way of working on an application.…SQL works with many relational databases.…It's the most common approach.…It's great for working with structured data.…So you've got rows and columns…and you've got tables to work with.…And usually what happens is you use SQL…long enough to get the data out of the database,…get it organized, and then send it to another…program like R or Python for analysis.…SQL is the language of RDBMS or…relational database management systems.…

These are the actual structures…of the databases that are for storing the data.…