Get my free 2+ hour MySQL database course. Includes 17 videos to help you learn the essentials of MySQL. Click here to get the free course: https://simonsezit.leadpages.net/free-mysql-course/

Get the full course on MySQL for Beginners here:
https://www.simonsezit.com/courses/web-development/mysql-database-training-course-for-beginners/

During this video, learn about the importance of data types for storing data in your MySQL database.

Selecting the appropriate data type for column values will optimize disk space utilization and increase performance.

The general data categories into which all data types are organized are:
- Collections of characters -- strings -- or collections of bytes
- Numeric
- Dates and times

There are trade-offs in the use of VARCHAR and CHAR data types.
- VARCHAR will reduce disk space requirements
- CHAR are fixed length making string manipulation easier
- Index searches are ~20% faster on CHAR versus VARCHAR
- VARCHAR has overhead of 1-2 bytes

Watch the entire Learn MySQL for Beginners playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3ga_sHmm6-CmJjgwCAeTKgA

Learn how to use Bootstrap to create a responsive website: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hrmEpbse1aBHJg-KZtvN--

AngularJS playlist here: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h9reRQ9EYNg5M1Jh5L9BXZ

Java training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jWaSPfhJLz2ijcHo48tV7L

PHP tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hNpTfG8c6skQufGsCc7fjx

Dreamweaver tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gTZBNfW3FGkdacG5R3DZUZ

HTML5 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gUTFciNyJZKEVZTLqOWPNf

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)