Day 2 - SQL in TAMIL | Oracle SQL tutorial in TAMIL | SQL tutorial for beginners in Tamil

[@NICITACADEMY]

Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

[@kirubababu9255]

Thanks

[@NICITACADEMY]

Welcome. Thanks Kiruba for your Thanks. Keep watching my channel.

[@ManikandanRaju]

Lucky that I found your videos sir. Very easy to understand. Clear and crisp explanation. I love the way to teach. You keep reminding us about the check points to keep in mind. Most teaching professionals would not do that. Great work sir. Thank you so much for this playlist. I am from a non-IT background. I am searching for a job as a Data Analyst. This will help me a lot through my learning journey. Thank you once again.

[@NICITACADEMY]

Thanks and welcome. Continue to complete all the SQL videos and start learning Informatica, It will take you for the next career path. Keep learning.

[@ManikandanRaju]

@@NICITACADEMY Thank you sir. Yes I am planning to complete the complete SQL playlist as soon as possible. Also thank you for the suggestion sir.

[@AbdulRahman-uh3jr]

very clear explantion sir good sir keep it up sir . your very easy to way of teach.

[@NICITACADEMY]

Thanks

[@sriramanbazhagan4394]

well explained sir.. Thank you so much.. Please keep uploading videos.. waiting for your updated videos

[@NICITACADEMY]

Thank you, I will

[@superblife7196]

No way sir unga Madiri no one teach. Simply superb and it should be go on.👍

[@NICITACADEMY]

Thanks. Keep watching.

[@Hasanmd-kf9yk]

Excellent, very interesting. Keepit up sir.ur Every word is examination and interview pointofview nice.

[@NICITACADEMY]

Many many thanks

[@seuzzbgm8221]

Broo rmbhaa superaa puriyuthu broo...konjaa SQL developer fresher oda resume epdii irkaanuu slii oru video podungaa broo

[@rameshbabu-yk4qr]

Well explained sir!! Please keep posting videos it really helpful for us.

[@NICITACADEMY]

Thank you, I will

[@vettypasaga7678]

nalla understand aaguthu bro, continue it bro

[@NICITACADEMY]

Sure, Please like the video and keep watching other videos

[@meetmrbrucekadin-dogoargen2655]

Keep rocking this is very useful

[@NICITACADEMY]

Thanks a lot

[@yazhb4403]

Very well explained sir.. Thank you so much.. Please keep uploading videos.. Great effort sir👍

[@NICITACADEMY]

Keep watching. Thank You.

[@manivannanp7892]

well explained.. keep rocking... it is very useful..

[@NICITACADEMY]

Thanks a lot

[@Ashwins_Vlog]

Superb..... Explanation.... Great Job....

[@NICITACADEMY]

Thanks a lot

[@kdakash2451]

thank you sir ... really understood #assignment did using mysql database drop table product; create table product ( prod_id varchar(50), prod_name char(50), manu_name date, company_name char(50), unit_price int not null, category_name char(50) ); insert into product values('E10','redmi','2000-04-01','xiomi',10000,'note 10'); select * from product; alter table product add external_storage int; desc product; alter table product drop column company_name; desc product; alter table product modify prod_name char(100); desc product; alter table product rename to product_table; select * from product_table; alter table product_table rename column unit_price to product_price; desc product_table;

[@krishnanselvam786]

PL/SQL program #anonnymous black full topic #trigger full topic #curser full topic #stored procedure full topic #functions full topic #packags full topic video post pannunga sir.

[@krishnanselvam786]

Thank you very very much.

[@NICITACADEMY]

You are welcome!

[@karthickpeceee]

Sir is there any mobile sites to workout oracle ? Because i dont have a laptop.

[@NICITACADEMY]

livesql.oracle.com/apex/f?p=590:1000

[@ebin44]

Good initiative bro.

[@NICITACADEMY]

Thanks a ton

[@sanjeevehandpicks]

42:41 How to change the length of PRODID Column. Could any one help me please

[@Fathima-i4z]

WOW..WELL EXPLAINED SIR

[@NICITACADEMY]

Thanks and welcome. Keep watching.

[@priya6096]

Very good and clear cut explanation sir....tqsm 👌 👍....plz upload java collection framework sir🙏🙏

[@NICITACADEMY]

Thanks for your feedback, but I do not have much experience in Java. I will upload more Oracle and ETL videos.

[@priya6096]

@@NICITACADEMY kk sir kk🤗🤗

[@user-uo2mm7eb2t]

Sir have one doubt.VARCHAR2(3 CHAR)-this means what sir.can u please explain this when u free. when i create the table and given the datatype sql its showing in drop down.

[@NICITACADEMY]

It means varchar2(3)

[@user-uo2mm7eb2t]

@@NICITACADEMY thank 🙏 you sir.

[@sumaiyabegum8631]

If I want to change the column name with out mention the table it is possible

[@krishnanselvam786]

Could you post video SQL and plsql program video perday two videos podunga sir.

[@monsoorali5265]

hello sir , table product created but query results not showing sir can u pls tell me where is icon of query results?

[@NICITACADEMY]

Enable to query result windows in view.

[@monsoorali5265]

@@NICITACADEMY sir cant get it.

[@rockyrajan312]

Plsql developer and production support video poduga

[@SatishMeda-dc8vx]

1.ithu oru Fron-end App-la order complete aanathu. atha customer-la manula delete panna mudiyala athai nan 'Database'-la delete pannanum. 2.எனக்கு ஒரு table-ல particular old column-அ delete பண்ண சொல்லறாங்க அப்ப column-மட்டும் delete-ஆகுமா இல்ல அந்த column-த்தோட தொடர்புடைய எல்லா row-வும் delete ஆகுமா . 3.அப்படி delete பண்ணனும்னா எப்படி query use பண்றது plz update . 4.I mean oru 100 old ID-nu solranga particulara athai mattum epadi delete panrathu.

[@superblife7196]

Rollback to b means b Ku next record la irundu last record Vara rollback aguma

[@NICITACADEMY]

up to 'B' it will be rolled back, just do practice, you will come to know.

[@LK-qc5bs]

Really useful. Are you providing training session. I am interested to join

[@NICITACADEMY]

Hi, Thanks. Yes, Please contact @[e-mail]. I am handling it. Keep watching my channel.

[@theniniyan8608]

ORA-01950: no privileges on tablespace 'USERS' error keeping show bro how to solve

[@NICITACADEMY]

Please watch my Oracle 21C installation video. You can install without issues.

[@mdaashiq6206]

I need to learn plsql...This oracle sql and plsql are same ??

[@NICITACADEMY]

Plsql will have Procedural language, SP, Function, package, trigger, collections, cursor, etc.. SQL is base for all.

[@mdaashiq6206]

@@NICITACADEMY thank u sir..

[@mdaashiq6206]

@@NICITACADEMY Can I go for Oracle sql..is this related to plsql

[@NICITACADEMY]

Yeah, First learn SQL and Practice more, then go for PLSQL... watch my channel, SQL in 6 hours, that is more than enough. Keep watching.

[@krishnanselvam786]

Could you explaine CONDITIONAL EXPREESSION(CASE,DECASE)

[@NICITACADEMY]

Sure I will post. Keep watching my channel

[@krishnanselvam786]

@@NICITACADEMY thank you sir.

[@Pearl-ks2pm]

Tq so much

[@NICITACADEMY]

Welcome 😊

[@kadambari9560]

Great

[@saranyajs4253]

Sir all the topics are well explained but can you please tell about the difference between truncate and drop function because both are DDL statement and both will delete the table and cannot rollback then why it has both name?

[@NICITACADEMY]

Thanks, I have posted the video already on this topic. Kindly check in SQL Playlist.

[@sheenarassika1243]

Truncate is a DDL command whereas Delete is a DML command Similarly , truncate will delete entire data in the table whereas delete command can Delete entire data as well as partial data using Where clause In Truncate rollback can't be achieved whereas in Delete we can rollback

[@ManikandanRaju]

Truncate will not delete the column names. It is like having a blue print of the table with no data in it. Drop will delete the whole table. After Truncate, you can still view the table. But no data will be there. After Drop, you cannot view the table. It will be gone forever.

[@superblife7196]

Sir SQL + plsql rendume kandippa learn pannanuma Ila SQL full ah terinjale job Ku ok va

[@NICITACADEMY]

Only SQL also fine but you need to be very very strong. PLSQL we can learn quickly if you know SQL very well.

[@superblife7196]

Tanks a lot sir

[@gowthams.v6004]

Sir would like to join a course for informatica etl do you take sessions if so kindly let me know about the payment details and the time slot .

[@NICITACADEMY]

Yes, sure. Please contact @[e-mail]

[@krishnanselvam786]

Why did not still come yesterday video sir.

[@superblife7196]

Commands run panraduku shortcut solunga sir

[@NICITACADEMY]

Ctrl+enter

[@dhaveethuabraham3880]

Sir Got an error while insert into datas like product_Id,name,etc..,( Error starting at line : 17 in command - insert into Product (Product_Id,Product_Name,Manu_Date,company_name,unit_Price,Category_Name) Values(37001,'Bingo',to_date('01/20/2024','mm/dd/yyyy'),'ITC',1752,'Snacks') Error report - ORA-01950: no privileges on tablespace 'USERS') Kindly do the needful

[@balamuhi1652]

Exhalent sir

[@crajeshkumarmcabed2625]

No explain for Merge cammand

[@NICITACADEMY]

I will post separate video for Merge. Keep watching.

[@shamyumanoharan7217]

Datastage videos podunga

[@NICITACADEMY]

Sorry DataStage I do not have experience. I will try my level best. Keep watching my channel.

[@Phoenix-wd2qw]

ORA-12988: cannot drop column from table owned by SYS 12988. 00000 - "cannot drop column from table owned by SYS" *Cause: An attempt was made to drop a column from a system table. *Action: This action is not allowed Please advise.

[@NICITACADEMY]

why you want to drop system tables?

[@Phoenix-wd2qw]

I am working as sys@xe is that wrong

[@SasiKumar1211]

Hi, can we get whatsapp group link. Link in description is not working.

[@NICITACADEMY]

I will check and update

[@mdaashiq6206]

I need to learn plsql...This oracle sql and plsql are same ??