- 15
- 555 614
TechnoTrax
Canada
Приєднався 9 чер 2019
A web developer by profession. I love to code, play PC games, and play basketball.
Having spent all my professional life working with open source technologies, I want to share all that I have learnt over the years. I believe every programmer has a distinct way of coding, some even unconventional, and I want to share all that I have learnt.
I want to make videos on programming, How to’s, tutorials and maybe even some gaming.
Thank you
Having spent all my professional life working with open source technologies, I want to share all that I have learnt over the years. I believe every programmer has a distinct way of coding, some even unconventional, and I want to share all that I have learnt.
I want to make videos on programming, How to’s, tutorials and maybe even some gaming.
Thank you
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
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...
crisp explanation for a relatively difficult topic to understand/visualise
Its like am cheating on the namespaces explanation cause others don't explain the pattern in simple terms. thanks
I have no idea what I would do in my java programming class without watching this video. Great explanation, thank you!!!
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
After watching 5 other videos, finally I understand what indexing is. Thank you
amazing
Excellent! Clear and concise explaination for all aspects of autoloading in a single video. 👍
old but gold
Thank you.
When you find just the perfect explanation... Thank you man !
Which is your editor or client?
An AMAZING explanation. it was really helpful. Thanks for great efforts
It works! Thank you! It also works if you create a package first before creating a java class
Oops! I should watch this video very beginning to learn php autoload! Thanks for your kind explaination in all the way.
thanks alot
Excellent explanation . God bless !!
thank you sir for this beautiful video
hi. we are getting an FATAL error when we update any data. Can you please help.
Thank you Brother for this video.
Thanks sir
Thanks sir
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)
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
learn how to be a housewife and please ur husband instead
Its good, please make a tutorial on mysql cpu/ram configuration
Great video, explained very good!
Wow! It's awesome. Nice explanation. Thank Your for your effort.
this is not valid way to index to any varchar
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. 👍
Straight forward thank you
This explanation is extremely clear. Thank you so much!
Thanks! :)
That was a perfect explanation - many thanks
Glad it was helpful!
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?
clean tutorial
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.
I got this error (Error Code: 1071. Specified key was too long; max key length is 3072 bytes)
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.
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?
This has to be standard solution for sql querries, to be done automatically by the database software you use
Thanks a lot for this tutorial, you helped me a lot.
You're welcome!
Thanks for this tutorial :)
great tutorial
GRACIAS HERMANO, NO PUDE USAR ECLIPSE HASTA QUE VI TU VIDEO PA. SALUDITO.
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?
Will this still work if we use LIKE operator for querying data
Thankyou very much 👍🏼👍🏼👍🏼 well done great job
Thank you Harsh!
Now i finally understand it. This is by far the clearest explanation video for the start with composer and namespaces! Thank you!
Thank you for this
Nice Explanation
Can you get access to that index table from MySQL console? Where is this B-tree stored?
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.