TechnoTrax
TechnoTrax
  • 15
  • 555 614
Mysql Index Tutorial | [Simple Explanation] [2020]
In this video, we'll see how basic Mysql Index concept works. We'll see how Mysql B-Tree index concept works with a simple example.
Power of Mysql Index: ua-cam.com/video/MS70fZbOuqo/v-deo.html
Mysql Index works similar to how an index in a Book works. Mysql Indexes stored indexed column data in a separate storage in an Ordered List. When we search for a value, Mysql searches in the index column using the B-tree concept.
Mysql B-tree index works by first checking the middle value in the ordered indexed column, if the value is greater, it will continue to search on the right side of the column. If the value is lesser than the the middle value, it will search to left of the column. This method of search continues till it matches the value. This way, indexed columns need not scan all the rows of the table.
SUBSCRIBE: ua-cam.com/channels/vrnQcFaGHw0kwm9chkzXtw.html
Переглядів: 63 248

Відео

Mysql Index Tutorial | Make websites 100 Times Faster!!! Query time from 2 Sec to 3 Milli Seconds
Переглядів 35 тис.4 роки тому
Here I'll show how we can speed up our Mysql Queries using MySQL indexes. We'll convert queries that take over 2 Seconds to under 3 Milli Seconds. Create Index: dev.mysql.com/doc/refman/5.7/en/create-index.html Drop Index: dev.mysql.com/doc/refman/5.7/en/drop-index.html Create table: dev.mysql.com/doc/refman/5.7/en/create-table.html Alter Table: dev.mysql.com/doc/refman/5.7/en/alter-table.html ...
If Else Statement | Code IF / Else Statements Like a Pro!!!
Переглядів 1,5 тис.4 роки тому
Learn powerful ways of writing conditional statements using Ternary operators and many other cool tips and tricks of writing code like a Pro! Learn to: - Use Ternary Operator. - Null Coalescing Operator - Best way to compare Variables and Values - Without Parenthesis and Single Line conditions - and Avoiding Else statements We can write If Else statements in many ways. Sometimes it is important...
PHP Interface: Basics, uses and practical example | 2020
Переглядів 2,3 тис.4 роки тому
Complete guide on PHP Interfaces with detailed explanation using a practical example. Learn why we use PHP Interface Classes. How we can implement Interface in out program. Learn the concepts of PHP interfaces and its protocols and also how we use them in PHP programming with a practical example. Learn everything from the need to use Interface classes, how to implement them and how to group cla...
PHP Abstract Classes: Basics, uses and practical example | 2020
Переглядів 1,5 тис.4 роки тому
Complete guide on PHP Abstract classes with detailed explanation using a practical example. Learn why we use Abstract Classes. How we use abstract methods to allow client classes to have custom implementations and Learn basic concepts of PHP abstraction and its protocols and also how we use abstract classes in PHP programming. SUBSCRIBE: ua-cam.com/channels/vrnQcFaGHw0kwm9chkzXtw.html PHP Inter...
PHP Autoload and Namespaces [Extended Guide] | [2020]
Переглядів 14 тис.4 роки тому
Complete Tutorial on PHP autoloading with the basics of namespace and composer and how they help in Autoloading PHP classes. To skip the Introduction Jump to Autoloading: 02:56 PHP Autoload - 02:56 PHP Namespaces Basics - 10:05 PHP Namespace Autoload - 12:25 What is Composer? - 16:50 Composer Autoloading - 22:38 Please support the channel by subscribing for more video on PHP. SUBSCRIBE: ua-cam....
Newton's Laws Of Motion | under 5 Minutes!
Переглядів 5914 роки тому
Let's take a look at Newton's 3 Laws of Motion. Learn everything from the effect of Forces on objects, its effect on momentum, Inertia and much more. Credit: Jelly Fish Video: Magda Ehlers Disclaimer: The Video Content has been made available for informational and educational purposes only. I am not an expert in the field of physics, and the information in this video is represented to the best ...
Top 5 Free Addictive Browser Games | April 2020 |
Переглядів 2794 роки тому
These are my Top five Free Addictive browser games for 2020. Play these Free to Play Games on any Browser. powerline.io - powerline.io/ slither.io - slither.io/ wings.io - wings.io/ spelunky - spelunkyworld.com/ threesJS - threesjs.com/
How to play Catan Online - with example under 10 minutes!!
Переглядів 22 тис.4 роки тому
Catan Online!!! Learn how to play Catan Online with an example. Learn everything from the setup, buildings, trading, role of the robber and development cards. Understand how bonus cards work and some strategies. Catan Online is a strategy game. It has quite a learning curve, but once mastered, the game is extremely rewarding.
Docker Tutorial For Beginners - Basics, Docker commands and docker compose [2020]
Переглядів 1,3 тис.4 роки тому
Learn the Basics of Docker, docker commands, docker files and how to use docker compose in this Docker tutorial for Beginners. Look into difference between Docker and Virtual Machines and some basic Docker commands and also learn how to use Docker Compose. Understand what is virtualization and how this layer works in the Operating system. We will also take a look at the difference between Virtu...
Five Android Tricks You Must Try Today | 2020 | 5 Easy Tricks
Переглядів 1275 років тому
Here are Five Android Tricks You Must Try Today . These are five amazing android tricks and tips you probably didn't know. Did you know you can search using your handwriting??? Well, we can! Here are just five such cool tricks. Easily switch Tabs on Chrome Browser in the Android Device. Learn Android Screen Pinning. Not to mention the very Important Lock screen Messages (Help Contact someone If...
Video Editing on Mac OS X
Переглядів 4425 років тому
Complete video tutorial on editing videos for youtube on Mac OS using iMovie. Learn everything you need to create stunning videos in not time. You'll learn everything from : - Video editing (Trimming, splitting etc). - Adding audio clips, sound effects and voice overs. - Backgrounds, title and many other cool effects. Like & Subscribe!
how to use eclipse for java programming
Переглядів 299 тис.5 років тому
In this video, we'll learn how to use eclipse for java programming. We will create a simple project and execute the program. We'll also learn how to debug the program. Eclipse installation guide: ua-cam.com/video/eUb0B8IL1y8/v-deo.html Java Installation: ua-cam.com/video/sNYvYTmOGhU/v-deo.html
How to install Eclipse on Mac OS X for 2020 | Eclipse IDE for Java development
Переглядів 31 тис.5 років тому
Learn how to Install Eclipse on Mac OS X. Download and install Eclipse IDE 2019-03 on Mac OS X for Java development in 2020. Eclipse is an IDE used for programming. In this video, we will look at how to Download Eclipse and how to Install Eclipse on Mac OS X for Java development. The same steps can be used to Download latest version of Eclipse software. Follow these simple steps to Install Ecli...
How to Install Java on Mac OS X | 2020
Переглядів 83 тис.5 років тому
How to install Java JDK (Java Development kit 12) on Mac OS. Download and install Java on Mac OS X. We will also update the JAVA_HOME environment variable needed for development. ADDITIONAL IMPORTANT STEP!!! After saving the Bash profile file, please open terminal and type "source ~/.bash_profile" without the quotes. After that echo $JAVA_HOME and it should work. Enter the following in the .bas...

КОМЕНТАРІ

  • @kunaljain-l8l
    @kunaljain-l8l 12 днів тому

    crisp explanation for a relatively difficult topic to understand/visualise

  • @munandisichali605
    @munandisichali605 13 днів тому

    Its like am cheating on the namespaces explanation cause others don't explain the pattern in simple terms. thanks

  • @najmatoughyan6625
    @najmatoughyan6625 2 місяці тому

    I have no idea what I would do in my java programming class without watching this video. Great explanation, thank you!!!

  • @helalabboud2193
    @helalabboud2193 2 місяці тому

    To be honest I swear you are an amazing person And a creative teacher You deserve all respect 🙏 I hope you continue creating useful videos

  • @justinabosco2763
    @justinabosco2763 2 місяці тому

    After watching 5 other videos, finally I understand what indexing is. Thank you

  • @makarsh29
    @makarsh29 2 місяці тому

    amazing

  • @resilientbit
    @resilientbit 2 місяці тому

    Excellent! Clear and concise explaination for all aspects of autoloading in a single video. 👍

  • @mehdi-vl5nn
    @mehdi-vl5nn 4 місяці тому

    old but gold

  • @carlaross2308
    @carlaross2308 4 місяці тому

    Thank you.

  • @thehunter11
    @thehunter11 5 місяців тому

    When you find just the perfect explanation... Thank you man !

  • @luciano_mdc7443
    @luciano_mdc7443 5 місяців тому

    Which is your editor or client?

  • @amrextracoding
    @amrextracoding 5 місяців тому

    An AMAZING explanation. it was really helpful. Thanks for great efforts

  • @bethelalbor
    @bethelalbor 7 місяців тому

    It works! Thank you! It also works if you create a package first before creating a java class

  • @colorart4146
    @colorart4146 8 місяців тому

    Oops! I should watch this video very beginning to learn php autoload! Thanks for your kind explaination in all the way.

  • @el_joker_2243
    @el_joker_2243 9 місяців тому

    thanks alot

  • @thoughts2313
    @thoughts2313 10 місяців тому

    Excellent explanation . God bless !!

  • @zakariyaechergui3265
    @zakariyaechergui3265 Рік тому

    thank you sir for this beautiful video

  • @pctechcomputers513
    @pctechcomputers513 Рік тому

    hi. we are getting an FATAL error when we update any data. Can you please help.

  • @hayetaitouazzou7290
    @hayetaitouazzou7290 Рік тому

    Thank you Brother for this video.

  • @Younashassainar
    @Younashassainar Рік тому

    Thanks sir

  • @Younashassainar
    @Younashassainar Рік тому

    Thanks sir

  • @NingenVRC
    @NingenVRC Рік тому

    Hello sorry for the late comment, but how do you make your eclipse interface so big and proportioned? Mine is either too big or too small (especially the icons)

  • @ayeshashifa1355
    @ayeshashifa1355 Рік тому

    thank you so much .only proper tutorial of eclipse in youtube so far .you saved me once again thank you so so so so much

    • @saifallahsalih5316
      @saifallahsalih5316 6 місяців тому

      learn how to be a housewife and please ur husband instead

  • @theyoogle
    @theyoogle Рік тому

    Its good, please make a tutorial on mysql cpu/ram configuration

  • @theidanking
    @theidanking Рік тому

    Great video, explained very good!

  • @minhazulpr
    @minhazulpr Рік тому

    Wow! It's awesome. Nice explanation. Thank Your for your effort.

  • @Laravelcode
    @Laravelcode Рік тому

    this is not valid way to index to any varchar

  • @NotMarkKnopfler
    @NotMarkKnopfler Рік тому

    Logic in the spl_autoload_register method.... No thanks! Kind of explains why all these freaking php frameworks are so slow. I'll stick to explicitly including my files. Having the autoload method in a separate file is evil. It's hiding information away. Not a criticism of the video author - this is how it's done in PHP. I just don't agree with it. Appreciated the info on namespaces - I use them a lot in C++ but PHP's implementation seems more powerful and very elegant. 👍

  • @geniushomwetv9793
    @geniushomwetv9793 Рік тому

    Straight forward thank you

  • @__hazelnut
    @__hazelnut Рік тому

    This explanation is extremely clear. Thank you so much!

  • @huboohubert5299
    @huboohubert5299 Рік тому

    Thanks! :)

  • @lorettashekleton5868
    @lorettashekleton5868 Рік тому

    That was a perfect explanation - many thanks

  • @NedumEze
    @NedumEze Рік тому

    Dear Sir, Thank you very much for the clearest tutorial on this subject anywhere. I structured my directories same as yours, Namespaces, same as yours. I then 'Composer update', everything looked alright. But when I ran "Composer dump-autoload", I got errors: Saying, Class app\appClasses\Darabase located in c:/code/app\appClasses\New Database.php does not comply with psr-4 autoloading standards. Skipping. What is wrong?

  • @MrTRK111
    @MrTRK111 Рік тому

    clean tutorial

  • @growtogether8014
    @growtogether8014 Рік тому

    This is exactly what I was searching for. So, in layman terms it creates a new table with column on which index has been created and memory pointer locations of each associated record. Then it sorts it and applies the Binary search algorithm to search the requested column value and there by fetches the associated pointer location, which in turn takes us directly to that memory location and presents the record to user.

  • @pradnyakasar614
    @pradnyakasar614 Рік тому

    I got this error (Error Code: 1071. Specified key was too long; max key length is 3072 bytes)

  • @zstar8397
    @zstar8397 Рік тому

    hey i just wanna say that GOD loved the world so much he sent his only begotten son Jesus to die a brutal death for us so that we can have eternal life and we can all accept this amazing gift this by simply believing in him (Jesus) asking for the forgiveness of your sins and forming a relationship with heavenly father.

    • @rosegold2072
      @rosegold2072 10 місяців тому

      Are you even hearing yourself right now? Your 'God' DIED so he could forgive humans even from sins they didn't even commit themselves (the original sin) and only then does he have the power to give eternal life? And those who don't believe he died for them don't get paradise because that somehow negates him dieing for you? You DO realise how silly this all sounds right?

  • @fineas4
    @fineas4 Рік тому

    This has to be standard solution for sql querries, to be done automatically by the database software you use

  • @KerbadouGhazali
    @KerbadouGhazali Рік тому

    Thanks a lot for this tutorial, you helped me a lot.

  • @echo4936
    @echo4936 Рік тому

    Thanks for this tutorial :)

  • @nhatnam4627
    @nhatnam4627 Рік тому

    great tutorial

  • @nicolaslarraya9477
    @nicolaslarraya9477 Рік тому

    GRACIAS HERMANO, NO PUDE USAR ECLIPSE HASTA QUE VI TU VIDEO PA. SALUDITO.

  • @NedumEze
    @NedumEze Рік тому

    The best tutorial on this subject. Amazing delivery also. Thank you so much, Sir. May I ask please, if I have a folder for Classes, folder for Traits, another for Interfaces, how do I represent them in the psr-4 section of the composer.json file for autoloading? Can this load a functions.php file from a functions folder too?

  • @bhumit070
    @bhumit070 Рік тому

    Will this still work if we use LIKE operator for querying data

  • @harshmishra4943
    @harshmishra4943 Рік тому

    Thankyou very much 👍🏼👍🏼👍🏼 well done great job

  • @photoclubio2577
    @photoclubio2577 Рік тому

    Now i finally understand it. This is by far the clearest explanation video for the start with composer and namespaces! Thank you!

  • @ps5clipx
    @ps5clipx Рік тому

    Thank you for this

  • @emekatimothyiloba699
    @emekatimothyiloba699 Рік тому

    Nice Explanation

  • @ltybc425
    @ltybc425 Рік тому

    Can you get access to that index table from MySQL console? Where is this B-tree stored?

  • @falentinodjoka6732
    @falentinodjoka6732 2 роки тому

    I've tried your tutorial, but it does not give me an effect. I don't know why, but maybe cause my table only contain 2035 rows data, so i can't feel the effect of index. Can I get that table please? I wanna try it on my localhost.