You are the best person I found on youtube to explain SQL queries so simply, clearly and correctly..please do keep making such videos and helping people like me..Thanks so much..
I always consider you as my primary SQL mentor. 🙏😊 Could you please provide us the answer key for the questions mentioned in the video? I would like to solve those questions
This guy is amazing!!! The stuff I have learnt from you is infinite, God bless!!! And please, make more video!!! Make it longer, tackle all the questions, we are hear to learn!!! SIMPLY AMAZING!!! THANKS
i never leave comments on youtube but have to say that your videos are by far the best ive found ( after extensive searching )in regards to learning data analysis thank you very much!
hi thoufiq, great video. I just wanted to point out that in the third query the desired output should be country:USA and city: New York, Washington. The country USA has most no of museums and the cities New York and Washington (in USA) have the most no of museums. Other cities ie London and Paris should not be included in the output.
Exactly! That's my confusion too. I assumed that we need to show the cities with max museums in countries with the max museums. Maybe it's the phrasing of the question that's throwing me off. Thoufiq....would you care to explain please..?
Bro, I am not able to connect MySQL to Python and load the data into my database table. can you please help me? I have tried different methods but am still unable to make this happen.
Hi Thoufiq, Thank you for all your vedios. Is there any possibility that you can provide training personally by taking the charges? It would be highly helpful.
Hii... instead of Python can we use SSIS to load data into the respective tables.?? Kindly respond PLZ. Thank you for the efforts and the information. I learnt so much from your videos.
Great video! I really appreciate the part about Python since I always thought that it was really hard. However, you showed that with a few lines of code, you can achieve a lot even without being a programmer or something. Very useful! I have one question, maybe too about the solutions: Do we need any type of grant permission to run df.to_sql()?
Thanks a lot. Your content is amazing Sir. Hope to learn lot of things from you Sir. A small request, can you please post videos on performance tuning in SQL.
Hi toufiq, thanks for such a useful content for us im throughly following your veduos and posts. May i know where can i get the remain problem as shown in this project. I would like to practice remain problems.
Hey Thoufiq, Thank You. I have a question, you have made a video for practicing sql from different website can you please help us with python, where we can practice python specifically for Data Analysis
uploading datasets on sql should be preferred because studying datasets on python is more convinced but we can't study large datasets on python so learning sql for large sets must be preferred
sir I want to add this as a project in my resume , however, I am new to it , Could you briefly tell me how to mention (as in what key points to mention)?
Tried problem 10 using CTE, more complicated maybe : ) with cte as( select * from museum_hours where day in ('Sunday', 'Monday') ), cte2 as( select museum_id, string_agg(day, ', ') as days_comb from cte group by museum_id ) select museum.name, museum.city from cte2 left join museum on cte2.museum_id = museum.museum_id where cte2.days_comb = 'Sunday, Monday';
How is this? WITH cte AS ( SELECT museum_id, count(day) AS both FROM museum_hours WHERE day in ('Sunday','Monday') GROUP BY museum_id ) SELECT name, city FROM museum M JOIN cte C ON C.museum_id = M.museum_id WHERE both = 2
--we can also solve q10 from this way Select m.name, m.city, m.state, m.country from museum m join museum_hours mh on m.museum_id = mh.museum_id where mh.day = 'Sunday' Intersect Select m.name, m.city, m.state, m.country from museum m join museum_hours mh on m.museum_id = mh.museum_id where mh.day = 'Monday'
Hi, Postgres did not allow my query to run, is there any database permission issue, I tried to run the same Python script and also created a "painting" database, with no error from the Python script but unable to see any database changes.
Hi Toufiq, I am trying to connect to the PostgreSQL using the python script you have provided but I am getting the Syntax error at the initial step itself. Please help me if possible. Thanks in advance
![Stromae, Pomme - “Ma Meilleure Ennemie” (from Arcane Season 2) [Official Visualizer]](http://i.ytimg.com/vi/1F3OGIFnW1k/mqdefault.jpg)
You are the best person I found on youtube to explain SQL queries so simply, clearly and correctly..please do keep making such videos and helping people like me..Thanks so much..
I always consider you as my primary SQL mentor. 🙏😊
Could you please provide us the answer key for the questions mentioned in the video? I would like to solve those questions
Thank you ☺️
The solutions are already provided in my blog. You can find the link in video description
Its great for freshers who wants to improve their problem solving skills
This guy is amazing!!! The stuff I have learnt from you is infinite, God bless!!! And please, make more video!!! Make it longer, tackle all the questions, we are hear to learn!!! SIMPLY AMAZING!!! THANKS
Thank you so much :) Much appreciated.
As a fresher I'm feeling good that i have learned how to upload multiple file into databse using this simple python script in a few seconds 😀
This guy is so smart ... I'm dicovering incredible tricks in SQL. Amazing.
i never leave comments on youtube but have to say that your videos are by far the best ive found ( after extensive searching )in regards to learning data analysis thank you very much!
This is pretty straight forward, precise and crisp. Good content explained in a great way. So helpful. Thank you.
Can we use groupby in question 10.
How it is different from day in (‘sunday’,’monday’)
superb affords. really hats of to you.please start a playlist videos for data engineers.which will help lots of techies
Wait for more such kind of videos
will look into it. thank you
You are really perfect mentor for postgray sql, Thanks a lot 😍👍👍
Thank you for this one. I hope I'm not asking too much as I would like you to do another one covering the remaining questions.
hi thoufiq, great video. I just wanted to point out that in the third query the desired output should be country:USA and city: New York, Washington. The country USA has most no of museums and the cities New York and Washington (in USA) have the most no of museums. Other cities ie London and Paris should not be included in the output.
Exactly! That's my confusion too. I assumed that we need to show the cities with max museums in countries with the max museums. Maybe it's the phrasing of the question that's throwing me off. Thoufiq....would you care to explain please..?
Much awaited😍As always, best of the best 👍
Thank you :)
Your videos always inspires to dig more into subject. Can i get the detailed SQL sessions from basics to advance and also with real time scenarios.
Bro, I am not able to connect MySQL to Python and load the data into my database table. can you please help me? I have tried different methods but am still unable to make this happen.
Excellent and very informative, learned a lot of new things in SQL and python from this video. Thanks.
Hi Thoufiq,
Thank you for all your vedios.
Is there any possibility that you can provide training personally by taking the charges?
It would be highly helpful.
The data can be imported in Mysql easily than writing code of this much but I came to know about this way 👍👍
Teach me. I know the data wizard way
Waiting for this kind project 😊
I enjoyed the video cos you teach so well.
Thanks, man.
Amazing query has learnt from you. Thanks
You are Genius Man.🙌
Yes sir plz make more. Plz make some interviews specific ones
Excellent tutor,
Awesome... please make such more videos
Thanks a lot. You are amazing as always. Great content! 🥰
Your welcome 🙏
Thank you so much sir, this is very helpful video ❤🙏
I found your video very helpful. Thank you for putting so much effort to teach us.
🎉🎉 this is a blessing 🙌
Hii... instead of Python can we use SSIS to load data into the respective tables.??
Kindly respond PLZ.
Thank you for the efforts and the information. I learnt so much from your videos.
Very interesting video. Please make some more such case study videos. Thanks in advanced
Nicely explained sir. One question - What if we just want to add/append the data in the existing table using python?
Great video! I really appreciate the part about Python since I always thought that it was really hard. However, you showed that with a few lines of code, you can achieve a lot even without being a programmer or something. Very useful! I have one question, maybe too about the solutions: Do we need any type of grant permission to run df.to_sql()?
Thanks a lot. Your content is amazing Sir. Hope to learn lot of things from you Sir. A small request, can you please post videos on performance tuning in SQL.
Hi toufiq, thanks for such a useful content for us im throughly following your veduos and posts.
May i know where can i get the remain problem as shown in this project. I would like to practice remain problems.
Thank you for this tutorial. Please what connector can i use for MySqQL
My sql mentor😊😊😊😊😊
Hey Thoufiq, Thank You. I have a question, you have made a video for practicing sql from different website can you please help us with python, where we can practice python specifically for Data Analysis
You are the best sir
And this video is so so superb!💝😍
Thank you
Very nice content!
Hi Thoufiq! I am using MQLWork bench instead of Postgresql. Is the process the same for connecting to the database?
Finally wait is over
Hi TFQ!!!Could you please make videos on MsSQL
I have one question, are you create the tables before?
uploading datasets on sql should be preferred because studying datasets on python is more convinced but we can't study large datasets on python so learning sql for large sets must be preferred
In problem 15, you finished with a subquery and where rank = 1 statement. Would a simple limit 1 have worked the same?
Great video. Is there chance for you to make video on pyspark as well?
For question 10 can it also be WHERE day = ‘Sunday’, ‘Monday’ or Where day IN (‘Sunday’, ‘Monday’)?
Superb explanation 👌 👏 👍
Thank you 🙂
Which ide are you using? For sql
I would like to see a similar video for MongoDB
Wonderful content 👏👏👏
facing issues as no module as pandas , could you make a video on python installation and configurations
sir I want to add this as a project in my resume , however, I am new to it , Could you briefly tell me how to mention (as in what key points to mention)?
May Allah also make me master in Sql like u....❤
Aameen
Tried problem 10 using CTE, more complicated maybe : )
with cte as(
select * from museum_hours
where day in ('Sunday', 'Monday')
),
cte2 as(
select museum_id, string_agg(day, ', ') as days_comb
from cte
group by museum_id
)
select museum.name, museum.city
from cte2
left join museum on cte2.museum_id = museum.museum_id
where cte2.days_comb = 'Sunday, Monday';
How is this?
WITH cte AS (
SELECT museum_id, count(day) AS both FROM museum_hours
WHERE day in ('Sunday','Monday')
GROUP BY museum_id
)
SELECT name, city FROM museum M
JOIN cte C
ON C.museum_id = M.museum_id
WHERE both = 2
At 34:15 you could have also used GROUP BY Country instead of doing all distinct and string agg for that.
there are always multiple ways to solve a problem in SQL. However I am not sure what you exactly mean but I am sure there are other solutions too
34:06 since the countries were getting repeated, you could have only used GROUP BY Country instead of using another string agg.
Want to learn sql from scratch from you.Are there any classes conducted by you? could you please show the path?
Following as I would be interested
He has a sql class. You can check his blog. I took his class last year and it really improved my sql skills
Thanks
Thank you for another nice video.
Thank you too!
Thnk u so much toufique please one migration project scenario from python to snowflake how it's behavs and how it wil done pls make an video
I have already done one project using python and snowflake. may be check that out. linke below:
ruclips.net/video/GHtX0QXfi6g/видео.html
Hi! Thank you for great video! Is the procedure is same for uploading the csv from Python to MySQL? (I have zero knowledge of Phyton:)
No , db_url method will be different
Hi, please grant my request. Could you please make a video about sql triggers or dcl?
Sir when join two CTEs, why do we need to use CROSS JOIN? Why can't we simply use a comma? Like
SELECT *
FROM t1,t2
sale price means discounted price from regular price thank you
there is no sell price its sale so it is discounted
All set to do this.. 😊
Can we use LIMIT clause in Q no. 15 instead of Rank function ?
i also used limit in last two queries . worked absolutely fine
can i import data with the given method for mysql? python to mysql
Thanks!
Thank you ❤️
Awesome
@techTFQ pls how should i approach' to_timestamp' in MSSQL
Hi, can wecuse anaconda for python instead of visual basics
Can we do this with SQL server with same python script?
I never even heard about exists. Can query 1 be done in another way?
good video
Hello Thoufiq , will the same line of code work for sql server too as I am working on it
What if in case, I need to upload files from an s3 or from source other than local machine. how can I upload it to DB using python?
Is this put in resume?
can i use pycharm?
Hi
If you could share the PowerBI project on Information Security.
Thank you in advance
--we can also solve q10 from this way
Select
m.name,
m.city,
m.state,
m.country
from
museum m
join
museum_hours mh
on m.museum_id = mh.museum_id
where
mh.day = 'Sunday'
Intersect
Select
m.name,
m.city,
m.state,
m.country
from
museum m
join
museum_hours mh
on m.museum_id = mh.museum_id
where
mh.day = 'Monday'
Sir please create sql course for college students
We don't much more money
Please create udemy course
Thanks sir❤
Can you please help me with converting time from varchar to time datatype in MSSQL server. thank you
Hi you are going to start SQL batch where will i get link for that
Hi Thoufiq,
I tried different way, but could not find altrenative to to_timestamp() function for mysql, is there any?
How load data into database
Hi,
Postgres did not allow my query to run, is there any database permission issue, I tried to run the same Python script and also created a "painting" database, with no error from the Python script but unable to see any database changes.
sir can you explain Q-14 query, please
Thank you
I am really having a hard time connecting to the postgres with python, the code is refusing to work, frustrated
why do we need to send the datasets to sql any more while we can use pandas to read them ?!
Assalamu alaikum warah.
Taufiq, can you please do an SQL video on time series analysis?
Walaikum salaam ,
sure, let me consider it.
Thanks. Waiting 😊.
how can we show this as a project like writing a report or what?
Hi Toufiq,
I am trying to connect to the PostgreSQL using the python script you have provided but I am getting the Syntax error at the initial step itself. Please help me if possible.
Thanks in advance
Before doing his method, create virtual environment and then install pandas, sqlalchemy, pyscopg2 and then follow him
I am unable to see any CSV file in the Document path
can you please explain on how to do it in mysql ?