*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. 🌕 +91 7010080468 or WhatsApp 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy (Since 2014) - A decade of training excellence.
I have one doubt, Already you are realsing vedios on PL/SQL in TH-cam, May i know what is the difference between PL/SQL Self placed course and your youtube vedios on PL/SQL 😌
@@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
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 😊
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.
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 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
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
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?
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.
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.
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
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
Hello Sir, Unable to connect to Oracle database ,getting the following error. Listener refused the connection ORA -12505 . default SID is 'xe' . please help .
Sir this one is not working " Oracle 11g - 64 bit version " it says the destination file could not be created error 0x800704v7: the operation was canceled bye the user. please help. thks
*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.
🌕 +91 7010080468 or WhatsApp 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
(Since 2014) - A decade of training excellence.
first link is not opening
Please check now
I want to install Oracle 11g -XE in Mac how to install can you please help me sir @NIC IT ACADEMY
@@NICITACADEMY duration of plsql paid course
I have one doubt, Already you are realsing vedios on PL/SQL in TH-cam, May i know what is the difference between PL/SQL Self placed course and your youtube vedios on PL/SQL
😌
Thanks for your teaching and uploading the un-paid course on this channel.
You're very welcome!
best Video i ever watch on youtube for SQL,
best video loved it,Thank you Sir
You are most welcome
@@NICITACADEMY sir i have one doubt,While creating an backup table the constraints are not copying , can i solution for this
Thank you so much for the amazing content, like the content
Glad you enjoy it! Keep watching my channel.
Awesome Course Must watch for the intermediate level also.
Excellent
Great initiative sir was intact💯💯
I really appreciate your kind words! It means a lot to me to have such supportive viewers.
Sir this crash course is awesome
Thanks for your efforts...
Thank you, Keep watching my channel.
Please watch fully and practice.
Thank you so muchh for this amazing class, it was necessary for me thank you
Glad it was helpful! Keep watching my channel.
Thank you for your great lectures.
You are welcome!
I really appreciate your efforts , special thanks from SYRIA
Thank you.
Excellent video. Thanks
You are welcome! Keep watching my channel.
Good Job. Thanks for sharing. Greetings from Mexico City!
Welcome & Thank you too! Keep watching my channel.
This video helped me to crack the Accenture interview. Excellent content. Thanks for your time.
You are most welcome; glad to hear this.
you mean bangaluru accenture
Awesome explanation sir
Thanks and welcome. Keep watching my channel.
I love you! Thanks for all the free information!
You are so welcome!
an amazing and simple way of teaching. More Power to you Sir ...
Thanks a ton
Very good video bro. Thanks for your efforts.
Thanks and welcome
Excellent explanation.
I'm glad you found it helpful! Keep watching my channel.
Importantly, please practice all the queries that I have given.
Tysm air for this valuable course. 🙏 Kindly please make same long video or course for PLSQL. It will help us alot.plz 🙏 ASAP
Thanks
courses.nicitacademy.com/
Sir please make same kind of video or complete blast course on EXCEL, POWER BI, PYTHON (DATA ANALYTICS) 😊
Sure, I will do
This 12 hr videos enough for to start the data engineer
Thank you very much Sir. Please keep making such videos 🙏
Sure 👍Thanks, Keep watching my channel.
It is helped me lot sir. with real time examples...... Thank you so much sir
You are most welcome
lot of love sir perfect time you drop the golden gems 💎 ❤❤❤❤
Thank you. Keep watching fully.
@@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
Hi Manooj, Thanks, Please share it your friends group.
I will upload normalization and RDBMS basic concepts as well.
Thanks, Keep watching my channel.
Sir, thank you for your efforts.
It's my pleasure
Sir, If possible please upload complete PL/SQL tutorial. Thanks for sharing this tutorial.
Please check here
courses.nicitacademy.com/courses
@@NICITACADEMY link is not working sir
Is oracle free to install for study
@@NICITACADEMY sir , link was not working...404 not found error message showing...
Please upload videos on PL/SQL
@@NICITACADEMYlink not working
This is amazing content but you need to slow down a little bit. Thank you
Noted! Thanks for your feedback. Keep watching my channel.
thanks sir
Most welcome
Excellent
I really appreciate your kind words! Keep watching the videos!
Excellent 👌👍..
Thanks a lot 😊 Keep watching my channel. Please refer to your friends.
Where is the practice questions u mentioned?
Awsm tutorial..
Thank you! Cheers!
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 😊
Sure I will, Keep watching my channel.
Thanks A Lot n Lot's 🤝🤝🤝
Thank you too. Keep watching my channel and refer to your friends.
you can check other courses here.
courses.nicitacademy.com/courses
awesome
I really appreciate your support! It means a lot to me that you found the video helpful!
Can you please provide the transaction table for Analytical Function session, As i checked in the notes its missing
nicitacademy.com/interview-questions/
Hi SIr, May i know the WITH clause topic in which session, i didn't find anywhere
Will upload soon
can you please make a video regarding joins with real time project scenarios?
1:42:00
Hi Team,
Can you guide me to install sql oracle database 12c on windows 11 os
Please follow the same process. This is Oracle 21C installation video
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
Please provide the timestamps, if possible. It would be helpful to go to a particular session
I already added the chapters. I will add more timestamp.
where i can find the insert data of employees table?
Please install Oracle 11g. I have explained how to install Oracle 11g.
Sir please provide informatica complete tutorial
courses.nicitacademy.com/
sir, please upload snoflake tutorial playlist .
Sure I will do later.
1:11:42
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.
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
In the 12-hour video, I added more days of sessions. Now, I am uploading the latest videos. However, everything is the same concept.
@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
You can follow this video itself, I have clearly given the topics.
Happy learning :)
@@NICITACADEMY Thank you sir!
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
Congratulations, Please check here
courses.nicitacademy.com/
0:35 LIST OF TOPICS
Hi Sir. Is this the complete course of Oracle SQL or just a brief of each topic?. Please help me.
Hi sir please share complete plsql course
Sure I will
courses.nicitacademy.com/
hi sir,
DISPLAY EMPLOYEES WHO SALARY IS MORE THAN AVERAGE SAL OF DEPARTMENT ?
i want query for this
Finally 🎉
Thanks
Sir if possible please upload python full course
start from 10:29:00
Could you please share the link for correlated sub query and cte
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
sir please provide document and notes it is not available
Available here: nicitacademy.com/interview-questions/
Hi Sir, Rank function in which class it is available i didn't find anywhere
You can find the Rank function in the Analytical function session of the course.
@@NICITACADEMY Thanks
Will there be any problem, if I use the latest version of Oracle, which is 21c, instead of 11g ?
Wonderful!
Many thanks!
Sir, can two schemas have same tables or tables with same names?
Yes, we can have.
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?
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.
this course is for tester or Developer?. For Tester is this course is benefits?
SQL is a mandatory skill set for most roles in development and testing.
What type of jobs can we find through Oracle SQL.....
For most of the technologies, SQL is basics.
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.
I am updating the notes on our website, Please check
nicitacademy.com/
sir, when will upload pl/sql video on youtube???
Please check here
courses.nicitacademy.com/
Is default a constraint or not? Please let me know
Yes, it is a constraint in Oracle
Sir in join u didn't talk about foreign key and primary key while create table for joins
For joins, the keys(Data integrity) are not mandatory.
Sir please Oracle DBA sessions
please upload PLSQL full course
Please check here
courses.nicitacademy.com/courses
Sir make video for type handler in pl sql
share the table data from excel its not in description
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
Is , this Course covers complete basic to advanced topics ?
Basic to advanced level.
Ok Sir
Where can I get that SQL developer folder?
th-cam.com/video/Jrefk1hOJQg/w-d-xo.html
@@NICITACADEMY
Where are the pratice questions ??
check in the description and watch full video.
Hi Chandra, Thanks for the Videos but I can't able to download the Notes, pls place old notes for download.
nicitacademy.com/materials/oracle-sql/
Can i take this course, if I'm beginner for oracle?
Yes definitory, I have explained from scratch.
You can check our other courses here.
courses.nicitacademy.com/courses
Hello sir isthis content enough to data analytics job or need to take paid course plz tell
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.
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?
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
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
please tell the name of the background music used in the beginning of this video..its very pleasant to hear
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.
Please reply sir
Hello Sir, Unable to connect to Oracle database ,getting the following error. Listener refused the connection ORA -12505 .
default SID is 'xe' . please help .
@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.
Can you please help me with the notes for the classes
I am updating the notes on our website, Please check
nicitacademy.com/
Informatica -project video and Informatica projects -Join what is the difference
courses.nicitacademy.com/
What is the query for this --DISPLAY EMPLOYEES WHO SALARY IS MORE THAN AVERAGE SAL OF DEPARTMENT
SELECT name, department_id, salary
FROM employees e
WHERE salary > (select avg(salary) from employees e2 where e2.department_id = e.department_id);
@@NICITACADEMY Thanks for the update, It is Correlated Subquery right Sir
SQL developer is not opening in my laptop
Please follow this video
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
Sir this one is not working " Oracle 11g - 64 bit version " it says the destination file could not be created error 0x800704v7: the operation was canceled bye the user. please help. thks
Drive links are not working
I am updating the notes on our website, Please check
nicitacademy.com/
While unlock hr account i am getting HR doesn't exist -01918 error could u plz help me to getrid of this error
i have need oracle sql certificate ,what i do.
I want to install Oracle 11g -XE in Mac how to install can you please help me sir @NIC IT ACADEMY
you cannot install directly. Install VMware or VIrtual box and inside you can install Oracle 11g.
Sir can i download this in mac
Sir can u make power center videos
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
you can get complete training material here
courses.nicitacademy.com/courses
is this only sql or mysql ?
This is Oracle SQL. Please watch the full video; the SQL is similar to other databases as well, just like MySQL.
sir can you send notes link
nicitacademy.com/interview-questions/
Sir plz upload python
Sure I will do. Keep watching my channel.
after learning this course can i get join ?