*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 UA-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
Before table backup the mobile no. was Number (10) you updated it with Number (9), then how did the 10-digit mobile number from backup gets inserted in the column.
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.
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.
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 .
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
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
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.
Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION_ID=ArV4YXikTsCS8IZ50hnoXg==) getting this error sir while connecting the SQLDeveloper to system & admin
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=lI0FyI9yQbiCQ0IECHsVwA==) i am getting this error in oracle developer for create connection
Please check this video and import HR schema ua-cam.com/video/xPSbxrMe7VU/v-deo.html or else, re-install Oracle 11g. ua-cam.com/video/Jrefk1hOJQg/v-deo.html
*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 UA-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!
Sir this crash course is awesome
Thanks for your efforts...
Thank you, Keep watching my channel.
Please watch fully and practice.
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
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
Thank you for your great lectures.
You are welcome!
Awesome Course Must watch for the intermediate level also.
Excellent
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 so much for the amazing content, like the content
Glad you enjoy it! 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.
It is helped me lot sir. with real time examples...... Thank you so much sir
You are most welcome
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
an amazing and simple way of teaching. More Power to you Sir ...
Thanks a ton
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
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.
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.
This is amazing content but you need to slow down a little bit. Thank you
Noted! Thanks for your feedback. Keep watching my channel.
Sir, thank you for your efforts.
It's my pleasure
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.
Very good video bro. Thanks for your efforts.
Thanks and welcome
thanks sir
Most welcome
1:42:00
1:11:42
Awsm tutorial..
Thank you! Cheers!
can you please make a video regarding joins with real time project scenarios?
Excellent 👌👍..
Thanks a lot 😊 Keep watching my channel. Please refer to your friends.
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
Can you please provide the transaction table for Analytical Function session, As i checked in the notes its missing
nicitacademy.com/interview-questions/
Informatica -project video and Informatica projects -Join what is the difference
courses.nicitacademy.com/
Hi SIr, May i know the WITH clause topic in which session, i didn't find anywhere
Will upload soon
start from 10:29:00
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 please provide informatica complete tutorial
courses.nicitacademy.com/
Sir if possible please upload python full course
Hi Sir. Is this the complete course of Oracle SQL or just a brief of each topic?. Please help me.
sir, please upload snoflake tutorial playlist .
Sure I will do later.
Hi sir please share complete plsql course
Sure I will
courses.nicitacademy.com/
Finally 🎉
Thanks
sir, when will upload pl/sql video on youtube???
Please check here
courses.nicitacademy.com/
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/
please upload PLSQL full course
Please check here
courses.nicitacademy.com/courses
Sir make video for type handler in pl sql
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
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.
0:35 LIST OF TOPICS
What type of jobs can we find through Oracle SQL.....
For most of the technologies, SQL is basics.
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
Before table backup the mobile no. was Number (10) you updated it with Number (9), then how did the 10-digit mobile number from backup gets inserted in the column.
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.
Could you please share the link for correlated sub query and cte
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
please tell the name of the background music used in the beginning of this video..its very pleasant to hear
Can you please help me with the notes for the classes
I am updating the notes on our website, Please check
nicitacademy.com/
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 Oracle DBA sessions
Will there be any problem, if I use the latest version of Oracle, which is 21c, instead of 11g ?
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
sir please provide document and notes it is not available
Available here: nicitacademy.com/interview-questions/
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.
Is , this Course covers complete basic to advanced topics ?
Basic to advanced level.
Ok Sir
Is default a constraint or not? Please let me know
Yes, it is a constraint in Oracle
share the table data from excel its not in description
ua-cam.com/video/xPSbxrMe7VU/v-deo.html
Sir, can two schemas have same tables or tables with same names?
Yes, we can have.
Please clarify..is this course enough for ETL testing?
Because in depth sql for etl..thank you
It should be enough if you are using any ETL tool
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 .
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
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
While unlock hr account i am getting HR doesn't exist -01918 error could u plz help me to getrid of this error
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.
Hello sir isthis content enough to data analytics job or need to take paid course plz tell
Pls give 100 Informatica power center interview questions &answers in app
Yeah sure I will do. Please check here always.
courses.nicitacademy.com/courses
i have need oracle sql certificate ,what i do.
Can you make complete plsql like this?
courses.nicitacademy.com/courses
sir can you send notes link
nicitacademy.com/interview-questions/
SQL developer is not opening in my laptop
Please follow this video
ua-cam.com/video/xPSbxrMe7VU/v-deo.html
Sir can u make power center videos
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
you can get complete training material here
courses.nicitacademy.com/courses
Sir only hiring 5 to 10 years experience candidate. Not hiring freshers.
Product based and start-up companies will hire Freshers with SQL knowledge, so keep learning
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
Drive links are not working
I am updating the notes on our website, Please check
nicitacademy.com/
Where can I get that SQL developer folder?
ua-cam.com/video/Jrefk1hOJQg/v-deo.html
@@NICITACADEMY
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/
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.
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?
ua-cam.com/video/Jrefk1hOJQg/v-deo.html
please follow this video
ua-cam.com/video/xPSbxrMe7VU/v-deo.html
ua-cam.com/video/xPSbxrMe7VU/v-deo.html
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
(CONNECTION_ID=ArV4YXikTsCS8IZ50hnoXg==) getting this error sir while connecting the SQLDeveloper to system & admin
could please give the SID = orcl while opening new connection
after learning this course can i get join ?
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=lI0FyI9yQbiCQ0IECHsVwA==) i am getting this error in oracle developer for create connection
@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.
Sir can i download this in mac
for unlocking hr it showing hr user doesnot exist
Please check this video and import HR schema
ua-cam.com/video/xPSbxrMe7VU/v-deo.html
or else, re-install Oracle 11g.
ua-cam.com/video/Jrefk1hOJQg/v-deo.html
can i get the notes for this course
Please check the description of this video.
courses.nicitacademy.com/courses
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.
Hr schema is not altering plz help
send syntax
Not 10,000 worth it worths 100000
You are most welcome; thank you for sharing your valuable thoughts! It’s always great to hear such wonderful feedback.
sir notes is not downloading.....
Notes uploaded on the website, please check.
nicitacademy.com/