Index in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

Подписаться 1,3 млн

Просмотров 126 тыс.

50% 1

** For Online Training Registration: goo.gl/r6kJbB ► Call: +91-8179191999
💡 Visit Our Website for Classroom Training:
nareshit.in/oracle-training/
💡 For Online Training:
nareshit.com/oracle-online-tr...
#Oracle #Training #CourseVideos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 us.training@nareshit.com/ 📧 online@nareshit.com or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
--------------------------
💡 Check The Below Links
► For Course Reg: goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.com/+NareshIT
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitek
► Follow us on Linkedin: goo.gl/CRBZ5F
► Follow us on Instagram: goo.gl/3UXYK3

Опубликовано:

17 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@NareshIT 5 лет назад

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

@dumpling6440 2 года назад

What happens if we keep more than 1 or 2 col in index and only one condition in where clause. How will it work???

@techtrends.programming Год назад

Index in SQL Explained in precise and to the point, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YqzA_e-n-tQ.html

@ganeshkashyap8573 7 лет назад

Not too fast, Not too slow, just at right speed and pace!! Wonderful and correct information.

@ebinvarghese4239 9 месяцев назад

its most perfect and simply explained video.

@santoshkori8992 5 лет назад

I am huge fan of your teaching way. Thankyou very much 😀

@pavanmadamset 7 лет назад

Excellent Explanation Sir! Thank You Very Much, Vijay Kumar Sir!!! I am learning because of You Sir!!!

@manikanta-yd7zf 5 лет назад

Sir your tutorials are super, i know u are good trainer . I am also attended ur regular classes

@divyasangeetham4385 3 года назад

Your amazing sir, you clarified all doubts of mine regarding index with single video👏👏👏👏👏. Thank you so much☺️

@nidhikavaidh6468 6 лет назад

As I have seen a few videoes untill now and liked all videoes.Thanks for such a nice explaination in each videoes.

@kiranraghuwanshi1012 3 года назад

video is too good, i was not having any idea about indexed, now i am having good idea, thanks you so much sir for this video, its very helpfull

@harishbabu6450 6 лет назад

very nice and clear explanation..good job vijay!

@maheshamara7612 2 года назад

It's really awesome. There is no words to say sir. Superb Sir..... Both index and materialized views...

@sravyasreeram8816 3 года назад

Very nice explanation Sir....I understood the concept clearly.. Thank you very much

@kharish525 6 лет назад

Its Very Clear Explanation Sir, I Hope You Upload Oracle Architecture 12c also...... :)

@sivaram8726 6 лет назад

Thank You. Mr.Vijay..!!

@kishorpatil37 5 лет назад

thanks sir...very good explanation

@KalyanS 3 года назад

Nice and good . Naresh tech u r posting useful videos in all technologies. thanks

@manish8067 6 лет назад

This index is on NUMBER datatype column. What if we create a index on VARCHAR2 datatype column? How it will create a B- Tree then? Could you please explain?

@jitendraverma3783 3 года назад

Thankyou so much Very well explained

@vickypatekar9532 4 года назад

Vijay Sir you are the great Thank you So much

@keshavgupta633 2 года назад

Best video to learn indexing in sql

@rjraob 4 года назад

Excellent explanation.

@mathaiissac1587 2 года назад

Thank you, helps a lot!

@90medha 5 лет назад

Very nice explanation 👍

@dhanrajpatel8746 6 лет назад

Sir, could you please upload the bitmap index video.

@pankajkharade6936 3 года назад

my question is how the root node selected by oracle for index creation if root node selection based on the median value then in case of live system data is continuously inserted into the table so each time there will be a change in the median which means a change in root node value.

@singamramagangireddy721 6 лет назад

Sir, I have been asked by the interviewer many times about Local and Global indexes? What we can say when they have asked about Local and Global indexes. When the indexes become Local and Global.. Please clarify on this?

@HariHaran-zy6fk 2 года назад

Well mannered explanation

@crazyvedika145 3 года назад

Very well explained..

@jinalvipani6075 6 лет назад

Nicely explained with example !!!!

@lalchandnagargoje9708 5 лет назад

Good

@ramgoomohan9301 5 лет назад

Thanks u r uploaded video.

@dqplys 7 месяцев назад

Thank you sir

@ramblermayur6431 2 года назад

Very nice explained 🙂

@divyavani1213 11 месяцев назад

very good explanation sir

@sarsatheeshreddy3341 7 лет назад

super sir pls upload few more videos

@giridharkumar4067 3 года назад

Nicely explained

@aiswarya3461 2 года назад

Thank you Sir !

@chatrapatia.k1885 7 лет назад

Hello Sir , I'm your biggest fan... please share a video regarding Global Temporary Table and what's use of such types of table in real time...

@Dhiepiga 4 года назад

Global temporary table is a temporary table once if the action is done it will automatically get closed best example is ticket booking in app (if the end user books the ticket in app that session is blocked once the transaction has done and that particular seat will not shows to other user Evan if the transaction is not completed after that end user left the app then that session will get closed its called global temporary table)

@amitsinha3082 6 лет назад

Thanks !

@sindhuc7359 2 года назад

Best teacher

@shwetashelar965 6 лет назад

very usefull

@RUGVEDGAMING99 5 лет назад

Please upload video on bit map and function base index also

@ShivShankarPrasad4u 6 лет назад

Hello sir, the b-tree graph that you are using in this tutorial is unbalanced, and b-tree will never be unbalanced. btree have some property. Property #1 - All the leaf nodes must be at same level. Property #2 - All nodes except root must have at least [m/2]-1 keys and maximum of m-1 keys. Property #3 - All non leaf nodes except root (i.e. all internal nodes) must have at least m/2 children. Property #4 - If the root node is a non leaf node, then it must have at least 2 children. Property #5 - A non leaf node with n-1 keys must have n number of children. E.T.C.

@manivannanv3806 3 года назад

excellent

@ajinkyamore3288 7 лет назад

Can you please add Oracle videos of Murali sir also....

@mithundwivedi8146 6 лет назад

Hello Naresh, Could you please load the query performance vedio.

@kaztee7369 7 лет назад

can someone please help with this sql i want the user to update his profile. i create a profile page now i cant get the sql correct for the upadte button. i tried update user (table) set firstname,lastname,address,email,telephone (fields in my table) where 'email' (email it uses to update that particular user account details

@ganeshkashyap8573 7 лет назад

have you tried breaking down the columns. I mean like this: SQL> UPDATE SET firstname = a, lastname = b, address = c, email = d, telephone = e WHERE some_colun name = some_value; We use where condition because you need to update one specific row not the entire column or table. Hope this helps.

@sunilraj5454 6 лет назад

AUTOTRACE IN NOT WORKING IN MYSQL..SUGGEST THE QUERY FOR MYSQL

@rohitpandey9986 6 лет назад

Hello Sir, Nice explanation. I have some doubts: 1. How that main index root node is decided to be 3000? 2. Does Btree indexing sorts the column values at the time of index creation within itself because salary column is majorly non-sorted column and Btree seems applicable on sorted records only? Please clarify. Thanks!