2.10 ERD Software
Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or
Already have an account? Sign In »
Video Transcription
00:00
>> Now, welcome back to Module 2 databases.
00:00
This is lesson 2, schema design.
00:00
Within that lesson, this is sub less
00:00
than 2.2 ERD software.
00:00
In this lesson, we will take a look at
00:00
common ERD/DB designer software.
00:00
It really helped expedite the development process.
00:00
The software really helps by
00:00
allowing you to diagram your database schematic and
00:00
then automatically produce the code
00:00
that produces the schematic you've drawn.
00:00
Now, there's software I've used commonly in
00:00
the past that's called
00:00
vertabelo below at the vertabrabelow.com domain.
00:00
However, following a free trial,
00:00
you are required to pay subscription to
00:00
continue using the service. It is a good service.
00:00
However, there is another competitor available that has
00:00
a much nicer starters/free tier that
00:00
allows for two database models with 10 tables per model.
00:00
Of course, when working within this tier,
00:00
you will want to keep those restrictions in
00:00
mind in case you start building
00:00
a model where you've maxed out
00:00
that tables allowed in that model,
00:00
then you'll have to upgrade to
00:00
a new plan or a better plan.
00:00
Now, those 10 tables per model
00:00
will do just fine for the remainder of
00:00
this course and I will continue to use the
00:00
DbDesigner.net software when diagramming
00:00
databases that we will then use in the lessons.
00:00
The way these work is,
00:00
for example, a DbDesigner.net.
00:00
If I login, [NOISE] type in
00:00
my login credentials and then click "New Project",
00:00
it'll take me right into the diagramming area.
00:00
If I wanted to insert a new table,
00:00
I would click the Insert menu option
00:00
and then it would produce a table for me.
00:00
I would then name that table like employees.
00:00
This is the employees for the notes.
00:00
Save that. I'd add
00:00
a field and say call that the ID field.
00:00
Make that an integer.
00:00
Make that the primary key, leave auto-increment on,
00:00
which means that when
00:00
inserting a new data into this table,
00:00
you don't have to worry about the ID field,
00:00
it will get numbered and maintained by itself.
00:00
We'll click "Save" that.
00:00
Add another field, call this one first name,
00:00
and call this one varchar, a string.
00:00
It's just nearly the same thing.
00:00
Varchar 30.
00:00
Turn off the auto-increment,
00:00
allow nulls, save, and here we go.
00:00
We got a two-column table with
00:00
columns ID for the primary key and first name.
00:00
Now, most databases are
00:00
going to get much more complex than this.
00:00
This is just showing how you use this type of software.
00:00
Let's say we have a whole diagram
00:00
up here that we then want to export.
00:00
Well, you would just click the "Export" button,
00:00
click the "SQL" button,
00:00
and select the "Create Script",
00:00
generates SQL, download the file,
00:00
save the file and then that file contains this code.
00:00
You would then run that code within DbVar via copy-paste
00:00
or going through the DbVar menus
00:00
to run and execute the script.
00:00
If we went over to vertabelo,
00:00
if you happen to find yourself using this,
00:00
it's a very similar process.
00:00
You click the "Table" button,
00:00
you'd get a table, you name it, employees.
00:00
You would add a column and call it ID, primary key.
00:00
It's already set to the integer. Add another column.
00:00
First name. [NOISE] Thing
00:00
I like about vertabelo is it's more intuitive.
00:00
When you add new column in the previous one,
00:00
you get the sense that you're
00:00
overriding your first column,
00:00
even though that's not true.
00:00
Varchar 30, no,
00:00
I typed it in, don't need to select it.
00:00
Then the same thing, you'd click the "SQL" button.
00:00
You click "Generate", you click "Save". You'd open it.
00:00
Again, you can download this or copy and
00:00
paste it into DbVar to then instantiate it.
00:00
That pretty much concludes this lesson.
00:00
In this lesson, we just went over
00:00
a really neat and useful tool to use while
00:00
designing a database and that's
00:00
the ERD software that's available out there.
00:00
It's definitely a good idea to get in
00:00
a good habit of using the software.
00:00
If you find yourself in a position where you're designing
00:00
database schematics is it will really help.
00:00
The diagrams are not only
00:00
useful for you, a lot of times,
00:00
you can show the diagram to
00:00
other programmers and they'll almost immediately
00:00
understand what you're building or what
00:00
you're trying to establish with that diagram.
00:00
Anyways, that concludes this lesson.
00:00
I hope you enjoyed.
00:00
In the next lesson,
00:00
we're going to use this software to create
00:00
some of the relationships we talked about previously.
00:00
I hope to see you there. Thank you. Bye.
Up Next
Instructed By
Similar Content
