Dear Siva, I feel honored to have a Guru like you. I request you to kindly make an video on how fresher start working as database developer in company. I mean what are the daily work they do, what process they follow, tools they use, how they connect to company database, how they edit the code and then deploy in production database, how they get requirement etc.
@@SivaAcademy tomorrow i have citi bank interview for l2 support is there anything u can suggest, though i have made notes in index after seeing ur videos thanks for that
Hi, few points keep in mind, just refresh the basic concepts, and practice few scenario based questions. Be straight to the answer, short and direct answer is preferred unless they ask you explain in detail, Best wishes, have a great day ahead 👍👍💐💐
Hello sir, I am watching all the pl sql related videos of yours daily and do practice too, videos are really helpful to me and for others also, thanks a lot
Dear siva, you are explaining the oracle concepts very well. do you have any videos for python, java script, power bi? If its there please share the links
Sir, where is the remaining index based chapter... I am waiting... Completed all interview questions.. Learned good basic knowledge..especially got good knowledge on functions topic.. Carry on sir.. Soon you will get more subscribers.. Supeebbbbb
Hi Sir.. by default an index will be created if we have a primary key . For the same primary key colum I have created one index.. which index will fire..
*select * from USER_INDEXES where table_name='emp'* Sir main iss vali command ko run ker rahi hoo to *data not found* ye error aa rahi hai aisa kyu jabki index created hai meri table per. Jitni index aapne create karna sikhaya hai wo sari maine apni table per lagayi phir bhi. Sir please bataiye please🙏
Answered as part of ua-cam.com/video/jiMwF_V4Ie0/v-deo.html video, however I would suggest you to watch in the same sequence order for better understanding.
Dear Siva, I feel honored to have a Guru like you. I request you to kindly make an video on how fresher start working as database developer in company. I mean what are the daily work they do, what process they follow, tools they use, how they connect to company database, how they edit the code and then deploy in production database, how they get requirement etc.
Best content available on UA-cam and presented in excellent way.
Thank you
Dear Siva, I feel honored to have a Guru like you. I request you to kindly make an video on how fresher start working as database developer in company. I mean what are the daily work they do, what process they follow, tools they use, how they connect to company database, how they edit the code and then deploy in production database, how they get requirement etc.
Sure bro I will post on day to day activities on plsql and interview related questions
@@SivaAcademy which software u have installed sir i want to install on my system n want to work for interview
Oracle database and sql developer
@@SivaAcademy tomorrow i have citi bank interview for l2 support is there anything u can suggest, though i have made notes in index after seeing ur videos thanks for that
Hi, few points keep in mind, just refresh the basic concepts, and practice few scenario based questions. Be straight to the answer, short and direct answer is preferred unless they ask you explain in detail, Best wishes, have a great day ahead 👍👍💐💐
Thank you, Sir...
You are the Best trainer, Sir... Having true understanding of PL/SQL.... Thank you, Sir....
Its my pleasure bro, thank you
Best playlist to understand index concept
thank you
Very well explained in each and every video.... Thank you very much.......
Thank you 🙏💐
Hello sir,
I am watching all the pl sql related videos of yours daily and do practice too, videos are really helpful to me and for others also, thanks a lot
Thank you bro
Hochpoch concept become easy by you sir , so lot of thanks for the same
My pleasure, thank you
Dear siva, you are explaining the oracle concepts very well. do you have any videos for python, java script, power bi? If its there please share the links
U r simply Awesome. Thank you so much for all of your videos. Everything s well defined.
Thank you
Thanku so much sir for these many information on Indexes
Sir, where is the remaining index based chapter...
I am waiting...
Completed all interview questions..
Learned good basic knowledge..especially got good knowledge on functions topic..
Carry on sir.. Soon you will get more subscribers..
Supeebbbbb
Thanks Aravind for your comments.
I am preparing the remaining index related questions, once completed will post soon.
Table A tableB
1. 1
1. 2
2. 2
-. 3
-. -
This is table how to do all Joins in Oracle?
Please help me with answers
Perfect video on Index.. Thanks a lot.
@Visak, Thanks for your comment :-)
I am following you videos. you are doing a great job. good luck man.
Thank you 💐🙏
Great
Clear explanation.. Thanks alot
👍👍🙏🙏
You are awesome sir
Awesome bhai
Thanks bro
You are Superb Sir...
Welcome bro
Thank you Sir for this Video. Please Make video on Global vs Local index and Table Partitions.
sure, please stay tuned
Very nice explanation sit
Thank you so much 🙂
Very useful and well presented. Thank you.
Thanks again for your comments, 🙏🙏🙏
Very good explanation brother. You got a new subscriber.
My pleasure 💐
Nicely explained
@Dhanraj, Thanks for your comments bro....
Excellent Siva
Thank you
Ur Voice plz increase when u making vdos increase volume.... thanku sir for interview questions
ok sure
Thank you
Welcome 💐
Thank you sir for this valuable knowledge. Sir, Please make a video on clustered and non-clustered index
Sure Gautam, please stay tuned
@@SivaAcademy
Sir your lectures are very useful 🙏
Hi Sir.. by default an index will be created if we have a primary key . For the same primary key colum I have created one index.. which index will fire..
We can have only one visible index at any point if we have more than one index, posting the questions tomorrow, please stay tuned
sir good job
please make video on unique index
sure bro, please stay tuned.
nice explanation, thanks
🙏🙏
Nice video, sir PLs make a video on.. What the use of nocopy hint?
Thanks Shashank, Sure, will post video on nocopy hint soon.
great
Thanks
Please also make a video on pipelined table function and its applications
@Ramakant, sure, i will post on pipelined functions and its usage.
Please also let us know global vs local index
How to find weather indexes are being used by the table or not?where can we check
If you could start dummy project and start giving assessment to us then it would be help us to get working environment feeling.
Sure bro I will try this
Can you create the multiple indexes on one table??
yes you can, please look into this video
ua-cam.com/video/JNMI0NxDe4Y/v-deo.html
*select * from USER_INDEXES where table_name='emp'* Sir main iss vali command ko run ker rahi hoo to *data not found* ye error aa rahi hai aisa kyu jabki index created hai meri table per. Jitni index aapne create karna sikhaya hai wo sari maine apni table per lagayi phir bhi. Sir please bataiye please🙏
Hi Siva Sir,
can you please also describe the index internally works when we perform DML operation in the index column and it get impacted?
@mahendra, Sure, will post in detail on DMLs effect on index data, pls stay tuned. Thanks,Siva
@@SivaAcademy Thank you sir!!
Give explanatuon on function based index
I guess its already covered in same series
How to handle compile time error
can you make video on hints which will be useful
sure, Please stay tuned.
Could you please make video on cluster and non cluster index
Sure please stay tuned
Sir plz make a video on data dictionary in SQL
@Shaheen, Sure, i will post a seperate video on data dictionary alone............Thanks,Siva
can we create multiple indexes on same column?
where we use types of indexes for example where we use bitmap index or b-tree index
Answered as part of ua-cam.com/video/jiMwF_V4Ie0/v-deo.html
video, however I would suggest you to watch in the same sequence order for better understanding.
Sir,Can I get complete Oracle course videos
If in a table 100 rows are avialable how retrive only 25 rows through index
Sir can we get a full oracle both sql and plsql full course video i mean paid course video from your channel please replay sir....
As of now not available, will try to create soon bro
Hi Siva,
I came across below question hope you can address it..
when one of column is partitioned in composite index, what happens ?
Sir am searching forms and reports trainer... If you know help to us
Can you please provide notes for all this video for reference
Sir wat about clustered and non clustered index?
Please stay tuned will cover in upcoming videos
What is parallel index
Dear Siva, I feel honored to have a Guru like you. I request you to kindly make an video on how fresher start working as database developer in company. I mean what are the daily work they do, what process they follow, tools they use, how they connect to company database, how they edit the code and then deploy in production database, how they get requirement etc.
Its my pleasure, thank you, please stay tuned, will cover in upcoming videos