Complete Beginner Guide of SQL for Data Science

Photo by Nick Kane on Unsplash

I came across SQL databases by chance in 2012 and had no idea how to use them in collage. However, I installed MQSqL on my school computer and tried to see what happened.

Surprisely, I dropped idea to learn SQL and move on . After 8 years, things changed and we realized that SQL is the backbone of data analysis. Therefore, I had to do a deep dive and learn SQL.

Let me share a few insights about SQL databases with data science learners.

Introduction to SQL

SQL, or Structured Query Language, is a programming language used to communicate with databases. It is a standard language used to manipulate and manage data stored in relational databases, such as MySQL, Oracle, and Microsoft SQL Server.

SQL is used to perform a variety of tasks, including:

• Creating and modifying databases and tables
• Inserting, updating, and deleting data
• Retrieving data from databases
• Setting permissions and user access
• Creating views and stored procedures

Basic SQL commands

Here are some of the basic commands you will use in SQL:

• SELECT: used to retrieve data from a…