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

Подписаться 16 тыс.

Просмотров 20 тыс.

50% 1

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 -

Опубликовано:

23 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 54

@LuckyEDOHAMHEN 6 месяцев назад

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

@DataThinkers 5 месяцев назад

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

@mtad-healthfitness 6 дней назад

very helpful, thanks

@junaiddooast7435 2 месяца назад

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

@ifeomajames8702 4 месяца назад

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

@sharann9644 8 дней назад

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

@dpegn Год назад

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

@dianatwin1190 10 месяцев назад

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

@qureshiqureshi4489 3 месяца назад

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?

@umeshtiwari800 Год назад

Ur all videos are very good.

@fasiowaizahmed4641 Месяц назад

great video!! loved it

@vivekjoshi2790 8 месяцев назад

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

@diyadeb 2 месяца назад

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

@Lexi_The_Queen Год назад

Good work...

@xyzw1850 Год назад

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

@DataThinkers Год назад

Glad you like them!

@aditipandey1769 Год назад

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

@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 9 месяцев назад

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

@zahraphietrynabila9750 17 дней назад

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

@DataThinkers 16 дней назад

This video wil help :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@laxmanreddy2051 5 месяцев назад

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

@DataThinkers 5 месяцев назад

Yes, you can👍

@redahairy7176 8 месяцев назад

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

@DataThinkers 8 месяцев назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@harshsaurav3945 Год назад

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

@luthfiadnanrahmantyo7653 Год назад

me too

@DataThinkers Год назад

please watch this video : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@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 :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@sobatbale4569 Год назад

Love it, thankyouu

@laxmanreddy2051 5 месяцев назад

Can we use this as sql project in interview Please reply

@DataThinkers 5 месяцев назад

Yes you can👍

@virgilioespina7556 4 дня назад

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

@DataThinkers 3 дня назад

Check this :ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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

@farmerzindabad1234 8 месяцев назад

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

@DataThinkers 8 месяцев назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@ifeomajames8702 4 месяца назад

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

@DataThinkers 4 месяца назад

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

@ifeomajames8702 4 месяца назад

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

@DataThinkers 3 месяца назад

@ritikjawalkar2877 10 месяцев назад

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

@DataThinkers 9 месяцев назад

Check this one:ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@prernaprasad6709 6 месяцев назад

1 hr ho raha hai but data is not downloaded yet

@DataThinkers 6 месяцев назад

Upload this way : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html

@prernaprasad6709 5 месяцев назад

Helpful vedio

@gustavefrederik1300 5 дней назад

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

@DataThinkers 5 дней назад

Check this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Wt6DKHLR_ww.html