*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 😊
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.
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
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.
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.
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 check this video and import HR schema th-cam.com/video/xPSbxrMe7VU/w-d-xo.html or else, re-install Oracle 11g. th-cam.com/video/Jrefk1hOJQg/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
Hello Sir, Unable to connect to Oracle database ,getting the following error. Listener refused the connection ORA -12505 . default SID is 'xe' . please help .
![[[ 8.5 HOURS ]] Complete SQL End to End - SQL Server Tutorial { End to End } Full Course Beginners](http://i.ytimg.com/vi/wI4HWGlI6gM/mqdefault.jpg)
*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
Awesome Course Must watch for the intermediate level also.
Excellent
Sir this crash course is awesome
Thanks for your efforts...
Thank you, Keep watching my channel.
Please watch fully and practice.
Thank you so much for the amazing content, like the content
Glad you enjoy it! Keep watching my channel.
Thank you for your great lectures.
You are welcome!
Thank you so muchh for this amazing class, it was necessary for me thank you
Glad it was helpful! Keep watching my channel.
I really appreciate your efforts , special thanks from SYRIA
Thank you.
I love you! Thanks for all the free information!
You are so welcome!
Excellent video. Thanks
You are welcome! 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
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.
Very good video bro. Thanks for your efforts.
Thanks and welcome
Awesome explanation sir
Thanks and welcome. Keep watching my channel.
Thank you very much Sir. Please keep making such videos 🙏
Sure 👍Thanks, Keep watching my channel.
Good Job. Thanks for sharing. Greetings from Mexico City!
Welcome & Thank you too! Keep watching my channel.
an amazing and simple way of teaching. More Power to you Sir ...
Thanks a ton
Excellent explanation.
I'm glad you found it helpful! Keep watching my channel.
Importantly, please practice all the queries that I have given.
It is helped me lot sir. with real time examples...... Thank you so much sir
You are most welcome
Sir, thank you for your efforts.
It's my pleasure
Sir please make same kind of video or complete blast course on EXCEL, POWER BI, PYTHON (DATA ANALYTICS) 😊
Sure, I will do
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
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/
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
Excellent 👌👍..
Thanks a lot 😊 Keep watching my channel. Please refer to your friends.
This is amazing content but you need to slow down a little bit. Thank you
Noted! Thanks for your feedback. Keep watching my channel.
Awsm tutorial..
Thank you! Cheers!
thanks sir
Most welcome
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.
Hi SIr, May i know the WITH clause topic in which session, i didn't find anywhere
Will upload soon
Can you please provide the transaction table for Analytical Function session, As i checked in the notes its missing
nicitacademy.com/interview-questions/
where i can find the insert data of employees table?
Please install Oracle 11g. I have explained how to install Oracle 11g.
1:11:42
Sir please provide informatica complete tutorial
courses.nicitacademy.com/
sir, when will upload pl/sql video on youtube???
Please check here
courses.nicitacademy.com/
sir, please upload snoflake tutorial playlist .
Sure I will do later.
1:42:00
What type of jobs can we find through Oracle SQL.....
For most of the technologies, SQL is basics.
Finally 🎉
Thanks
start from 10:29:00
Hi sir please share complete plsql course
Sure I will
courses.nicitacademy.com/
can you please make a video regarding joins with real time project scenarios?
Sir, can two schemas have same tables or tables with same names?
Yes, we can have.
Where are the pratice questions ??
check in the description and watch full video.
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
Could you please share the link for correlated sub query and cte
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
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/
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.
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 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
share the table data from excel its not in description
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
Is default a constraint or not? Please let me know
Yes, it is a constraint in Oracle
Wonderful!
Many thanks!
Sir if possible please upload python full course
please upload PLSQL full course
Please check here
courses.nicitacademy.com/courses
Can you please help me with the notes for the classes
I am updating the notes on our website, Please check
nicitacademy.com/
Where can I get that SQL developer folder?
th-cam.com/video/Jrefk1hOJQg/w-d-xo.html
@@NICITACADEMY
Hi Sir. Is this the complete course of Oracle SQL or just a brief of each topic?. Please help me.
Is , this Course covers complete basic to advanced topics ?
Basic to advanced level.
Ok Sir
sir can you send notes link
nicitacademy.com/interview-questions/
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/
0:35 LIST OF TOPICS
Can you make complete plsql like this?
courses.nicitacademy.com/courses
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.
Will there be any problem, if I use the latest version of Oracle, which is 21c, instead of 11g ?
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
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 please Oracle DBA sessions
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.
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.
Drive links are not working
I am updating the notes on our website, Please check
nicitacademy.com/
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/
How to install Oracle 19c and SQLplus tool
Is it same as which your said in tutorial?
System admin and HR and core schema is whether inbuilt in Oracle database or user defined?
th-cam.com/video/Jrefk1hOJQg/w-d-xo.html
please follow this video
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
i have need oracle sql certificate ,what i do.
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
Sir make video for type handler in pl sql
Informatica -project video and Informatica projects -Join what is the difference
courses.nicitacademy.com/
please tell the name of the background music used in the beginning of this video..its very pleasant to hear
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
after learning this course can i get join ?
Sir plz upload python
Sure I will do. Keep watching my channel.
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.
Sir can i download this in mac
SQL developer is not opening in my laptop
Please follow this video
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
Hello sir isthis content enough to data analytics job or need to take paid course plz tell
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
sir is it only sql or oracle sql ?
Oracle is the Database, and SQL is the language to extract/manipulate the data from data base.
can i get the notes for this course
Please check the description of this video.
courses.nicitacademy.com/courses
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
Hr schema is not altering plz help
send syntax
for unlocking hr it showing hr user doesnot exist
Please check this video and import HR schema
th-cam.com/video/xPSbxrMe7VU/w-d-xo.html
or else, re-install Oracle 11g.
th-cam.com/video/Jrefk1hOJQg/w-d-xo.html
While unlock hr account i am getting HR doesn't exist -01918 error could u plz help me to getrid of this error
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 or not opening sir
nicitacademy.com/materials/oracle-sql/
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 notes is not downloading.....
Notes uploaded on the website, please check.
nicitacademy.com/
Can you upload this same video in Tamil sir?
I already posted it in TAMIL, please check below video. Keep weatching my channel.
th-cam.com/video/d04g-tnAxSQ/w-d-xo.html
Pls give 100 Informatica power center interview questions &answers in app
Yeah sure I will do. Please check here always.
courses.nicitacademy.com/courses