Тёмный

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

Error Makes Clever
Подписаться 765 тыс.
Просмотров 51 тыс.
50% 1

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.

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

 

4 окт 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 137   
@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...
@aswiniiyer76
@aswiniiyer76 10 месяцев назад
Yours videos are very helpful, clear explanation with examples. SQL Joins pathi videos podunga adh konjam kooda helpful ah irukum✨✨
@collegiate8681
@collegiate8681 2 месяца назад
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 ❤
@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😊
@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.
@Dharshini00009
@Dharshini00009 2 месяца назад
omsairam..om muruga..thanks for guidance in my journey
@AkashSG-t2z
@AkashSG-t2z 4 дня назад
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
@radhikasubramanyam5967
@radhikasubramanyam5967 3 месяца назад
Too good Explanation, please post joins concepts ,it will be very much useful.
@ErrorMakesClever
@ErrorMakesClever 3 месяца назад
Thanks
@user-my7kn6go8p
@user-my7kn6go8p Месяц назад
15 .ques is sum of ages whose have finalgrade A or B but you write a command for finding avg(age) ...
@manikandanr8310
@manikandanr8310 9 часов назад
Yes crt, 😢 same doubt for me
@sampatrick93
@sampatrick93 5 месяцев назад
Great Salute to you Bro❤❤❤U Have taught in a very easier way...
@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
@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!
@shenbagavallilakshmikantha6061
@shenbagavallilakshmikantha6061 25 дней назад
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!
@SCVISHNUM
@SCVISHNUM 6 месяцев назад
Bro trigger procedure elm podunga bro pls bro neenga suprah explanation panringa bro waiting for your next videos bro
@moideenfathima2751
@moideenfathima2751 9 месяцев назад
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 😅
@rajeshwarisugumar7592
@rajeshwarisugumar7592 11 дней назад
Bro SQL la constraints method and joins types la podunga bro pleaseeeee😢
@hemalathal5372
@hemalathal5372 8 месяцев назад
Bro neenga sema clear ah explain panringa, please itha continue panunga bro
@VasanthVasanth-hp7kb
@VasanthVasanth-hp7kb 2 месяца назад
Tq bro able to solve 22 question more content from SQL is recommended bro 🎉😊
@user-ly9yq8qy9w
@user-ly9yq8qy9w Месяц назад
where is next vedio about primary key and foreign key vedio #11?? is he not posted yet?
@saroelanthirai6559
@saroelanthirai6559 2 месяца назад
Bro functions, and how to write and create a stored procedure video podungaaa brooo.....it will help a lott brooo.....
@Self_RnD
@Self_RnD 6 месяцев назад
Hi brother, I have gone through all the SQL series Videos, It was so helpful, Thanks a lot😊
@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,
@nisha__08
@nisha__08 10 месяцев назад
Tq so much fro practice questions. It is really helpful.
@christofer315
@christofer315 4 дня назад
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 .........
@hennalis_2016
@hennalis_2016 10 месяцев назад
Bro pls make javascript video 😢😢
@agent-caw
@agent-caw 9 месяцев назад
Continuation of this series please.
@anandn1244
@anandn1244 7 месяцев назад
Bro requesting u to pls update more videos regarding SQL
@nagendranm4902
@nagendranm4902 Месяц назад
Thankyou so much bro,,very nice explanation🤩please continue the SQL series bro.....
@donisha578
@donisha578 10 месяцев назад
Leet code java problems daily onnu podunga bro
@user-pt9dx3ep3y
@user-pt9dx3ep3y 10 месяцев назад
Waiting too long for this continuation bro
@deekshidha3794
@deekshidha3794 Месяц назад
This is so so useful thank you
@lavanyaselvaraj6171
@lavanyaselvaraj6171 8 месяцев назад
Bro unga class sprb ah iruku...neraiya class edunga bro
@dineshkumarr3932
@dineshkumarr3932 10 месяцев назад
bro javascript ku video podunga next uh
@PoojaVijayaraja
@PoojaVijayaraja 2 месяца назад
Bro thank you for teaching sql bro✨😇 awesome teaching ever✨💯
@kalaisselvi6365
@kalaisselvi6365 10 месяцев назад
Bro fulla podunga bro eppadi thaniya thaniya video poringa na mudika time agum bro. full series podunga bro please 😔
@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
@-IT-PraveenKumarM
@-IT-PraveenKumarM 9 месяцев назад
Bro I completed this series next video upload pannuga
@Indhusivaranjani
@Indhusivaranjani 2 месяца назад
Bro sql la ella topics uu podunga bro...for example explanation of all type of constraints, joins... kind request...
@ramiyabalaji301071
@ramiyabalaji301071 6 месяцев назад
12) Greater than >C, but C datatype varchar()? does it compare with hashkey value? or am i missing something here?
@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.
@j.sanjeev6122
@j.sanjeev6122 10 месяцев назад
Bro python advance tutorial podunga bro
@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
@aravinthdavid8837
@aravinthdavid8837 10 месяцев назад
JavaScript vachu oru 5 project video podunga
@Fathi_editz_
@Fathi_editz_ 10 месяцев назад
Yes bro we need a js ......😢
@nvsbflims4624
@nvsbflims4624 2 месяца назад
Bro 24th question answer is select * from students order by finalGrade asc
@sharathsrihari45
@sharathsrihari45 27 дней назад
Is this enough to attend interview
@nethajis1465
@nethajis1465 9 месяцев назад
Bro 10 videos complete pls upload next video 2 or 3 days
@sneharaju04
@sneharaju04 10 месяцев назад
Java Script video please 🙏🏼
@priyaabirami1672
@priyaabirami1672 3 месяца назад
Hi, do you have the full course video available for SQL basics? Do you take private classes ?
@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 🙌
@emma_heartsquad
@emma_heartsquad 3 месяца назад
12:46[ select * from students where age between 18 and 25 ] ?
@unlockingtheworld5736
@unlockingtheworld5736 8 месяцев назад
Kindly continue the lesson bro. kindly upload the videos bro
@BlnDiary
@BlnDiary 10 месяцев назад
API pathi oru video podunga bro please
@kdeditsyt2723
@kdeditsyt2723 4 дня назад
18th question wrong❌ Order by count(*) tha varum🤔 25:15
@janukanthaiya7350
@janukanthaiya7350 10 месяцев назад
join syntax kku video podunka anna
@user-jo5fr8ht3p
@user-jo5fr8ht3p Месяц назад
thank you brother
@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 18 дней назад
Yes we need to use count(*) it shows a right answer
@ajithkumarboopalan6808
@ajithkumarboopalan6808 10 месяцев назад
Bro linux ku idhe maadhiri tutorial videos podunga
@Pupush._._
@Pupush._._ 5 месяцев назад
Soooooo helpfull❤❤
@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
@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😇😇😇
@hemapriyaarumugam7577
@hemapriyaarumugam7577 4 месяца назад
Can you explain foreign key referential integrity
@sckcinemas
@sckcinemas 9 месяцев назад
Super na useful
@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.
@creativedoit4379
@creativedoit4379 8 месяцев назад
16:23 bro they have asked to find the sum right then. Why do we have to find average ?
@brindadeepa5360
@brindadeepa5360 Месяц назад
Joins concept pls
@jeevithasivan30
@jeevithasivan30 25 дней назад
How to disable Safe mode?
@saashh88
@saashh88 Месяц назад
Very helpful thanks alot
@duolegends6959
@duolegends6959 2 месяца назад
bro Please continue this SQL series
@mathiazhaganms6015
@mathiazhaganms6015 10 месяцев назад
UPLOAD DAILY VIDEOS BRO
@ErrorMakesClever
@ErrorMakesClever 10 месяцев назад
We will try our best to upload videos daily from today bro :)
@aishwaryaK-hx2ek
@aishwaryaK-hx2ek Месяц назад
Bro pls continue sql series...
@shyamaladevi4799
@shyamaladevi4799 9 месяцев назад
SQL related Next vedio epa poduvinga bro
@gowthamr5676
@gowthamr5676 7 месяцев назад
Bro Continue this SQL series 🎉❤
@goodboys1597
@goodboys1597 Месяц назад
Bro .net video podunga bro
@shivaj7091
@shivaj7091 3 месяца назад
Please continue the session bro, or else pls give following topics
@vaitheeshmurugavel3532
@vaitheeshmurugavel3532 7 месяцев назад
Done bro ❤ continuity podunga
@firstname1206
@firstname1206 6 месяцев назад
Please continue this SQL series
@036-jessyamalranif5
@036-jessyamalranif5 6 месяцев назад
bro i could not find vedios for TCL and DQL.....please update for this bro
@shrisherin2591
@shrisherin2591 10 месяцев назад
Bro two or more table ah merge pandramaari coding pottu explain pannunga
@eswaryeswary1793
@eswaryeswary1793 4 месяца назад
In 17 th question they asked us to group by age bro ,u grouped in by final grade 😮
@Boobalanselvaraj
@Boobalanselvaraj 7 месяцев назад
bro continue the series please...
@CS-RubavathyMR
@CS-RubavathyMR 10 месяцев назад
Bro, please upload some questions to solve and practices
@user-jx5pq8td7y
@user-jx5pq8td7y 5 месяцев назад
bro pls continue this SQL series
@prakash3425
@prakash3425 10 месяцев назад
Java Script video podunga bro
@sudhank6221
@sudhank6221 10 месяцев назад
Bro trigger , foreign key aprm kjm kastam ma problem vennum bro
@DivyaDhinesh-wz3yn
@DivyaDhinesh-wz3yn 6 месяцев назад
Full ah one video va ah podunga Full SQL video podunga Practice questions nu podunga
@krishnavenic7616
@krishnavenic7616 9 месяцев назад
Join and subquery explain pannunga bro please
@kingsgowthas2932
@kingsgowthas2932 6 месяцев назад
Spr❤bro
@nisvannisvanth6646
@nisvannisvanth6646 10 месяцев назад
Waiting for your further videos broo
@SuryaPrakash-cw9wd
@SuryaPrakash-cw9wd 7 месяцев назад
Bro qstn 15 ku Sum find pannanum Not Avg
@shay_talkz
@shay_talkz 6 месяцев назад
Broo intha join innerjoin athella ethula bro iruku
@suganthiganesan7855
@suganthiganesan7855 7 месяцев назад
Waiting for continuation
@thirugnanam9632
@thirugnanam9632 Месяц назад
Bro sql joins poduga bro
@snoopy8245
@snoopy8245 7 месяцев назад
Please do a video on joins in SQL 😢😢😢😢😢😢😢
@karthikvijay5626
@karthikvijay5626 5 месяцев назад
bro for 15 th question you have to find sum of ages with grade A or B but you had find avg of ages ! ...
@AfzalKhan-gf7nm
@AfzalKhan-gf7nm 4 месяца назад
Yeah, I thought the same bro. he had found AVG age but in question, it is mentioned as find the sum of the age
@KishoreKumar-ln8lw
@KishoreKumar-ln8lw 16 дней назад
12:42
@PoojaVijayaraja
@PoojaVijayaraja 2 месяца назад
Bro waiting for primary key and foreign key 😢
Далее
女孩妒忌小丑女? #小丑#shorts
00:34
Просмотров 9 млн
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Просмотров 137 тыс.
Best SQL Mock Interview | SevenMentor Training
5:18
Просмотров 22 тыс.