No one can make SQL look so easy! Totally worth learning SQL from your recent boot camp cohort 2. The way you approach and solve complex queries by breaking them down into smaller parts was the most important thing I learned from you! ♥ Keep bringing such content, this is what raises my confidence even more in SQL!! 😅🙌
@rishabh_fitness327311 ай бұрын
hands down!! what a genius you are ! specially the third problem and the explaination just wow,,, taufiq sir because of you , i have cleared many concepts of sql...may god bless you taufiq
@yi-lehung631111 ай бұрын
Such great SQL content videos! I can always learn things from your videos. Shoutout to techTFQ!
@techTFQ11 ай бұрын
Happy to hear that! Thank you so much
@ManpreetSingh-tv3rw11 ай бұрын
Query 3 ,MSSQL with echo as (select state,candidate_id,count(candidate_id) as seatcount_byid from results_tab group by state,candidate_id), rt as ( select *,dense_rank() over (partition by candidate_id order by seatcount_byid desc) as position from echo), final1 as (select * from rt where position
@fenix662710 ай бұрын
After a week of watching your lessons, I was able to solve these queries for myself, thanks a lot.
@techTFQ8 ай бұрын
Great 👍
@kunalkumar-hl6gv11 ай бұрын
this is not intermediate level but yet it is very useful there are so many things to get from this video
@techTFQ11 ай бұрын
good to know
@vishalgoswami751211 ай бұрын
what level is this then?
@rohankhubchandani369411 ай бұрын
@@vishalgoswami7512i would say it’s advanced
@ST-actual10 ай бұрын
Super useful. I’m relating everything I learn about SQL to New Relic which is what my company uses for observability.
@techTFQ8 ай бұрын
Thank you very much 😊
@vasimahamadshaikh373011 ай бұрын
Toufiq bhai what explains yaar . Everyone should understand what you want to give us from this video.great Bhai
@techTFQ11 ай бұрын
Thank you so much bro 😀
@dingaroo20036 ай бұрын
Greetings brother, from Singapore. As a working adult who is doing self-study, such exercises with step-by-step solutions are extremely priceless! Thank you Taufiq.
@maghy_kethychannel11 ай бұрын
Hi toufiq really hats off to your afforts and explanation.plz start an exclusive course on data analytics.
@techTFQ11 ай бұрын
Thank you bro, I will try my best
@sakshipandey51377 ай бұрын
Excellent explanation!!💯 Thankyou for making our life easy. God bless you!
@sivagowthu85911 ай бұрын
1st question my way of approach with cte as( select * from candidate c inner join results r on c.id=r.candidate_id) select party,count(*) as no_of_seats from( select *,dense_rank()over (partition by constituency_id order by votes desc) as rn from cte ) dt where rn=1 group by party
@saiswaroop357011 ай бұрын
Hi, toufiq your videos on SQL are very good and your explanation is very detailed. It would be helpful if you post more content on SQL like this and share some roadmaps how we can grow with SQL as primary skill. Please suggest some good certification courses for SQL that are available online
@sravikav10185 ай бұрын
It's really awesome explanation and this is the best SQL channel i have ever got,thanks a lot for sharing the knowledge. Looking forward for the more videos with SQL examples.
@ambeshpandey89372 ай бұрын
First one my approach with cte as(select *, min(votes) over (partition by constituency_id) as lowest_vote from result), cte2 as( select *, (votes-lowest_vote)as vote_diff from cte), cte3 as ( select *, row_number() over (partition by constituency_id order by vote_diff desc) as rnk from cte2) select concat(c.party,' ',count(*)) as party_seats from cte3 join candidate c on cte3.candidate_id=c.d where rnk=1 group by c.party
@user-ks5nx9jk6u6 ай бұрын
Thank you Toufiq bhai, the way that you explained queries is so good and i hope who don't have any knowledge on sql they will easily to understand
@mounikathouda3 ай бұрын
Explaining step by step clearly. Good Video 😊
@user-kp6ev3ls5c11 ай бұрын
The way of approach is easy to understand and follow , Thank you so much.
@devarapallivamsi70643 ай бұрын
I am seriously gonna laugh at people if they opt for any paid course of SQL even after coming across your channel. Hands down I would choose you over anyone to learn SQL from.
@vigneshwarannallasamy11 ай бұрын
Hi Thoufiq, really loved your videos and learned a lot from you. It will be beneficial if you can share the Cheat Sheet of SQL syntaxes.
@riasingh113 ай бұрын
You are the best tech teacher
@pravinbhojane898 күн бұрын
Nicely explained 🙌🏻
@fathimafarahna263311 ай бұрын
You are as always best 💯 God bless
@techTFQ11 ай бұрын
Thank you so much 😀
@ganeshvbidwe11 ай бұрын
Oh great video and insightful Upload more video about stored procedure and udf functions with exception handling
@techTFQ11 ай бұрын
Thank you and noted bro
@nikhilreddy458211 ай бұрын
Bro u r a gem... Keep doing many more contents. This help me understand to solve the queries in a more better way. As I have also attempted these queries but failed to solve it. These are from hacker rank got it in a meesho 1st round. These video help me understand much better. Thanks a lot broo...
@F_A_R_man7 ай бұрын
Thanks for efforts. Your content is very useful 🥰
@avinashpratapsingh38759 ай бұрын
Hi @techTFQ in the second query you have use group by clause on alias customer and status, but as per execution order group by is executed before select, so when I tried running query you explained it throws me error invalid identifier, Cn you please let me know what to do. I am using Oracle SQL Developer
@lalitak940411 ай бұрын
Here is the query with out window function : Select concat(party,' ',count(*)) from (select constituency_id,max(votes)as votes from candidates c inner join results r on c.id=r.candidate_id group by constituency_id)as temp inner join results r on temp.constituency_id=r.constituency_id and temp.votes=r.votes inner join candidates c on r.candidate_id=c.id group by party;
@TheDocValerian9 ай бұрын
This is a great video. I can only imagine how it is to solve if you had to wtite this on a simple paper as a candidate
@techTFQ8 ай бұрын
Thanks:)
@mkarvj11 ай бұрын
You are absolutely amazing sir!!!!
@brunomiguel35339 ай бұрын
Amazing stuff. Really enjoyed it and learned a lot. 5 stars!
@techTFQ8 ай бұрын
Thank you
@vermaji52207 ай бұрын
with cte as (select c.id, c.party,r.constituency_id,r.votes from candidates as c inner join results as r on r.c_id=c.id), cte1 as( select * , rank() over (partition by constituency_id order by constituency_id, votes desc) as rn from cte) select party, count(1) as won_seat from cte1 where rn=1 group by party
@RoopmathiGunnaubcmba11 ай бұрын
The third one was the most challenging for me to get my head around.
@DHA50811 ай бұрын
Thanks for awesome session.
@LokeshKumar-ii1or10 ай бұрын
Hi Sir Please do one video for how to retrieve specific data from XML column in Oracle SQL
@HARSHRAJ-wz2rpАй бұрын
with cte as( select candidates.*,constituency_id,votes FROM candidates JOIN results ON candidates.id=results.candidate_id ) select constituency_id,party FROM(select constituency_id,party,votes,DENSE_RANK()OVER(partition by constituency_id ORDER BY votes DESC) as "x" FROM cte) as es where es.x=1;
@ceejayachky627911 ай бұрын
You are an excellent teacher.
@krishnakantsharma80216 ай бұрын
Wow, you are the best🎉
@gayatribhuyan160011 ай бұрын
Hi,Can you make some sql interview questions for data engineers.
@techTFQ11 ай бұрын
let me see if I can find any
@newenglandnomad940511 ай бұрын
I understand the interview questions. What I don't understand is how that political query would apply to the job. I have a friend that works in Soccer, and he's asked to query seat sales by seat type or unsold or whatever, and sends a spreadsheet with the answer. Are these interview questions like just practice sandbox type queries? Thanks for educating us.
@dkaustubh11 ай бұрын
Great video ❤ Thanks !
@techTFQ11 ай бұрын
Glad you liked it!
@murchhanabanerjee8626 ай бұрын
Hi Taufiq, I am your fan ! You have become the ultimate destination to clear doubts & concept. I want to share 2 sql problems which I couldn't solve in interview. How should I share ? Can't find your email in this chat .
@techTFQ6 ай бұрын
Thank you 🙏 Glad to hear that .. my email techtfq@gmail.com
@saswatkumar25176 ай бұрын
brilliant explanation
@Kondaranjith311 ай бұрын
Hi sir string_agg function in postgress but i am using mssql server i could not find the aternative function for it
@shivambansal356011 ай бұрын
try going with group_concat()
@BharathKumar-id8wk11 ай бұрын
❤good one
@chaitusai76742 ай бұрын
select * from(select c.party, count(c.party), rank() over(partition by r.constituency_id order by votes desc) as rnk from candidates c join results r on c.id=r.candidate_id group by c.party) x where x.rnk=1; is this good?
@chaitusai76742 ай бұрын
why have you removed order by clause within cte? in 3rd query? please anyone explain
@dikshapatiyal59864 ай бұрын
You are Amazing
@m.kirubakaran656411 ай бұрын
Thanks Man.. very very useful.. very easy to understand Big Thx......
@jakusam456411 ай бұрын
Dear sir ,when your next SQL live bootcamp start?eagerly waiting for this
@achunaryan341811 ай бұрын
Excellento.
@rimaranimeher96449 ай бұрын
Please do more interview questions on mysql
@techTFQ8 ай бұрын
Noted
@Al-Ahdal11 ай бұрын
Hi I am a professional accountant, and do loads of business analysis, reporting etc in Excel. I would like to learn Business SQL for Data Analytics, kindly share the road map and learning source. Thanks
@user-pz8vn8ht9u11 ай бұрын
Do you have any idea of starting PlSql bootcamp?
@varunl69489 ай бұрын
Thanks for this!
@techTFQ8 ай бұрын
You're welcome
@kamalikamukherji648211 ай бұрын
Ur the best❤
@deepaknayak119511 ай бұрын
Thanks ❤
@techTFQ11 ай бұрын
You're welcome 😊
@jayantachakraborty491511 ай бұрын
08:48 I did not understand why we used count(1). Could you help me understand?
@RoopmathiGunnaubcmba11 ай бұрын
@TechTFQ: This question is for which company? In India or North America?
@RajeshwarUma11 ай бұрын
Thank you so much
@favoura55557 ай бұрын
Why did we join when we already used cte?
@nivisworld151311 ай бұрын
Hai....sir.... please write the querys 1) how to find highest salary of the employee? 2) query to find 2nd ,3rd,4th ....higest salaries? And query to find nth highest salary?
@vishalgoswami751211 ай бұрын
use rank over order by salary
@nivisworld151311 ай бұрын
@@vishalgoswami7512 if u don't mind....can you write?
@amolgmagar15 күн бұрын
website is not working. any other link for dataset?
@razikamuthu379511 ай бұрын
Can you please share next boot camp slots for SQL
@houcineb413911 ай бұрын
thank you
@rushikeshjoshi950611 ай бұрын
I know this is from hacrkrank interview questions for ETL Testing I faces this all 3
@techTFQ11 ай бұрын
nice, good to know
@sarvesht729911 ай бұрын
Which company bro ?
@pratheeshsailor519311 ай бұрын
@@sarvesht7299meesho
@b_rizzle480811 ай бұрын
will using an order by in a cte slow down query performance? or will it just be ignored
@techTFQ11 ай бұрын
order by is unnecessary inside a cte because the purpose of cte is to return a resultset, how the resultset is ordered is not necessary. And yes order by will consume some resources so better to avoid it when its not required
@dravidbalaji13736 ай бұрын
Super bro
@balaroxx2700Ай бұрын
String_arg() inside distinct is not a valid in ms sql please give me alternative code😢 19:32 also the order by inside strinģ arg 35:48
@ramshabdaramnaresh943811 ай бұрын
In SQL Server string_agg not supporting distinct then how to solve 2nd one
@rickymahakul387111 ай бұрын
My age is 32 can I enter into data analyst job if I acquire skills required for this job role
@mohanmuppidi684610 ай бұрын
S man.. It is good
@techTFQ8 ай бұрын
Thank you
@anudeepreddy555911 ай бұрын
Plsql bootcamp please
@promitdutta302910 ай бұрын
how to do string_agg fcn in mysql ?
@jetsfromnewjersey137711 ай бұрын
Hi taufiq i want to buy sql course but payment portal is not able to accept my card itrat ali from NJ USA
@user-bg1bn7np4u11 ай бұрын
Can we use count(*) instead of count(1) in my sql?
@jayantachakraborty491511 ай бұрын
Same question. Did you find any solution?
@RyanLoh10 ай бұрын
Hi which software are you using to write this SQL code?
@techTFQ8 ай бұрын
PostgreSQL DB, PG Admin tool
@nivisworld151311 ай бұрын
I know these are the basic qns but i need proper queries plz ...( if anybody see my mes... u can also rply )
@Fitness_Gallery11 ай бұрын
Sir please make the video in Hindi because Hindi is familiar for us
@rohit_vora3 ай бұрын
with cte as (select row_number() over(partition by party ) rn, c.id, party, constituency_id, votes from candidates c join results r on r.candidate_id = c.id), cte2 as (select c1.id, c2.id, c1.party, c1.constituency_id,c2.constituency_id, c1.votes dvot, c2.votes rvot from cte c1 join cte c2 on c1.constituency_id = c2.constituency_id and c1.rn = c2.rn and c1.party c2.party), cte3 as (select *, case when dvot > rvot then 1 else 0 end flag from cte2) select concat(party, ' ', total) wons from (select party, sum(flag) total from cte3 group by 1)
@farzanahmed55302 күн бұрын
-- Hi, I tried without CTE, Please check my query sir :- SELECT Party, count(*) FROM [dbo].[candidates] WHERE ID IN (SELECT r1.candidate_id from [results] R1, [results] R2 WHERE R1.Constituency_id=R2.Constituency_id and R1.VOTES< R2.VOTES ) GROUP BY Party