No video

#10 SQL 25 Practice Questions | DDL, DML, DQL, Group by, Having | SQL Tutorial for beginners | tamil

  Рет қаралды 52,233

Error Makes Clever

Error Makes Clever

Күн бұрын

Unlock the power of SQL with our comprehensive guide! In this in-depth video tutorial, we cover 25 fundamental SQL questions and answers that encompass Data Definition Language (DDL), Data Query Language (DQL), Data Manipulation Language (DML), GROUP BY, and the HAVING clause. Whether you're a beginner looking to learn SQL from scratch or an experienced developer looking to sharpen your SQL skills, this video has something for everyone.
Here's what you can expect from this tutorial:
- *DDL:* Discover how to create, modify, and manage database structures like a pro.
- *DQL:* Learn the art of querying data with SELECT statements and filtering your results effectively.
- *DML:* Master the skills needed to insert, update, and delete data while maintaining data integrity.
- *GROUP BY:* Dive deep into grouping and aggregating data to gain valuable insights.
- *HAVING Clause:* Explore how to filter grouped data and harness its power for advanced analysis.
Each SQL question is meticulously explained with clear examples and detailed answers, ensuring you understand the core concepts and best practices. Whether you're preparing for an interview, enhancing your database skills, or simply curious about SQL, this video is your one-stop resource.
Don't miss out on this opportunity to become a SQL expert! Hit the play button now and level up your database skills. If you find this video helpful, please like, share, and subscribe for more informative tutorials on SQL and database management.

Пікірлер: 144
@karthik-k06
@karthik-k06 10 ай бұрын
Learnersku neeenga kidachathu periya luck bro🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉 you Always Rocking🔥🔥🔥🔥🔥
@Fathi_editz_
@Fathi_editz_ 10 ай бұрын
Yes of course dude🎉🎉🎉🎉
@art_gj_8830
@art_gj_8830 10 ай бұрын
Sirously bro last 9 sql videos proper ah listen panni practice panna naala idhula irukka 24 questions correct ah workout pannitten.. ❤ Thankyou!
@techieguy1012
@techieguy1012 9 ай бұрын
Please continue this SQL series bro... 🎉
@arunkumarbalasubramani
@arunkumarbalasubramani 10 ай бұрын
Brother, ur way of explanation is just amazing.. U dont know how much u r helping people...
@collegiate8681
@collegiate8681 3 ай бұрын
Happy to share that I've learnt from your videos and done this all 25 questions by myself with less than 5 times errors.. Thank you so much ❤
@aswiniiyer76
@aswiniiyer76 10 ай бұрын
Yours videos are very helpful, clear explanation with examples. SQL Joins pathi videos podunga adh konjam kooda helpful ah irukum✨✨
@mrromeo-wr3yl
@mrromeo-wr3yl Ай бұрын
17 th ku answer thappu bro bec question la (group students by age ktrukanga) but neenga (group by finalgrade) potrukeenga.otherwise spr explanation and teaching very well😊
@vaishnashanmugam5385
@vaishnashanmugam5385 3 күн бұрын
Thank you for the amazing SQL playlist! It's been super helpful for my studies🥰
@ErrorMakesClever
@ErrorMakesClever 3 күн бұрын
Glad it was helpful!
@radhikasubramanyam5967
@radhikasubramanyam5967 3 ай бұрын
Too good Explanation, please post joins concepts ,it will be very much useful.
@ErrorMakesClever
@ErrorMakesClever 3 ай бұрын
Thanks
@MahaLakshmi-ol5et
@MahaLakshmi-ol5et 2 ай бұрын
Much appreciated Mr.john 😊❤at finally i learn the basic of SQL !! 😌🤗my heart is forever indebted to you ! thanks a lot again nd again buddy 🦋 Best wishes for continued growth❤🎉 
@ErrorMakesClever
@ErrorMakesClever 2 ай бұрын
Happy to hear that!
@Dharshini00009
@Dharshini00009 2 ай бұрын
omsairam..om muruga..thanks for guidance in my journey
@sampatrick93
@sampatrick93 6 ай бұрын
Great Salute to you Bro❤❤❤U Have taught in a very easier way...
@hemalathal5372
@hemalathal5372 9 ай бұрын
Bro neenga sema clear ah explain panringa, please itha continue panunga bro
@shenbagavallilakshmikantha6061
@shenbagavallilakshmikantha6061 Ай бұрын
Anna this session was really useful to us. Ur explaination was extremely good easy understandable na Ella exercises um senjuparthen..can you plz continue this thereby we can learn SQL better...thank you anna!
@swathy2412
@swathy2412 10 ай бұрын
Broo unga video romba romba useful & easy to learn ....but 2 days once videos potrunnga broo....late aana concept relate aaga maatiku
@VasanthVasanth-hp7kb
@VasanthVasanth-hp7kb 2 ай бұрын
Tq bro able to solve 22 question more content from SQL is recommended bro 🎉😊
@moideenfathima2751
@moideenfathima2751 10 ай бұрын
Anna nenga irukarathu nalla yenaku romba romba easya html css js kathukitta romba romba thanks And finally last request anna c & c++ Video poduvigala
@vijayksvk
@vijayksvk 9 ай бұрын
Its not enough 😅
@SCVISHNUM
@SCVISHNUM 6 ай бұрын
Bro trigger procedure elm podunga bro pls bro neenga suprah explanation panringa bro waiting for your next videos bro
@nagendranm4902
@nagendranm4902 Ай бұрын
Thankyou so much bro,,very nice explanation🤩please continue the SQL series bro.....
@Self_RnD
@Self_RnD 6 ай бұрын
Hi brother, I have gone through all the SQL series Videos, It was so helpful, Thanks a lot😊
@vijayasharathigaming3441
@vijayasharathigaming3441 6 ай бұрын
Anybody got an error on update statement like safe updates like that you can run the statement like SET SQL_SAFE_UPDATE=0; you can solve it.
@user-my7kn6go8p
@user-my7kn6go8p 2 ай бұрын
15 .ques is sum of ages whose have finalgrade A or B but you write a command for finding avg(age) ...
@manikandanr8310
@manikandanr8310 7 күн бұрын
Yes crt, 😢 same doubt for me
@nisha__08
@nisha__08 10 ай бұрын
Tq so much fro practice questions. It is really helpful.
@vaishnashanmugam5385
@vaishnashanmugam5385 2 күн бұрын
hello anna ,Could you please upload a full ML & DL playlist along with some beginner friendly shorts or tips?
@PoojaVijayaraja
@PoojaVijayaraja 2 ай бұрын
Bro thank you for teaching sql bro✨😇 awesome teaching ever✨💯
@saroelanthirai6559
@saroelanthirai6559 3 ай бұрын
Bro functions, and how to write and create a stored procedure video podungaaa brooo.....it will help a lott brooo.....
@lavanyaselvaraj6171
@lavanyaselvaraj6171 8 ай бұрын
Bro unga class sprb ah iruku...neraiya class edunga bro
@AkashSG-t2z
@AkashSG-t2z 11 күн бұрын
22.32 . In this question they ask to group by age . It means we need to define the age group like 10-15 children, 16-22 teen , above 22 - adult for example I am saying. But you group by the final grade Explain me this if I am wrong. Thank you
@subhasbose4554
@subhasbose4554 10 ай бұрын
bro neeng tech pandrathu semma easy ahh irukku bro so one of my kind request enna konjom fast ahh video upload pannunga bro 2days SQL na ennanu easy ahh purinjittu bro
@user-ly9yq8qy9w
@user-ly9yq8qy9w 2 ай бұрын
where is next vedio about primary key and foreign key vedio #11?? is he not posted yet?
@hennalis_2016
@hennalis_2016 10 ай бұрын
Bro pls make javascript video 😢😢
@user-pt9dx3ep3y
@user-pt9dx3ep3y 10 ай бұрын
Waiting too long for this continuation bro
@deekshidha3794
@deekshidha3794 Ай бұрын
This is so so useful thank you
@user-ru4om6by8q
@user-ru4om6by8q 4 ай бұрын
to 9th question ,we have to use "and" condition for both grades.ex:grade="a" and age>=19 or grade="b" and age>=19.in your case it only check age with b grade only,
@anandn1244
@anandn1244 7 ай бұрын
Bro requesting u to pls update more videos regarding SQL
@agent-caw
@agent-caw 9 ай бұрын
Continuation of this series please.
@kalaisselvi6365
@kalaisselvi6365 10 ай бұрын
Bro fulla podunga bro eppadi thaniya thaniya video poringa na mudika time agum bro. full series podunga bro please 😔
@arunprabhu6399
@arunprabhu6399 8 ай бұрын
Bro please post the next series of videos related to SQL
@user-pi2ju1ri3i
@user-pi2ju1ri3i Ай бұрын
Kindly continue the advance topics of SQL.
@donisha578
@donisha578 10 ай бұрын
Leet code java problems daily onnu podunga bro
@rajeshwarisugumar7592
@rajeshwarisugumar7592 18 күн бұрын
Bro SQL la constraints method and joins types la podunga bro pleaseeeee😢
@aravinthdavid8837
@aravinthdavid8837 10 ай бұрын
JavaScript vachu oru 5 project video podunga
@Fathi_editz_
@Fathi_editz_ 10 ай бұрын
Yes bro we need a js ......😢
@Indhusivaranjani
@Indhusivaranjani 2 ай бұрын
Bro sql la ella topics uu podunga bro...for example explanation of all type of constraints, joins... kind request...
@nethajis1465
@nethajis1465 10 ай бұрын
Bro 10 videos complete pls upload next video 2 or 3 days
@arunrajappa4073
@arunrajappa4073 4 ай бұрын
🙌 Thank you, ECM, for the helpful SQL tips! I've learned a lot and feel more confident in my SQL skills now. Your explanations were clear and easy to understand. Keep up the great work! To everyone benefiting from ECM's content, don't forget to like, subscribe, and share the videos to support this amazing channel! 🚀 God Bless ECM 🙌
@-IT-PraveenKumarM
@-IT-PraveenKumarM 9 ай бұрын
Bro I completed this series next video upload pannuga
@dineshkumarr3932
@dineshkumarr3932 10 ай бұрын
bro javascript ku video podunga next uh
@user-jo5fr8ht3p
@user-jo5fr8ht3p Ай бұрын
thank you brother
@j.sanjeev6122
@j.sanjeev6122 10 ай бұрын
Bro python advance tutorial podunga bro
@mathiazhaganms6015
@mathiazhaganms6015 10 ай бұрын
UPLOAD DAILY VIDEOS BRO
@ErrorMakesClever
@ErrorMakesClever 10 ай бұрын
We will try our best to upload videos daily from today bro :)
@christofer315
@christofer315 11 күн бұрын
Bro I think answer for 18th question is wrong because In that question you asked to find the grade with the highest number of students that means which grade having more students , like that I have understand , in this code written ["select count(*),Finalgrade from Student group by Finalgrade order by Finalgrade desc limit 1 ; "] only the highest grade of students but this line of code ["select count(name),Finalgrade from Student group by Finalgrade order by count(name) desc limit 1 ;"] give the highest number of students scored in perticular grade , am I correct bro thanks for your tutorial .........
@sneharaju04
@sneharaju04 10 ай бұрын
Java Script video please 🙏🏼
@Hacks_vlog
@Hacks_vlog 4 күн бұрын
Broo w3 schools python laa konjam neriya new keywords iruku bro edu kuda compare pandra apoo
@nvsbflims4624
@nvsbflims4624 2 ай бұрын
Bro 24th question answer is select * from students order by finalGrade asc
@kdeditsyt2723
@kdeditsyt2723 11 күн бұрын
18th question wrong❌ Order by count(*) tha varum🤔 25:15
@BlnDiary
@BlnDiary 10 ай бұрын
API pathi oru video podunga bro please
@gowthamr5676
@gowthamr5676 7 ай бұрын
Bro Continue this SQL series 🎉❤
@Pupush._._
@Pupush._._ 5 ай бұрын
Soooooo helpfull❤❤
@ajithkumarboopalan6808
@ajithkumarboopalan6808 10 ай бұрын
Bro linux ku idhe maadhiri tutorial videos podunga
@unlockingtheworld5736
@unlockingtheworld5736 9 ай бұрын
Kindly continue the lesson bro. kindly upload the videos bro
@janukanthaiya7350
@janukanthaiya7350 10 ай бұрын
join syntax kku video podunka anna
@saashh88
@saashh88 Ай бұрын
Very helpful thanks alot
@duolegends6959
@duolegends6959 2 ай бұрын
bro Please continue this SQL series
@sckcinemas
@sckcinemas 9 ай бұрын
Super na useful
@aishwaryaK-hx2ek
@aishwaryaK-hx2ek Ай бұрын
Bro pls continue sql series...
@priyaabirami1672
@priyaabirami1672 4 ай бұрын
Hi, do you have the full course video available for SQL basics? Do you take private classes ?
@SVSEEEGokul
@SVSEEEGokul 10 ай бұрын
Bro i have one doubt.? Actually.. Mysql leran panurathuku before sql leran pananuma.? I mean sql learn pana tha mysql leran pana mudiuma.? Sql and mysql rendume Simlerly same thana bro.? Konjam clear a slu ga bro.? First leran panurathuna ethu pananum sql Or mysql.?
@jeevitham-secb1334
@jeevitham-secb1334 8 ай бұрын
SQL is programming language and my SQL is software. We download MySQL software that is called RDBMS
@TogetherForever-ft3st
@TogetherForever-ft3st Күн бұрын
Intha playlist paducha pothum bro.. Sql start pandreengana intha playlist la irunthu start panunga
@TogetherForever-ft3st
@TogetherForever-ft3st Күн бұрын
Bro next topics um podunga bro 10 months ah waiting
@firstname1206
@firstname1206 7 ай бұрын
Please continue this SQL series
@shyamaladevi4799
@shyamaladevi4799 9 ай бұрын
SQL related Next vedio epa poduvinga bro
@sharathsrihari45
@sharathsrihari45 Ай бұрын
Is this enough to attend interview
@shivaj7091
@shivaj7091 3 ай бұрын
Please continue the session bro, or else pls give following topics
@kingsgowthas2932
@kingsgowthas2932 6 ай бұрын
Spr❤bro
@ramiyabalaji301071
@ramiyabalaji301071 6 ай бұрын
12) Greater than >C, but C datatype varchar()? does it compare with hashkey value? or am i missing something here?
@eswaryeswary1793
@eswaryeswary1793 4 ай бұрын
In 17 th question they asked us to group by age bro ,u grouped in by final grade 😮
@brindadeepa5360
@brindadeepa5360 Ай бұрын
Joins concept pls
@sathish2268
@sathish2268 3 ай бұрын
Anna update and delete matuim error show panuthu your are safe update or delete mode nu show panuthu Vera all ok but update and delete matuim Epadi panuthu
@Boobalanselvaraj
@Boobalanselvaraj 7 ай бұрын
bro continue the series please...
@user-jx5pq8td7y
@user-jx5pq8td7y 5 ай бұрын
bro pls continue this SQL series
@hemapriyaarumugam7577
@hemapriyaarumugam7577 4 ай бұрын
Can you explain foreign key referential integrity
@Archana_3024
@Archana_3024 10 ай бұрын
Bro 18th question la C la ipo 4 records irukathu la atha order by Finalgrade pottapo C- 4 nu vanthduchu.. Ithe suppose A la 5 grade iruntha order by Finalgrade desc pottu limit 1 kudutha C la ullathu than show aagum... So order by count(*) desc potta than antha question ku crct answer varum... Am i right or wrong? Let me know bro..
@DineshBdK-zo6gw
@DineshBdK-zo6gw 25 күн бұрын
Yes we need to use count(*) it shows a right answer
@DivyaDhinesh-wz3yn
@DivyaDhinesh-wz3yn 6 ай бұрын
Full ah one video va ah podunga Full SQL video podunga Practice questions nu podunga
@suganthiganesan7855
@suganthiganesan7855 7 ай бұрын
Waiting for continuation
@hemakalaiselvi1638
@hemakalaiselvi1638 10 ай бұрын
Bro please bro java script basics video podunga bro mid exam start aga podhu bro pls bro 😢 pls bro 20 per ungala nambi than bro irukom.
@nisvannisvanth6646
@nisvannisvanth6646 10 ай бұрын
Waiting for your further videos broo
@vaitheeshmurugavel3532
@vaitheeshmurugavel3532 7 ай бұрын
Done bro ❤ continuity podunga
@emma_heartsquad
@emma_heartsquad 3 ай бұрын
12:46[ select * from students where age between 18 and 25 ] ?
@sivashankar5496
@sivashankar5496 3 ай бұрын
Bro I have one doubt for question.no:15 Ask for Sum of age for the student but you solve problem in average age for the student bro....I confused😇😇😇
@goodboys1597
@goodboys1597 Ай бұрын
Bro .net video podunga bro
@creativedoit4379
@creativedoit4379 8 ай бұрын
16:23 bro they have asked to find the sum right then. Why do we have to find average ?
@krishnavenic7616
@krishnavenic7616 9 ай бұрын
Join and subquery explain pannunga bro please
@shay_talkz
@shay_talkz 6 ай бұрын
Broo intha join innerjoin athella ethula bro iruku
@PoojaVijayaraja
@PoojaVijayaraja 2 ай бұрын
Bro waiting for primary key and foreign key 😢
@snoopy8245
@snoopy8245 8 ай бұрын
Please do a video on joins in SQL 😢😢😢😢😢😢😢
@ramaprasath3958
@ramaprasath3958 3 ай бұрын
Bro continue SQL
@thirugnanam9632
@thirugnanam9632 Ай бұрын
Bro sql joins poduga bro
@CS-RubavathyMR
@CS-RubavathyMR 10 ай бұрын
Bro, please upload some questions to solve and practices
@sudhank6221
@sudhank6221 10 ай бұрын
Bro trigger , foreign key aprm kjm kastam ma problem vennum bro
@prakash3425
@prakash3425 10 ай бұрын
Java Script video podunga bro
@shrisherin2591
@shrisherin2591 10 ай бұрын
Bro two or more table ah merge pandramaari coding pottu explain pannunga
#11 Understanding SQL Primary Key | SQL tutorial for beginners | in tamil
8:34
Schoolboy Runaway в реальной жизни🤣@onLI_gAmeS
00:31
МишАня
Рет қаралды 2,9 МЛН
女孩妒忌小丑女? #小丑#shorts
00:34
好人小丑
Рет қаралды 58 МЛН
Please Help Barry Choose His Real Son
00:23
Garri Creative
Рет қаралды 21 МЛН
நாத்தனார் Paavangal | Parithabangal
14:52
Parithabangal
Рет қаралды 2 МЛН
SQL Tutorial for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 11 МЛН
Schoolboy Runaway в реальной жизни🤣@onLI_gAmeS
00:31
МишАня
Рет қаралды 2,9 МЛН