Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
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
00:17
by allowing you to diagram your database schematic and then
00:21
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.
00:35
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
00:52
10 tables per model. Of course, when working within this tear, you will want to keep those restrictions in mind
00:58
in case you start building a model where you've maxed out that
01:03
tables allowed in that model, then you'll have to upgrade to a, uh,
01:07
new plan or a better plan.
01:10
Now those that 10 tables for model will do just fine for the remainder of this course,
01:17
and I will continue to use the D B designer done that software when diagramming databases that we will then use in the lessons.
01:25
So the way these work is, for example, and DV designer done that if I log in,
01:34
I've been my log in credentials
01:41
and then click New Project. It'll take me right into the diagramming area.
01:46
So if I wanted to insert a new table would click the insert menu option
01:51
and then it would produce a table for me.
01:53
I was in Name that table like employees.
01:57
This is the employees
02:00
for the note.
02:01
Save that,
02:04
I'd add. It feels so you call that the i d Field?
02:07
Make that an imager.
02:10
Make that the primary key leave auto increment on, which means that
02:15
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
02:23
at another field.
02:25
All this one first name
02:30
and call this one bar char
02:37
string. It's nearly the same thing.
02:39
Var char 30.
02:44
Turn off the auto increment, allow Knowles safe,
02:49
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,
03:07
click the sequel button
03:09
and
03:10
selectee, create script, generate sequel,
03:15
download the file,
03:16
save the file
03:17
and then that file contains this code. You would then run that code within D Beaver
03:23
Bye copy Paste or going through the D Beaver menus to run and execute the script.
03:30
So
03:31
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,
03:38
you'd get a table.
03:40
You name it
03:42
employees,
03:44
you would add to call him.
03:46
Call it I D.
03:49
Primary Key. It's already set to the manager
03:52
at another column.
03:53
First name
03:55
thing I like about Verte Bella's. It's more intuitive,
03:59
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.
04:06
March or 30?
04:09
No,
04:10
I typed it in. Don't need to select it.
04:13
So then the same thing you'd click the sequel button
04:16
you could generate.
04:18
You click safe,
04:20
you'd open it,
04:23
and again you can download this or copy and paste it into TV. Vertu been in Stan. She ate it.
04:28
So that pretty much concludes this lesson in this lesson. We just went over.
04:33
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.
04:51
A lot of times you can you can show the diagram to other programmers, and they'll
04:57
almost immediately understand
04:59
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,
05:11
so I hope to see you there. Thank you. Bye.

Up Next

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor