SQL for everyone in 45 minutes | Learn SQL for Data Analysis in one hour (sample dataset use case)
Vložit
- čas přidán 6. 09. 2024
- 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.
All amazing data science courses at most affordable price here: www.unfolddata...
How to install Mysql : • MySQL Installation gui...
Find the SQL file to create databse I used here: drive.google.c...
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:
The Elements of Statistical Learning by Trevor Hastie - amzn.to/37wMo9H
Python Data Science Handbook - amzn.to/31UCScm
Business Statistics By Ken Black - amzn.to/2LObAA5
Hands-On Machine Learning with Scikit Learn, Keras, and TensorFlow by Aurelien Geron - amzn.to/3gV8sO9
Ctaegory 2 - Overall Data Science:
The Art of Data Science By Roger D. Peng - amzn.to/2KD75aD
Predictive Analytics By By Eric Siegel - amzn.to/3nsQftV
Data Science for Business By Foster Provost - amzn.to/3ajN8QZ
Category 3 - Statistics and Mathematics:
Naked Statistics By Charles Wheelan - amzn.to/3gXLdmp
Practical Statistics for Data Scientist By Peter Bruce - amzn.to/37wL9Y5
Category 4 - Machine Learning:
Introduction to machine learning by Andreas C Muller - amzn.to/3oZ3X7T
The Hundred Page Machine Learning Book by Andriy Burkov - amzn.to/3pdqCxJ
Category 5 - Programming:
The Pragmatic Programmer by David Thomas - amzn.to/2WqWXVj
Clean Code by Robert C. Martin - amzn.to/3oYOdlt
My Studio Setup:
My Camera : amzn.to/3mwXI9I
My Mic : amzn.to/34phfD0
My Tripod : amzn.to/3r4HeJA
My Ring Light : amzn.to/3gZz00F
Join Facebook group :
www.facebook.c...
Follow on medium : / amanrai77
Follow on quora: www.quora.com/...
Follow on twitter : @unfoldds
Get connected on LinkedIn : / aman-kumar-b4881440
Follow on Instagram : unfolddatascience
Watch Introduction to Data Science full playlist here : • Data Science In 15 Min...
Watch python for data science playlist here:
• Python Basics For Data...
Watch statistics and mathematics playlist here :
• Measures of Central Te...
Watch End to End Implementation of a simple machine learning model in Python here:
• How Does Machine Learn...
Learn Ensemble Model, Bagging and Boosting here:
• Introduction to Ensemb...
Build Career in Data Science Playlist:
• Channel updates - Unfo...
Artificial Neural Network and Deep Learning Playlist:
• Intuition behind neura...
Natural langugae Processing playlist:
• Natural Language Proce...
Understanding and building recommendation system:
• Recommendation System ...
Access all my codes here:
drive.google.c...
Have a different question for me? Ask me here : docs.google.co...
My Music: www.bensound.c...
You taught more than my coursebook of 1semester in 43 minutes of videos..kudos to you Aman sir
Thanks Basanta. Your comments motivate me.
This guy's teaching style is super awesome. Wow!
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.
Thanks Deb. Pls share with friends.
very engaging content with a brutal example.... keep up the good work...
Really great work, enjoying your videos.
You will be super hit soon.
wonderful work, thanks Aman.
best tutour in datascience i know is aman sir
Thanks Mani. Your words mean a lot.
great learning on this channel...
Thanks Sharad
wow !!!! superb ....just simple !!!
Thanks Chandra.
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
Welcome Santhosh. Hope u r doing great.
Thank you Aman, really your videos always help me
Welcome Ankita.
Thank you Aman 😊
Great content. Thanks a lot.
Most welcome
can you please make a video on bayesian logistic versus binary please
Good video.. Keep going Aman 😊
Thanks Pavan.
Thanks a lot ❤️❤️
Most welcome. Please share with friends.
super explanation
Thank you so much 🙂
Hi, Can you please share me the link of dataset which you have used. I searched on your given link but didn't find.
you can check now. same link
Please, I need help with that too, thanks.
If i watch this video will i be able to put SQL in my resume
Thank you Bhai
Thanks Omkar.
Hi Aman.. I was not able to find .sql file on the drive. Please can you tell the exact location of the file?
drive.google.com/file/d/1A7aSHL9hiFqBZ1wQ-fX6J6zce5SPUsZy/view?usp=share_link
@@UnfoldDataScience Thanks for the link Aman. You have been a guiding light throughout my data science journey and i look up to become like you one day. You are a great inspiration and a good friend. I am from a medical background but still i am able to grasp your content with ease. Thanks a lot.
Nice one
sir, how to add that file to mysql workbench, everytime i try to open that file, it says large file and closes automatically
upload in workbench,, dont try to open in notepad etc, wait for sometime after import. Its large
Hi, Can any one share the process how can I Import the Simple_Staff DB in SQL Management Studio
👏👏👏
Thanks Rasha
Please, I need the link to the .SQL file you used, thanks a lot.
This was very big in size so I removed it from google drive. If you search in google with same name you may find it
Thanks a million@@UnfoldDataScience
U will take online class
www.unfolddatascience.com/
Boss unofficial name starts with C
So boss of the boss fired him/her 😂😂😂😂