1. Data Analytics Using MySQL | MySQL (Case Study - 1) | Kaggle Dataset (SF Salary)

Dataset on Kaggle: www.kaggle.com...
MySQL Code File Used in this Video: github.com/PRI...
GitHub Link: github.com/PRI...
If you enjoy these tutorials, like the video, give it a thumbs-up, and share these videos with your friends and families if you think they would help him.
Please consider clicking the SUBSCRIBE button to be notified of future videos.
Disclaimer ---
Video is for educational purposes only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is permitted by copyright statute that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use.
Thanks for watching -

[@LuckyEDOHAMHEN]

This has to be the most satisfactory and simplest sql video on the internet
God bless you.

[@DataThinkers]

Wow, thank you!

[@godisgreat3892]

I really appreciate the way of teaching, its really understandable, please keep uploading more SQL videos like this. Thank you, sir.

[@DataThinkers]

Thanks, sure

[@junaiddooast7435]

i am lucky enough to get your channel . have done projects of data analysis using python from ur channel and now working on sql

[@mtad-healthfitness]

very helpful, thanks

[@fasiowaizahmed4641]

great video!! loved it

[@umeshtiwari800]

Ur all videos are very good.

[@sharann9644]

How have salaries changed over time between different groups of people?
How are base pay, overtime pay, and benefits allocated between different groups?
Is there any evidence of pay discrimination based on gender in this dataset?
How is budget allocated based on different groups and responsibilities?
Will you try to explain these questions with the sql queries

[@xyzw1850]

Let me comment , that your videos are damm good, thanks!

[@DataThinkers]

Glad you like them!

[@Lexi_The_Queen]

Good work...

[@sobatbale4569]

Love it, thankyouu

[@ifeomajames8702]

What is the data type for your base pay column. When I imported the data, it told me error code 1265 , data truncated for column base pay at row 5

[@dpegn]

is this wrong approach for question 8?
select employeeName,
avg(Basepay),
avg(OvertimePay),
avg(otherpay) from salaries
group by employeeName;

[@dianatwin1190]

Hey I appreciate this lecture
But my work did not show the question window
kindly elp
thank you

[@laxmanreddy2051]

Please reply can we use it as sql project in interview ...your reply will save so many students life

[@DataThinkers]

Yes, you can👍

[@Vishal-xv4mt]

My sql takes a lot time in importing and sql server can do it in seconds

[@qureshiqureshi4489]

why we use MySQL in data analytics?
do we work same tasks on Excel or in Mysql, are both use for same purpose in DA?

[@vivekjoshi2790]

unable to download the dataset. says 'we can’t show files that are this big right now.'

[@zahraphietrynabila9750]

mine, the data doesn't fully import to mysql, only approximately 4000 row in mysql. How to handle this problem?

[@DataThinkers]

This video wil help :ruclips.net/video/Wt6DKHLR_ww/видео.html

[@diyadeb]

Sir mene file import kiya hai buy isme id serial me nhi aa raha hai like 1,2,313,5 aase korke aa raha hai kya karo

[@aditipandey1769]

Update .... set ..... is not giving the desired results. Infact there is no update in the table. What to do sir?

[@virgilioespina7556]

how to load data to mysql using sql alchemy in python?

[@DataThinkers]

Check this :ruclips.net/video/Wt6DKHLR_ww/видео.html

[@laxmanreddy2051]

Can we use this as sql project in interview Please reply

[@DataThinkers]

Yes you can👍

[@redahairy7176]

the data that you use didn't work with me 'unhandled exception list index out of range mysql'

[@DataThinkers]

ruclips.net/video/Wt6DKHLR_ww/видео.html

[@harshsaurav3945]

Sir, it takes too much time to import the data.
Any solution?

[@luthfiadnanrahmantyo7653]

me too

[@DataThinkers]

please watch this video : ruclips.net/video/Wt6DKHLR_ww/видео.html

[@Jane-ni9mx]

There is one column "Benefits", which seems to have null values, but when I select any records with Benefits = 0, those all poped up, I suspect that would affects the accuracy of some analysis, like the average Benefits, could you please give some example to explain that?

[@addicted4253]

0 is not a null value..You have to give Where condition with benifits is Null

[@griloka]

hello. why mine so long to import data? i work on intel core i7. probably it need around 10 minutes, but i can't wait more, so i cancel it.

[@DataThinkers]

please watch this video :ruclips.net/video/Wt6DKHLR_ww/видео.html

[@luthfiadnanrahmantyo7653]

sir, I get a massage row import failed with an error, how I can handle it?

[@DataThinkers]

Send me your code with error

[@ifeomajames8702]

Unable to download this dataset, it’s in a html format

[@DataThinkers]

Take dataset from here inside DS FOLDER:github.com/DataThinkers/Datasets

[@ifeomajames8702]

@@DataThinkersthank you, do I need to clean the data in excel or change the format before importing In MySQL

[@DataThinkers]

No

[@farmerzindabad1234]

ur file is having error bro i import other file easily ... am unable to practice ur file

[@DataThinkers]

ruclips.net/video/Wt6DKHLR_ww/видео.html

[@prernaprasad6709]

1 hr ho raha hai but data is not downloaded yet

[@DataThinkers]

Upload this way : ruclips.net/video/Wt6DKHLR_ww/видео.html

[@prernaprasad6709]

Helpful vedio

[@ritikjawalkar2877]

data importing takes lots of time is there alternate way to import data faster

[@DataThinkers]

Check this one:ruclips.net/video/Wt6DKHLR_ww/видео.html

[@gustavefrederik1300]

WARNING!
It can take years to load the database to mySQL in this way. You should try other ways to load.

[@DataThinkers]

Check this: ruclips.net/video/Wt6DKHLR_ww/видео.html