Create MySQL Database - MySQL Workbench Tutorial

Upgrade your Clever Techie learning experience:

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments - easy to learn and understand code
2. Weekly source code file updates by Clever Techie - every time I learn new things about a topic I will add it to the source file and let you know about the update - keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments - skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary - memorize and review previously learned code faster
4. Organized file structure - access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace - no more searching around for previously covered material and source code - save enormous amount of time and effort
5. Outline of topics the source file covers - fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples - interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie

Download this video's source code and additional files here:

`````````````````````````````````````````````````````````````````````````````````````````````

We model a MySQL database using a diagram in MySQL workbench. We then forward engineer the diagram to create MySQL database on the server. MySQL workbench is a powerful tool for modeling and creating databases and we take advantage of it's relationship tool to create many to many relationship between our main movie table, and stars, directors and genres tables. I don't go into too much detail on how the relationships work in this video on purpose, I wanted to make a general overview of how MySQL workbench can be used to quickly created the model of a database with relationships between tables.

[FacePalmProduxtnsFPP]

That is so awesome! I love that someone created the GUI interface and forward engineer option!

[gatorslife]

YOU ARE A GOD! Thank you so much for making this video. I have been struggling for 4 days trying to figure out how to connect to my own database using a java connector and I think this may just be the key I was missing. thank you SO much! *HUGS*

[RosnerTheWriter]

I don't know the first about SQL or databasing or anything but I am able to follow your video and I appreciate the time you've put in to these videos to make SQL accessible for lay people like myself.

[alexl]

This is helping me pass a class in uni. I'm working on a database about boardgame tournaments, so it's different but if I pass this class, it's gonna be in large part thanks to this video. All the kudos to you.

[albertolopez]

Im trying to get a webserver database running for my android app and This is exactly the info I've been looking for! Thank you so much, you're a great teacher! 😁

[GreatAdib]

extremly usefull saved my day tomorrow is my final lab mysql exam on database management

[sahin]

It is incledible! Great tutorial and great presentation. I have a project with about 50 tables and many relationships. I bumped into your video and solved all my complexity problems with that! Many, many thanks to you. :)

[patriksamju]

I learn fast on your way in tutoring us on "HOW TO" on stuffs, very easy and concise.

[EdwinSepulvedaLE]

You really explained this course super excellent, thanks.

[hemendrasahu]

Good way to teach about many to many relationship between database table. Thank you it helped me

[iliyaniliev]

Sir, you are incredible and you are shining beam of humanity's essence - sharing with others and caring for them!

Amazing, amazing video!

[aigbekennethomorodion]

Great presentation style! Very helpful, thanks.

[durianjaykin]

thank you so much, needed a quick revision and you really helped me out

[jdtaylor]

Oh bless you 🙏🏾 May you continue to be a light in the dark places . Tysm

[sarahmoreels]

Ty so much! you are great at explaining!

[almogklinger]

great video very helpful and sufficient ! thx !

[johnnybegood]

Thanks, Bro! It was really usefull tutorial

[TLOL]

thanks for this masterpiece i learned a lot.

[ILIILLLIIILL]

I didn't know that I can make relational database without fields that store the values of foreign table id.
Nice video.

[gromitbear]

thank you so much for this :) I have been looking to create a database of the movies on my Plex server. How would we go about inputting the data into the tables? Would we have to input all the movie, actor, director, genre information separately?