SQL for everyone in 45 minutes | Learn SQL for Data Analysis in one hour (sample dataset use case)

SQL for everyone in 45 minutes | Learn SQL for Data Analysis in one hour (sample dataset use case)
#SQLforeveryone #datascience #machinelearning
Hello ,
My name is Aman and I am a Data Scientist.

About this video:
SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks. You will learn:

◈ How to use SELECT statement to answer business questions
◈ Working with WHERE clause
◈ Combining data from two or more tables using JOINS
◈ Creating reports with GROUP BY
◈ Working with wildcards, IN operator

About Unfold Data science: This channel is to help people understand basics of data science through simple examples in easy way. Anybody without having prior knowledge of computer programming or statistics or machine learning and artificial intelligence can get an understanding of data science at high level through this channel. The videos uploaded will not be very technical in nature and hence it can be easily grasped by viewers from different background as well.

Book recommendation for Data Science:

Category 1 - Must Read For Every Data Scientist:

Ctaegory 2 - Overall Data Science:

Category 3 - Statistics and Mathematics:

Category 4 - Machine Learning:

Category 5 - Programming:

My Studio Setup:

Join Facebook group :

Follow on twitter : @unfoldds

Follow on Instagram : unfolddatascience

Watch python for data science playlist here:

Watch statistics and mathematics playlist here :

Watch End to End Implementation of a simple machine learning model in Python here:

Learn Ensemble Model, Bagging and Boosting here:

Build Career in Data Science Playlist:

Artificial Neural Network and Deep Learning Playlist:

Natural langugae Processing playlist:

Understanding and building recommendation system:

Access all my codes here:

[basantakatuwal]

You taught more than my coursebook of 1semester in 43 minutes of videos..kudos to you Aman sir

[dd]

You've been a great help Aman. The ease with which you explain everything is just awesome. Don't stop making these videos. There is a whole lot of people who probably haven't discovered you yet, but trust me once they will, they ain't going anywhere else.

[bandipeters]

This guy's teaching style is super awesome. Wow!

[manikantaperumalla]

best tutour in datascience i know is aman sir

[rajindakodikara]

very engaging content with a brutal example.... keep up the good work...

[mustaphaelouahabi]

Bravo! 👍
What a valuable DQL demo using MySQL: To-the-point, perfect pace, & intelligible flow! 👍

Requests:
(1) A tour of MySQL Workbench
(2) A Tutorial /Crash course about handling missing data (i.e. NULLs) using COALESCE (Ci, Cj, ..., Cm) function!
(3) What is the Usefulness of Subqueries, Views, & CTEs?
(4) How to Index Columns of interest?

Thank you in advance!

[nishantchaudhary]

Really great work, enjoying your videos.
You will be super hit soon.

[santhoshgattoji]

Hey Aman, perfect video with a practical example👍 . Very useful and helpful to have good grip on SQL queries, mainly joins. Much thanks for your work

[ankitayadav]

Thank you Aman, really your videos always help me

[nehapruthimds]

can you please make a video on bayesian logistic versus binary please

[harshitkumar]

Hi, Can you please share me the link of dataset which you have used. I searched on your given link but didn't find.

[mohammedshoebahmed]

sir, how to add that file to mysql workbench, everytime i try to open that file, it says large file and closes automatically

[himanshussn]

Hi Aman.. I was not able to find .sql file on the drive. Please can you tell the exact location of the file?

[bandipeters]

Please, I need the link to the .SQL file you used, thanks a lot.

[KSAmaze]

Hi, Can any one share the process how can I Import the Simple_Staff DB in SQL Management Studio

[bharathih]

If i watch this video will i be able to put SQL in my resume

[mithunmahato]

Boss unofficial name starts with C
So boss of the boss fired him/her 😂😂😂😂