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

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 -

[junaiddooast]

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

[pkgolkl]

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

[godisgreat]

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

[xyzw]

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

[dianatwin]

Hey I appreciate this lecture
But my work did not show the question window

kindly elp
thank you

[ifeomajames]

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;

[vivekjoshi]

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

[qureshiqureshi]

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?

[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

[aditipandey]

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

[Jane-nimx]

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?

[redahairy]

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

[luthfiadnanrahmantyo]

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

[laxmanreddy]

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

[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.

[laxmanreddy]

Can we use this as sql project in interview Please reply

[harshsaurav]

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

[farmerzindabad]

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

[ifeomajames]

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