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
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..
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
*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 ruclips.net/video/jiMwF_V4Ie0/видео.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 RUclips 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
Hochpoch concept become easy by you sir , so lot of thanks for the same
My pleasure, thank you
Very well explained in each and every video.... Thank you very much.......
Thank you 🙏💐
00:36 - In this Video we will see how to create Index
01:43 - Now what we are trying to create
Thanku so much sir for these many information on Indexes
U r simply Awesome. Thank you so much for all of your videos. Everything s well defined.
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
Very nice explanation sit
Thank you so much 🙂
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 💐🙏
You are Superb Sir...
Welcome bro
You are awesome sir
04:15 - Bit Map Index, 10:09 - Practical
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
Great
Clear explanation.. Thanks alot
👍👍🙏🙏
1:18 - Start - In this Video
Nicely explained
@Dhanraj, Thanks for your comments bro....
Excellent Siva
Thank you
Awesome bhai
Thanks bro
Very useful and well presented. Thank you.
Thanks again for your comments, 🙏🙏🙏
Thank you Sir for this Video. Please Make video on Global vs Local index and Table Partitions.
sure, please stay tuned
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, 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.
Very good explanation brother. You got a new subscriber.
My pleasure 💐
nice explanation, thanks
🙏🙏
Ur Voice plz increase when u making vdos increase volume.... thanku sir for interview questions
ok sure
sir good job
please make video on unique index
sure bro, please stay tuned.
How to find weather indexes are being used by the table or not?where can we check
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 🙏
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
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!!
Sir am searching forms and reports trainer... If you know help to us
Can you create the multiple indexes on one table??
yes you can, please look into this video
ruclips.net/video/JNMI0NxDe4Y/видео.html
Please also make a video on pipelined table function and its applications
@Ramakant, sure, i will post on pipelined functions and its usage.
Nice video, sir PLs make a video on.. What the use of nocopy hint?
Thanks Shashank, Sure, will post video on nocopy hint soon.
How to handle compile time error
great
Thanks
can we create multiple indexes on same column?
Please also let us know global vs local index
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
Sir,Can I get complete Oracle course videos
*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🙏
Thank you
Welcome 💐
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
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
If in a table 100 rows are avialable how retrive only 25 rows through index
Sir plz make a video on data dictionary in SQL
@Shaheen, Sure, i will post a seperate video on data dictionary alone............Thanks,Siva
Give explanatuon on function based index
I guess its already covered in same series
Hi Siva,
I came across below question hope you can address it..
when one of column is partitioned in composite index, what happens ?
Sir wat about clustered and non clustered index?
Please stay tuned will cover in upcoming videos
where we use types of indexes for example where we use bitmap index or b-tree index
Answered as part of ruclips.net/video/jiMwF_V4Ie0/видео.html
video, however I would suggest you to watch in the same sequence order for better understanding.
Can you please provide notes for all this video for reference
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