Structured Query Language (SQL) is used for extracting and communicating with large databases. One should focus on understanding the different types of normalization, writing nested queries, using co-related questions, group-by, performing join operations, etc., on the data and extract in raw format. This data will then further be cleaned either in Microsoft Excel or by using Python libraries.<ul><li>Freecodecamp SQL (Recommended)</li><li>Intro To SQL By Kaggle (Recommended)</li><li>Advanced SQL By kaggle</li><li>Edureka’s SQL Playlist</li></ul>

Learn SQL

For becoming a Data Scientist, having knowledge of statistics and probability is as essential as having salt in food. Knowing them will help the data scientists interpret large data sets, get insights from them, and analyze them better.<ul><li>Krish Naik’s Statistics Playlist (Recommended)</li><li>Coursera Statistics Course</li><li>Khan Academy Statistics And Probability Course</li><li>FreeCodeCamp Statistics Course (Recommended)</li></ul>

Knowledge Of Statistics And Probability

When a Data Scientist is given a project, the majority of the time goes into cleaning the data set, removing unwanted values, handling missing values. It can be achieved by using some inbuilt python libraries like Pandas and Numpy.One should also know how to manipulate data using Microsoft Excel.<ul><li>Blog — Cleaning Data Using Python (Recommended)</li><li>Edureka’s Microsoft Excel Course</li><li>Learning Pandas By Kaggle (Recommended)</li></ul>

Data Cleaning

Becoming a Data Scientists is an exciting path, but you cannot learn data science within one year or six months—instead, it’s a lifetime process that you have to follow with proper dedication and hard work. 
To guide your journey, the skills outlined here are the first you must acquire to become a data scientist.

Becoming A Data Scientist

Python is the most preferred coding language and is adopted by most Data Scientists. It is easy to understand, versatile, and supports various in-built libraries such as Numpy, Pandas, MatplotLib, Seaborn, Scipy, and many more.<ul><li>FreeCodeCamp’s Python Tutorial (Recommended)</li><li>Kaggle’s Python Course</li><li>Krish Naik’s Python Tutorial (Recommended)</li><li>Udemy’s Python for Data Science and Machine Learning Bootcamp</li><li>Coursera Python Course</li></ul>While learning Python, one should know essential Python variables, data types, OOPs concepts, Numpy, Pandas, Matplotlib, and Seaborn.

Choose A Programming Language (Python / R)

Exploratory data analysis is the essential part when talking about data science. The data scientist has many tasks, including finding data patterns, analyzing data, finding the appropriate trends in the data and obtaining valuable insights, etc., from them with the help of various graphical and statistical methods, including:A) Data Analysis using Pandas and NumpyB) Data ManipulationC) Data Visualization<ul><li>Intro To EDA By Code Heroku’s (Recommended)</li><li>Blog — Performing EDA on Iris Data Set (Recommended)</li><li>Coursera Course On EDA, Statistics, Probability</li></ul>

Exploratory Data Analysis

According to Google, “Machine learning is a method of data analysis that automates analytical model building. It is a branch of artificial intelligence based on the idea that systems can learn from data, identify patterns and make decisions with minimal human intervention.”It is the most crucial step in a life cycle of a data scientist where one has to build various models using machine learning algorithms and should be able to predict and come with the most optimum solution to solve any problem.<ul><li>Machine Learning By Andrew NG (Recommended)</li><li>Deep Learning By Krish Naik</li></ul>

Learn Machine Learning Algorithms

After acquiring the basics of Data Science, now it’s time to get hands-on experience in its part. There are many online platforms, like Kaggle and Analytics Vidhya, that can provide you with hands-on experience with both beginner and advanced level data sets. They can help you to understand various machine learning algorithms, different analyzing techniques, etc.

Practice On Analytics Vidhya and Kaggle

Becoming a Data Scientists is an exciting path, but you cannot learn data science within one year or six months—instead, it’s a lifetime process that you have to follow with proper dedication and hard work. To guide your journey, the skills outlined here are the first you must acquire to…

Practice On Analytics Vidhya and Kaggle

Similar ideas to Practice On Analytics Vidhya and Kaggle

The main difference between R and Python

Big data Hadoop