Master SQL in 6 Hours and Get Ahead of 90% of Oracle Developers!

[@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/I3SxzqfouLF61TGAUQeell 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

[@sowmiyak4008]

Bro ETL Testing and data warehouse videos podunga. Thank you.

[@aktheentertainer883]

Actually I have joined SAP , in that way in my project required oracle knowledge so thats I came to watch your video it's really helpful Sir.

[@karthik1648]

We really appreciate your time and effort sir, thank you so much

[@NICITACADEMY]

It's my pleasure

[@dailyvlogTTokl]

I am an SAP ABAP developer....learning oracle for a purpose....your video helps a lot, each and everything has been explained very clearly..... appreciate your effort...

[@NICITACADEMY]

Glad it was helpful! Keep watching my channel.

[@kalaiselvi952]

Hi sis any job wanted plz

[@joeuniversal5512]

Sap enna subdivision painna solluga I am a clg student

[@rjalloverworld6815]

Sir u r amezing class sir .....I'm quickly understood ... This one videos watch and definitely go IT job sir very thanks sir .... really amezing sir

[@NICITACADEMY]

Thanks and welcome. Keep watching my channel.

[@rjalloverworld6815]

Sir nalla website solunga sir SQL run panna...

[@dhianeshkumar4003]

Hello sir, 1:00:06 instead of taking backup of a table, we can create one duplicate col of the col datatype to be change. After changing the datatype we can assign back the values to original cols and drop the duplicate col ryt!. It's a much precise way!!. Pls crct me if I'm wrong btw. Thanks

[@subramani435]

மிக்க நன்றி ஐயா... தங்களின் பணிக்கு தலைவணங்குகிறேன்.

[@NICITACADEMY]

மிக்க நன்றி சகோதரா. தொடர்ந்து படியுங்கள்.

[@sundeepk4417]

Step by step all the concept explained. Really useful in real time scenario and it helps me a lot. Expecting more videos from different technologies. Kudos for your effort.

[@NICITACADEMY]

Thanks for your feedback, Sure I will do. Keep watching my channel.

[@tradelover7078]

Watched so many videos and find your channel, awesome teaching .. you are the best. Great teaching.. thanks lot

[@NICITACADEMY]

You're very welcome!

[@satheeshguru6080]

Evolo clear ah begin to end super ah cover panerunkenga. Solla varthai illa bro Tamil medium boys/girls ku ethu rompa useful ah erukum nu nan nambaren.. Nandri bro🙏🙏🙏

[@NICITACADEMY]

Thank You very much.

[@caffemilano4168]

Today only I complete the full video. It's really helpful for me. Once again thank you very much...

[@NICITACADEMY]

You are most welcome

[@006pravee]

Very good explanation sir.. very systematic way of teaching.. helped me a lot to start sql from zero level.. Thanks :) Now ll go through your PL SQL videos..

[@NICITACADEMY]

All the best. Keep watching my channel

[@jaiprakash210]

Nice and clear Explanation. You made the SQL course easy sir.

[@NICITACADEMY]

Glad to hear that

[@dayanithicreater2046]

tamil best sql tutorial so far great video in you tube i will definitely recommend this viedo thank you so much sir keep rocking

[@NICITACADEMY]

Thank you so much 🙂

[@vakeeshganeshar9623]

Great Course. I have thoroughly enjoyed this course. I have learned a lot.

[@NICITACADEMY]

Excellent

[@10eharish15]

Excellent teaching sir! I got what I Expected.

[@NICITACADEMY]

Excellent, keep watching my channel.

[@ramaraghavan9765]

A very good tutorial. Real time scenario examples are very useful in understanding. Thanks

[@NICITACADEMY]

Glad it was helpful!

[@மனுநீதிச்சோழன்]

Thanks a lot for this free coaching, keep up the good work!

[@NICITACADEMY]

Thank you.

[@antonyjayaraj95]

I am really thankful for your video. Because i love sql and my working platform is plsql, pro c and sql. After this video utilization, will improve my present skills and inform you a good news soon. Thank you

[@NICITACADEMY]

Sure, I am waiting. You can do it.

[@arulmozhitneb4395]

Sir sql padicha job vacancy iruka freshers ku or addition ah vera ethuvum padikanuma?

[@anandkumar-om5cv]

Thanks a lot Bro.. I'm Functional consultant and this video is very helpful to understand better on the database side... 👌

[@NICITACADEMY]

You are most welcome

[@priyas4673]

How to be ome a functional consultant

[@purushoth5444]

Thank You Sir. Long time waiting for this one. Most welcome plsql videos

[@NICITACADEMY]

Most welcome

[@akashnanaware6427]

6+ hours , i dont know tamil language but i understand technical words so language not big problem for me , but waiting for english version also 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉 Nice video 👍👍

[@NICITACADEMY]

Will upload soon

[@satheeshguru6080]

Thanks for all ur efforts, presentation and way of teaching that pushing me to do something. Once again Thanks. I understood all the concepts because of u. 🙏🙏🙏

[@NICITACADEMY]

You're very welcome! Keep watching my channel. I will upload more videos.

[@antonyjayaraj95]

எனக்கு பிடித்துள்ளது. நன்றி.

[@NICITACADEMY]

Thank You

[@wincywincy9136]

Sir you are really amazing thank you for helping us through youtube .

[@NICITACADEMY]

Thanks

[@prakashk9948]

Whenever I have some doubts in SQL I will watch this video 🥰 You r really awesome Sir 👌😍

[@NICITACADEMY]

Glad to hear that, Keep watching my channel.

[@sivaprasanth4790]

Bro.. Version 10g use pannalaamaa bro .. thericha sluga

[@supriyasam1875]

Thank you so much sir!. This is really helpful... And able to learn easily

[@NICITACADEMY]

You are most welcome

[@nagarajannagarajan2698]

dear sir thanks a lot for your video its helps me more and so many sql concepts now clear. I appreciate your way of explanation and hard work put for your video. 💝

[@NICITACADEMY]

You are most welcome. Keep watching my channel.

[@sivap5241]

It is very useful for all.and thanks for your great effort sir.

[@NICITACADEMY]

You are most welcome

[@purushoth5444]

Sir, Your sql notes very use full. Nega indha maari plsql video poduga sir most of waiting

[@NICITACADEMY]

Okay, allow me some time ..

[@agilaelumalai6069]

Awesome tutorial for beginners 🥰, excellent teaching, by this i can learn very easy,

[@NICITACADEMY]

Thanks, Keep watching my channel.

[@endrumenedhu9153]

Sir,Really i'm impressed a lot by the way u teach ... Thank u sir.

[@NICITACADEMY]

Thanks and welcome

[@hussanara4415]

super na , theliva irukku....👍👍👍👍👍

[@hussanara4415]

me also waiting for PL sql video sir

[@NICITACADEMY]

Sure, I will add soon.

[@thamud6713]

Great Efforts Sir Really Useful Thanks ❤

[@NICITACADEMY]

Most welcome

[@viswal5266]

i learned SQL in single day because of your video. thank you

[@NICITACADEMY]

Great to hear!

[@Max_gow]

🙄 is it possible?? 🤔

[@anaithaiumarivom]

@@viswal5266 uruttu

[@ranjithrazz26]

Thank you sir🙏🙏 very very useful video 💗💗💗💗💗

[@NICITACADEMY]

Keep watching

[@manandan9853]

brother.. really your presentation will be helpful for me i guess. thank u.

[@NICITACADEMY]

You are most welcome

[@038_inbasakaranmeenakshi6]

best channel to learn about database.sir your informatica videos are really awesome

[@NICITACADEMY]

Thanks a ton

[@SriRam-nc4ed]

This is very useful video for all students including Me ❤❤

[@NICITACADEMY]

Glad to hear that

[@rajeeshts985]

GREAT VIDEO BRO, LEARNED A LOT THINGS

[@NICITACADEMY]

Glad you enjoyed it. Keep watching my channel.

[@vinovino7582]

But wonderful video sir Hatts of to you sir

[@NICITACADEMY]

Thanks a lot

[@vijaymani3999]

Super clean explaination sir Great

[@NICITACADEMY]

Thank you, Keep watching

[@thangaduraimanoharan243]

Vera level sir, great🙏🙏💯, thank you sir.

[@NICITACADEMY]

Welcome 👍

[@mahalakshmi-wi4br]

Good job and thank you so much ...pls keep posting for plsql as well👍

[@NICITACADEMY]

Thank you, I will

[@prathoshs8756]

Thank you soo much 🙏🙏🙏🙏🙏🙏🙏🙏🙏 very helpful 💖💖💖

[@NICITACADEMY]

Thanks

[@velmurali1606]

Thank you very much for your time and effects sir.😊

[@NICITACADEMY]

Welcome, I put lot of effort to create this video, Kindly watch fully. if you have any queries add in comments, I will respond. Keep watching.

[@velmurali1606]

@@NICITACADEMY yeah sure.

[@ramrk122]

Thank you so much sir it's really helpful 🤝🏻💐

[@NICITACADEMY]

Most welcome

[@vigneshvarma8911]

Thanks for your great effort sir.. Also request you to do full session in PLSQL which is more useful for us.

[@NICITACADEMY]

Sure I will

[@happylife1711]

Nice video sir.. Love from kerala

[@NICITACADEMY]

Thanks

[@happylife1711]

@@NICITACADEMY can you make tutorials of database administration

[@serialpromos.6268]

Thanks sir,Pls more video podunga

[@NICITACADEMY]

Sure 👍

[@Introvert_Explorer791]

Ivalothan iruka sql la oracle mysql ena doffernece iruku

[@kuzhal1411]

Thanks for your effort .

[@NICITACADEMY]

Welcome. Keep watching.

[@krishnanselvam786]

Thank you so so so so much sir.......😊

[@NICITACADEMY]

Most welcome

[@adithyathangavel2439]

how to find the primary key costraints in sql plus ?you have used owner = hr,it refers to what sir ?

[@NICITACADEMY]

HR is the schema name. Refer all_constraints table for constraints.

[@balajilb1348]

Thank you so much sir!!!

[@NICITACADEMY]

Most welcome!

[@nagarajannagarajan2698]

select substr('welcome to bangalur itpl',instr('welcome to bangalur itpl',lower('B'),1),8) from dual for bangalur

[@NICITACADEMY]

Keep up your good work

[@ranjithrock4561]

Thank you sir ur class useful ❤️

[@NICITACADEMY]

Always welcome

[@seuzzbgm8221]

Vaaa thalaivaaa.....🥰🥰🥰🥰

[@MotivationToMoveForward]

Hello Sir, Thank you so much for your detailed video, with help of this I have cracked the Infosys Interview at the first attempt. Only because of your detailed I was able to answer most of the questions which was asked with me. Your explanations are awesome. Thanks will not enough for you for these efforts 😊😊😊

[@NICITACADEMY]

You are most welcome. I am happy that the session is more useful for those job aspirant. Keep learning.

[@anandhaselvam4765]

Bro intha 6:00 hour videos patha job la sethuralama

[@satheeshguru6080]

Bro vera level teaching

[@NICITACADEMY]

Thank you very much.

[@nsmedia8508]

Very useful one I request to DBA videos

[@NICITACADEMY]

Thanks and sure

[@manivannanp7892]

Great sir...

[@rajeshveerarajan6521]

Thanks for the wonderful video sir , I have one doubt. In duration 1hr:40 minutes, you have used a & b parameters for join two table to look up the constraints, can you please explain why have you used a b?

[@Mahadev-jb8yf]

Anna is this wholesome sql video for informatica😃🙌 may i know pls ?....

[@NICITACADEMY]

Yes definitely it is more than enough. Kindly practice and share your comments.

[@Mahadev-jb8yf]

@@NICITACADEMY nuvvu devudu swamy🙏🙂

[@Deepikamanoharan-x5h]

Thank you sir!

[@NICITACADEMY]

You are welcome!

[@fathimasafrinb5921]

Thank you so much for this video. This gives a lot of clarity in Basics. Could you give a differentiation between rownum and row_number ? When are we using these in real time ?

[@NICITACADEMY]

Both are to identify the records, watch my analytical functions video.

[@g.keerthivarshaan7307]

Very useful sir

[@NICITACADEMY]

Thanks and welcome

[@prasadmanikala1868]

@@NICITACADEMY please provide English

[@NICITACADEMY]

I am creating in English, I will post soon.

[@rkfacts4891]

Super explanation sir.

[@NICITACADEMY]

Thanks and welcome

[@nagarajannagarajan2698]

select substr('WELCOME to chennai chropet',instr('WELCOME to chennai chropet','c',2),7) from dual; for chennai

[@NICITACADEMY]

I appreciate it.

[@poojalijo6087]

Questions from inserting values in city table After alter the primary key for city table we cannot insert the values in the city table because it doesn't allow any duplicate? What to do ?

[@Vigneshdba]

Sir table can be brought back after using ddl drop if we use flashback eg :flashback table tablename to before drop;

[@NICITACADEMY]

Yes, you can. But you have to use before dropping the table. Keep watching my channel.

[@mugunthan4152]

Sir please give me the Oracle 11g installation video where is it. I couldn't find in the description.

[@NICITACADEMY]

kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@karthikeyansrg2370]

Wow super teaching! But, How to install Oracle software; I found internet, installation I don't know.. tools; taps; menu; shortcuts; etc. Please explain! Pervious If you video post please link comments

[@NICITACADEMY]

Please check the SQL playlist in my channel, I have posted all the videos and installation.

[@balajireddy9640]

please share the degree educational background sir

[@joelanto8486]

Hi Sir. Is there a separate video for the connection details. I am not sure how to connect. Please help here.

[@NICITACADEMY]

Please watch my Oracle Installation video.

[@IndhuMathi313]

Can we use double INSTR in one query sir..?

[@ezhamthendral6633]

I couldn’t see any constraint detail in my all_constraints table. Given correct owner too. Please help me sir. If I insert any duplication am getting that mean I created primary key in city_id Column in city table.

[@sukumarkothapally7796]

Hi sir, need your help regarding ORA-12516,TNS:Listener does not currently know of service requested in connect descriptor ,how to resolve this error

[@RemingtonBrucee]

Sir really superb and thanks for detailed explanation 👌👌👏then please provide a notepad link for practical purpose..

[@NICITACADEMY]

Check description

[@karpagambigaipalaniswamy5291]

Thanks for your effort. I am right now in Manual testing. What can be my next job when I learn Oracle - SQL? desperate to move out from Manual testing

[@NICITACADEMY]

You can learn SQL and Informatica, move to ETL testing or ETL developer

[@karpagambigaipalaniswamy5291]

@@NICITACADEMY Thank you so much for showing a path

[@dheebuammu5948]

Hi sir, metadata_how to do json data convert to Normalized tables

[@DHANUSHM4422]

where can i avail the query and notes matterial ...so that i can practice that

[@NICITACADEMY]

Please check the description, I have updated the link.

[@saravanakugankugan6597]

Bro oru curior service data base created pannum epadi seiradhu

[@SaravananSrinivasan-py5yp]

select a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name from all_constraints a , all_cons_columns b where a.constraint_name=b.constraint_name and a.owner='HR' and a.table_name='CUSTOMER'; while running this, its showing nothing in my system

[@kasthurisktvl9747]

Can you please help me to get a single row function exercise table (employee).

[@NICITACADEMY]

Install Oracle 21C or 11g by watching my installation video.

[@caffemilano4168]

Thank you very much sir....

[@NICITACADEMY]

Most welcome

[@parvathamvarthini9886]

It's very very useful video and very good explanation.can we get this tutorial pdf format?

[@NICITACADEMY]

Please Check description

[@littlesuren6877]

Sir.... primary key la duplicates values ah add panna mudiyumaa sir ?

[@NICITACADEMY]

No we can't. That is what Primary key. Please watch my session fully. I have explained. Happy learning.

[@omprakash-r7k]

Dheivamae Nandri

[@NICITACADEMY]

Mikka nandri, Keep watching my channel.

[@virjinsethu6894]

Tq for your precious tym

[@NICITACADEMY]

😊 Thanks, Keep watching

[@meenakshijaiganesh8116]

Very Good

[@NICITACADEMY]

Thank you! Cheers!

[@g.keerthivarshaan7307]

Thank you sir

[@NICITACADEMY]

Welcome

[@AjayKumar-pw9xy]

Software engineer aaguradhuku python course padika sonnaga. And adhu kooda SQL padika sonnaga... Ippo neenga sollithara SQL padicha podhuma sir??? Indha video la complete course cover pannirkingala????

[@NICITACADEMY]

yeah, please complete this full video and practice, go for advanced topics and apply for SQL developer role.

[@AjayKumar-pw9xy]

@@NICITACADEMY ok sir👍

[@kkarthik5614]

Hi Sir, select a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name from all_constraints a , all_cons_columns b where a.constraint_name=b.constraint_name and a.owner='HR' and a.table_name='CUSTOMER'; when i use the above code, the output is empty . there is no results displayed in output

[@NICITACADEMY]

Few Questions 1. Do you have CUSTOMER table in HR schema? 2. Run in the query in HR schema

[@gajendiranm4450]

Thank you so much ❤ sir

[@NICITACADEMY]

Most welcome

[@gajendiranm4450]

👍🤝🤝​@@NICITACADEMY

[@kasthurisktvl9747]

Hi sir thanks for your video....I can't find all constraints tables I have followed your steps but I can't find the system constant tables. Please replay.

[@NICITACADEMY]

Check in which user you are running the query.

[@kasthurisktvl9747]

@@NICITACADEMY ok thank you for sharing your support. ☺️

[@thanaarasuraj7428]

Hi sir, 1st of all thank you for making this video. Im from non-it , i plan to switch career. So Sql la start panndren...unga 6.5hurs video crystal clear ah tutorial panni irukeenga.. one quest. Intha 6hours video is enough or anyother concepts neenga SQL la leave pannitengala? 2nd quest. Next to this 6.5hurs tutorial vera enna padikanu, skills, tools and concepts . if possible guide me steps sir Thank you

[@KruizArsKronikles]

Good question. Please reply sir

[@gokulnath589]

Plse replay sir

[@premkumar-x7c]

@NIC IT ACADEMY Hii bro oracle 11g instal pandrathukku link kuduthutukken sonninga description la.illiye bro

[@NICITACADEMY]

kzbin.info/www/bejne/gKPIl55nnbR9h8k Let me check and add it

[@vigneshm7930]

What is the answer to extract city in 2:46:07

[@NICITACADEMY]

please practice the substr and instr and you can able to do.

[@karthikeyansrg2370]

ORA-01950: no privileges on tablespace 'USERS'-------values add pana ethu mathiri show akuthu sir

[@NICITACADEMY]

are you trying in SYSTEM schema?

[@karthikeyansrg2370]

@@NICITACADEMY no sir i try hr and core schema