7 hours 36 minutes
Welcome back to model to databases. This is lesson to skim a design within that lesson. This is sub lesson 2.2 E. R. D. Software and this lesson. We'll take a look at common ear D slash d B designer software to really help expedite the development process. This suffer really helps
by allowing you to diagram your database schematic and then
automatically produced the code that produces the schematic you've drawn. Now there's software have used commonly in the past that's called Verte Bellow at the verger bello dot com domain.
However, following a free trial, you are required to pay a subscription to continue using the service. It is a good service. However, there is another competitor available. It has a much nicer starters, last free tear that allows for two database models with
10 tables per model. Of course, when working within this tear, you will want to keep those restrictions in mind
in case you start building a model where you've maxed out that
tables allowed in that model, then you'll have to upgrade to a, uh,
new plan or a better plan.
Now those that 10 tables for model will do just fine for the remainder of this course,
and I will continue to use the D B designer done that software when diagramming databases that we will then use in the lessons.
So the way these work is, for example, and DV designer done that if I log in,
I've been my log in credentials
and then click New Project. It'll take me right into the diagramming area.
So if I wanted to insert a new table would click the insert menu option
and then it would produce a table for me.
I was in Name that table like employees.
This is the employees
for the note.
I'd add. It feels so you call that the i d Field?
Make that an imager.
Make that the primary key leave auto increment on, which means that
when inserting new data into this table, you don't have to worry about the I D field. It will get numbered and maintained by itself, so we'll click. Save that
at another field.
All this one first name
and call this one bar char
string. It's nearly the same thing.
Var char 30.
Turn off the auto increment, allow Knowles safe,
and here we go we got a two column table with columns I D for the primary key and first name. Now, uh, most databases are going to get much more complex than this. This is just showing how you use this type of software. So let's say we have a whole diagram up here that we then want to export. Well, you would just click the export button,
click the sequel button
selectee, create script, generate sequel,
download the file,
save the file
and then that file contains this code. You would then run that code within D Beaver
Bye copy Paste or going through the D Beaver menus to run and execute the script.
if we went over to Verte Bello, have you happened to find yourself using this? It's a very similar process. You click the table button,
you'd get a table.
You name it
you would add to call him.
Call it I D.
Primary Key. It's already set to the manager
at another column.
thing I like about Verte Bella's. It's more intuitive,
like when you add new column in the previous one that you get the sense that you're overriding your first column even though that's not true.
March or 30?
I typed it in. Don't need to select it.
So then the same thing you'd click the sequel button
you could generate.
You click safe,
you'd open it,
and again you can download this or copy and paste it into TV. Vertu been in Stan. She ate it.
So that pretty much concludes this lesson in this lesson. We just went over.
I really need an useful tool to use while designing a database. And that's the E R D software that's available out there. It's definitely a good idea to get in a good habit of using this software. If you find yourself in a position where you're designing database schematics, is it'll really help? And the diagrams are not only useful for you.
A lot of times you can you can show the diagram to other programmers, and they'll
almost immediately understand
what's your building or what you're trying to establish with that diagram. Anyways, that concludes this lesson. I hope you enjoy it. And the next lesson we're gonna use this software to create some of the relationships we talked about previously,
so I hope to see you there. Thank you. Bye.
Penetration Testing and Ethical Hacking
The Penetration Testing and Ethical Hacking course prepares students for certifications, like CEH. This course ...
7 CEU/CPE Hours Available
Certificate of Completion Offered
This free course introduces the student to intermediate concepts found in the implementation and application ...
10 CEU/CPE Hours Available
Certificate of Completion Offered