Master Oracle SQL in 2025 with Top Expert Techniques

[@NICITACADEMY]

*Complete PLSQL/Informatica/IICS 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 or career guidance. 🌕 [phone] or WhatsApp 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy (Since 2014) - A decade of training excellence.

[@kiranm99]

first link is not opening

[@NICITACADEMY]

Please check now

[@harireddy4219]

I want to install Oracle 11g -XE in Mac how to install can you please help me sir @NIC IT ACADEMY

[@RandhirRai-pw5og]

@@NICITACADEMY duration of plsql paid course

[@vakatisatishkumar2840]

I have one doubt, Already you are realsing vedios on PL/SQL in KZbin, May i know what is the difference between PL/SQL Self placed course and your youtube vedios on PL/SQL 😌

[@mohamedharish9111]

Thanks for your teaching and uploading the un-paid course on this channel.

[@NICITACADEMY]

You're very welcome!

[@Ritik_Dhawale]

best Video i ever watch on youtube for SQL, best video loved it,Thank you Sir

[@NICITACADEMY]

You are most welcome

[@Ritik_Dhawale]

@@NICITACADEMY sir i have one doubt,While creating an backup table the constraints are not copying , can i solution for this

[@punk77777]

Awesome Course Must watch for the intermediate level also.

[@NICITACADEMY]

Excellent

[@mohammadshaik7053]

Sir this crash course is awesome Thanks for your efforts...

[@NICITACADEMY]

Thank you, Keep watching my channel. Please watch fully and practice.

[@sherwinmiranda8772]

Great initiative sir was intact💯💯

[@NICITACADEMY]

I really appreciate your kind words! It means a lot to me to have such supportive viewers.

[@mahendranath2504]

Thank you so much for the amazing content, like the content

[@NICITACADEMY]

Glad you enjoy it! Keep watching my channel.

[@Int_stories-co6sy]

Thank you so muchh for this amazing class, it was necessary for me thank you

[@NICITACADEMY]

Glad it was helpful! Keep watching my channel.

[@tejayadavalli1049]

Thank you for your great lectures.

[@NICITACADEMY]

You are welcome!

[@adnan_asaad]

I really appreciate your efforts , special thanks from SYRIA

[@NICITACADEMY]

Thank you.

[@PriyankaKohineni]

This video helped me to crack the Accenture interview. Excellent content. Thanks for your time.

[@NICITACADEMY]

You are most welcome; glad to hear this.

[@GovernmentRecruitementUpda-k3w]

you mean bangaluru accenture

[@luiscrespol8640]

Good Job. Thanks for sharing. Greetings from Mexico City!

[@NICITACADEMY]

Welcome & Thank you too! Keep watching my channel.

[@KaleemKhan-cc4ex]

Excellent video. Thanks

[@NICITACADEMY]

You are welcome! Keep watching my channel.

[@gloums]

I love you! Thanks for all the free information!

[@NICITACADEMY]

You are so welcome!

[@nhinvalerabayugao1418]

an amazing and simple way of teaching. More Power to you Sir ...

[@NICITACADEMY]

Thanks a ton

[@Rsg2820]

Tysm air for this valuable course. 🙏 Kindly please make same long video or course for PLSQL. It will help us alot.plz 🙏 ASAP

[@NICITACADEMY]

Thanks courses.nicitacademy.com/

[@MadhanKumar-uf5vq]

Very good video bro. Thanks for your efforts.

[@NICITACADEMY]

Thanks and welcome

[@someswarak7210]

It is helped me lot sir. with real time examples...... Thank you so much sir

[@NICITACADEMY]

You are most welcome

[@vandanapatil8182]

Sir please make same kind of video or complete blast course on EXCEL, POWER BI, PYTHON (DATA ANALYTICS) 😊

[@NICITACADEMY]

Sure, I will do

[@KBK23]

Thank you very much Sir. Please keep making such videos 🙏

[@NICITACADEMY]

Sure 👍Thanks, Keep watching my channel.

[@manooj8502]

lot of love sir perfect time you drop the golden gems 💎 ❤❤❤❤

[@NICITACADEMY]

Thank you. Keep watching fully.

[@manooj8502]

@@NICITACADEMY lot of love sir i will be sharing this video to my all friend too .Can you please bring video on normalization tooo i have been struggling normalization . Your way of teaching is very great and helpful

[@NICITACADEMY]

Hi Manooj, Thanks, Please share it your friends group. I will upload normalization and RDBMS basic concepts as well. Thanks, Keep watching my channel.

[@SaiKiran-zw8mp]

Awesome explanation sir

[@NICITACADEMY]

Thanks and welcome. Keep watching my channel.

[@monalisa6758]

Excellent explanation.

[@NICITACADEMY]

I'm glad you found it helpful! Keep watching my channel. Importantly, please practice all the queries that I have given.

[@srinivasmarampudi]

This 12 hr videos enough for to start the data engineer

[@ahungrymann]

This is amazing content but you need to slow down a little bit. Thank you

[@NICITACADEMY]

Noted! Thanks for your feedback. Keep watching my channel.

[@Venugopal-br9tz]

Sir, thank you for your efforts.

[@NICITACADEMY]

It's my pleasure

[@pra1bhus1]

Sir, If possible please upload complete PL/SQL tutorial. Thanks for sharing this tutorial.

[@NICITACADEMY]

Please check here courses.nicitacademy.com/courses

[@NisarAhmed-ut3is]

@@NICITACADEMY link is not working sir

[@Tadapatiatma]

Is oracle free to install for study

[@mahapatra_suvamay]

@@NICITACADEMY sir , link was not working...404 not found error message showing... Please upload videos on PL/SQL

[@Sjjsjam]

​@@NICITACADEMYlink not working

[@vinaypatil8009]

Sir please start Data Analyst playlist from beginner level to advanced level with industry level projects Make us job ready through that Data Analyst playlist sir 😊

[@NICITACADEMY]

Sure I will, Keep watching my channel.

[@Voice_of_Emotion]

Excellent 👌👍..

[@NICITACADEMY]

Thanks a lot 😊 Keep watching my channel. Please refer to your friends.

[@Akshay-dg8cv]

Excellent

[@NICITACADEMY]

I really appreciate your kind words! Keep watching the videos!

[@santoshkiran5858]

Thanks A Lot n Lot's 🤝🤝🤝

[@NICITACADEMY]

Thank you too. Keep watching my channel and refer to your friends. you can check other courses here. courses.nicitacademy.com/courses

[@sandhyarani3096]

Hi Sir I am fallowing your vedios in Informatica since long back and I got job in Singapore Now I am working in Singapore But actually I need to improve more to be strong technically in Informatica , PL/Sql and UNIX Please suggest me

[@NICITACADEMY]

Congratulations, Please check here courses.nicitacademy.com/

[@shaiktabrezahmed209]

Awsm tutorial..

[@NICITACADEMY]

Thank you! Cheers!

[@jibinjeevanvp2954]

Please provide the timestamps, if possible. It would be helpful to go to a particular session

[@NICITACADEMY]

I already added the chapters. I will add more timestamp.

[@vakatisatishkumar2840]

Hi SIr, May i know the WITH clause topic in which session, i didn't find anywhere

[@NICITACADEMY]

Will upload soon

[@vakatisatishkumar2840]

Can you please provide the transaction table for Analytical Function session, As i checked in the notes its missing

[@NICITACADEMY]

nicitacademy.com/interview-questions/

[@iddibaruani5615]

thanks sir

[@NICITACADEMY]

Most welcome

[@hariprasad8080]

Hi sir what is the difference between Master oracle sql in 2025 video, and oracle sql for beginners. One is 12hours and other is 7 hours. Which should we watch inorder to get well versed in sql? Kindly reply soon sir I should start studying

[@NICITACADEMY]

In the 12-hour video, I added more days of sessions. Now, I am uploading the latest videos. However, everything is the same concept.

[@hariprasad8080]

@NICITACADEMY There are so many SQL videos of yours. Can you suggest me one so that I can gothrough it? I'm preparing for an interview sir that's why! Please reply asap sir so that I can start early

[@NICITACADEMY]

You can follow this video itself, I have clearly given the topics. Happy learning :)

[@hariprasad8080]

@@NICITACADEMY Thank you sir!

[@Manojkumarprathima]

can you please make a video regarding joins with real time project scenarios?

[@DigitalTrendzy2023]

0:35 LIST OF TOPICS

[@jerrygeorgejoshi8009]

Where is the practice questions u mentioned?

[@Satish-c8j6s]

Hi Sir. Is this the complete course of Oracle SQL or just a brief of each topic?. Please help me.

[@soumitroksharkar1434]

start from 10:29:00

[@nikhilb-s5k]

awesome

[@NICITACADEMY]

I really appreciate your support! It means a lot to me that you found the video helpful!

[@nxashraf7266]

Finally 🎉

[@NICITACADEMY]

Thanks

[@srinivasreddy8532]

Sir please provide informatica complete tutorial

[@NICITACADEMY]

courses.nicitacademy.com/

[@suhasmvsd7854]

Is , this Course covers complete basic to advanced topics ?

[@NICITACADEMY]

Basic to advanced level.

[@suhasmvsd7854]

Ok Sir

[@sagargaud8460]

Sir in join u didn't talk about foreign key and primary key while create table for joins

[@NICITACADEMY]

For joins, the keys(Data integrity) are not mandatory.

[@gokulakrishnansugumaran6728]

Hi Team, Can you guide me to install sql oracle database 12c on windows 11 os

[@NICITACADEMY]

Please follow the same process. This is Oracle 21C installation video kzbin.info/www/bejne/roG2k6uogspqjLc

[@Int_stories-co6sy]

sir, when will upload pl/sql video on youtube???

[@NICITACADEMY]

Please check here courses.nicitacademy.com/

[@c0deA6hi]

1:42:00

[@ruhiscorner7318]

Sir, can two schemas have same tables or tables with same names?

[@NICITACADEMY]

Yes, we can have.

[@GokulS-g5q]

this course is for tester or Developer?. For Tester is this course is benefits?

[@NICITACADEMY]

SQL is a mandatory skill set for most roles in development and testing.

[@c0deA6hi]

1:11:42

[@RAVINDERSINGH-ht6pl]

In DBMS I read schema is a collection of various objects and is implemented differently by different database vendors in different way. In Oracle schema is implemented using user and in mysql and MSSql implemented with the name Database. Does Schema is just a theoretical concept and have various implementation if yes then is there any significance of referring it Schema.

[@vakatisatishkumar2840]

Hi Sir, Rank function in which class it is available i didn't find anywhere

[@NICITACADEMY]

You can find the Rank function in the Analytical function session of the course.

[@vakatisatishkumar2840]

@@NICITACADEMY Thanks

[@krishnavenipanguluri6253]

Hi sir please share complete plsql course

[@NICITACADEMY]

Sure I will courses.nicitacademy.com/

[@SrinivasaReddy-tx2hz]

Hi Chandra, Thanks for the Videos but I can't able to download the Notes, pls place old notes for download.

[@NICITACADEMY]

nicitacademy.com/materials/oracle-sql/

[@GokulS-g5q]

select * from all_constraints where owner='hr' and table_name='pixel'; values is not displayed in output, only column name is displayed, what need to do on this bro?

[@NICITACADEMY]

In Oracle, data are case sensitive, I explained the same in the session, please watch the session fully. you need to use table_name and schema name in upper case or you need to use funtion lower or upper.

[@88888jadejaguars]

Could you please share the link for correlated sub query and cte

[@NICITACADEMY]

kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF

[@Alekhya_Arts]

While connecting to hr db Password given is incorrect. And also account was locked.

[@civilengineer7004]

where i can find the insert data of employees table?

[@NICITACADEMY]

Please install Oracle 11g. I have explained how to install Oracle 11g.

[@subhashini25b]

Is default a constraint or not? Please let me know

[@NICITACADEMY]

Yes, it is a constraint in Oracle

[@SudharaniRajasekar]

sir, please upload snoflake tutorial playlist .

[@NICITACADEMY]

Sure I will do later.

[@Deepikays-d2k]

Hi Sir need Notes for this course how can we get it? the link you shown us is not working and it says the file is not there.

[@NICITACADEMY]

I am updating the notes on our website, Please check nicitacademy.com/

[@c.raxmancabdixayi5393]

Can i take this course, if I'm beginner for oracle?

[@NICITACADEMY]

Yes definitory, I have explained from scratch. You can check our other courses here. courses.nicitacademy.com/courses

[@elishafacts5854]

Sir if possible please upload python full course

[@styling-naaz]

Hello sir isthis content enough to data analytics job or need to take paid course plz tell

[@krishnendufouzder6936]

share the table data from excel its not in description

[@NICITACADEMY]

kzbin.info/www/bejne/roG2k6uogspqjLc

[@Syed_ali_Haider2]

sir please provide document and notes it is not available

[@NICITACADEMY]

Available here: nicitacademy.com/interview-questions/

[@Deepikays-d2k]

Can you please help me with the notes for the classes

[@NICITACADEMY]

I am updating the notes on our website, Please check nicitacademy.com/

[@freeusertwo]

Wonderful!

[@NICITACADEMY]

Many thanks!

[@sp7778]

What type of jobs can we find through Oracle SQL.....

[@NICITACADEMY]

For most of the technologies, SQL is basics.

[@vakatisatishkumar2840]

What is the query for this --DISPLAY EMPLOYEES WHO SALARY IS MORE THAN AVERAGE SAL OF DEPARTMENT

[@NICITACADEMY]

SELECT name, department_id, salary FROM employees e WHERE salary > (select avg(salary) from employees e2 where e2.department_id = e.department_id);

[@vakatisatishkumar2840]

@@NICITACADEMY Thanks for the update, It is Correlated Subquery right Sir

[@StudyStuff-pk7gv]

please tell the name of the background music used in the beginning of this video..its very pleasant to hear

[@StudyStuff-pk7gv]

Will there be any problem, if I use the latest version of Oracle, which is 21c, instead of 11g ?

[@AngadishaikAbdulla]

hi sir, DISPLAY EMPLOYEES WHO SALARY IS MORE THAN AVERAGE SAL OF DEPARTMENT ? i want query for this

[@Sgiri-dq6tg]

please upload PLSQL full course

[@NICITACADEMY]

Please check here courses.nicitacademy.com/courses

[@muralivarmamantena6899]

Informatica -project video and Informatica projects -Join what is the difference

[@NICITACADEMY]

courses.nicitacademy.com/

[@krishnasri7719]

Where are the pratice questions ??

[@NICITACADEMY]

check in the description and watch full video.

[@mohd.saifshaikh2028]

Where can I get that SQL developer folder?

[@NICITACADEMY]

kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@Mohameddoukoure-gb6xi]

@@NICITACADEMY

[@grgr1831]

Can you make complete plsql like this?

[@NICITACADEMY]

courses.nicitacademy.com/courses

[@dsaraswathi6185]

Hi sir I have 3+ years career gap after my post graduation I learn sql course only any job Opportunities in IT sector with fresher.

[@dsaraswathi6185]

Please reply sir

[@PraveenKumar-ck9vh]

after learning this course can i get join ?

[@harireddy4219]

I want to install Oracle 11g -XE in Mac how to install can you please help me sir @NIC IT ACADEMY

[@NICITACADEMY]

you cannot install directly. Install VMware or VIrtual box and inside you can install Oracle 11g.

[@chillbroyt6741]

Sir make video for type handler in pl sql

[@teliat6242]

@1:28:45 Not much clear. You just say use join but not explain about the statement "a.owner,...." how its work and what the parameters are.

[@khadijashaikh6248]

is this only sql or mysql ?

[@NICITACADEMY]

This is Oracle SQL. Please watch the full video; the SQL is similar to other databases as well, just like MySQL.

[@sumalathaankireddy4664]

When I am trying to practice merge dml command I got error like ora-30926 : unable to get a stable set of rows in the source table Could please tell me when we will get this kind of error

[@rajanigovindu5505]

Sir can u make power center videos

[@NICITACADEMY]

kzbin.info/www/bejne/jGOppY2VfrOgoMk you can get complete training material here courses.nicitacademy.com/courses

[@addankibhoomika6904]

Hi. When i created core in system schema and entered username and password but it showing un or pw is incorrect logon denied. what should i do?

[@NICITACADEMY]

if core user already exist, please try below query in admin and try to connect again alter user core identify by core account unlock; Please watch my sessions, without skipping it. I explained it. Thanks

[@rohitkeshri-1005]

Sir plz upload python

[@NICITACADEMY]

Sure I will do. Keep watching my channel.

[@aravind4440]

SQL developer is not opening in my laptop

[@NICITACADEMY]

Please follow this video kzbin.info/www/bejne/roG2k6uogspqjLc

[@jatavathramesh]

How to install Oracle 19c and SQLplus tool

[@jatavathramesh]

Is it same as which your said in tutorial?

[@jatavathramesh]

System admin and HR and core schema is whether inbuilt in Oracle database or user defined?

[@NICITACADEMY]

kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@NICITACADEMY]

please follow this video kzbin.info/www/bejne/roG2k6uogspqjLc

[@NICITACADEMY]

kzbin.info/www/bejne/roG2k6uogspqjLc

[@PRADEEPM-rS45]

sir can you send notes link

[@NICITACADEMY]

nicitacademy.com/interview-questions/

[@sharminaren8123]

Hello Sir, Unable to connect to Oracle database ,getting the following error. Listener refused the connection ORA -12505 . default SID is 'xe' . please help .

[@jaikrishan9100]

i have need oracle sql certificate ,what i do.

[@maheshramteke2765]

Sir, please make a video on how to install oracle 19c or 21 download. please guide me on this issue after oracle 19c installation. If I start SQLPlus with username and password then adapter issue is showing and if I go to services then I want to start oracle service, oracle is starting then error is showing that windows is local computer Could not start OracleServiceORCL. The system cannot find the file specified.

[@omkargupta8456]

Sir please Oracle DBA sessions

[@Keyboard-mortal]

Drive links are not working

[@NICITACADEMY]

I am updating the notes on our website, Please check nicitacademy.com/