1
00:00:00,500 --> 00:00:09,140
Hello and welcome to this lecture, where we are going to create a database and also table to start

2
00:00:09,170 --> 00:00:12,110
our data about the products.

3
00:00:12,560 --> 00:00:17,900
The first step is to open my school work bank.

4
00:00:17,900 --> 00:00:20,480
We installed the last lecture.

5
00:00:20,870 --> 00:00:26,150
We need to click this button to create a new connection.

6
00:00:26,700 --> 00:00:34,760
We call with products and there is no need to change any of the parameters here.

7
00:00:35,150 --> 00:00:45,530
See that we are connecting should these IP number, which means our local machine, we can test the

8
00:00:45,530 --> 00:00:46,400
connection.

9
00:00:46,910 --> 00:00:54,800
Now you need to Typekit the passwords you defines when you installed my Eskil server.

10
00:00:55,220 --> 00:01:00,200
So I will put the here my best words click OK.

11
00:01:00,650 --> 00:01:07,970
You can see this message that indicates that the connection was made successfully.

12
00:01:08,300 --> 00:01:18,800
If you have any problem about this connection, you need to make sure that the My ASCII server is running

13
00:01:18,800 --> 00:01:19,280
here.

14
00:01:20,660 --> 00:01:21,770
Now let's click.

15
00:01:22,010 --> 00:01:22,730
OK?

16
00:01:23,180 --> 00:01:25,910
We can't see this information here.

17
00:01:26,560 --> 00:01:27,560
Double click.

18
00:01:28,250 --> 00:01:31,850
And now we can create a new database.

19
00:01:32,150 --> 00:01:34,280
I will write with this code.

20
00:01:34,700 --> 00:01:37,790
Great database.

21
00:01:38,540 --> 00:01:40,790
I will call products.

22
00:01:41,120 --> 00:01:44,630
Then we can click this button here.

23
00:01:45,350 --> 00:01:51,620
See this mass safe that the database was successfully created.

24
00:01:52,370 --> 00:01:55,190
Now we can click Scan once.

25
00:01:56,200 --> 00:02:05,070
Refresh all, see, that's our new database is already created, we can see more information here,

26
00:02:05,080 --> 00:02:08,230
for example, there is no tables.

27
00:02:08,500 --> 00:02:12,880
Now we will create a new table, which we started.

28
00:02:12,880 --> 00:02:14,920
They thought about the products.

29
00:02:15,280 --> 00:02:17,140
You can double click here.

30
00:02:17,380 --> 00:02:18,550
See, that's now.

31
00:02:18,700 --> 00:02:27,940
The name of the database is in bolds, which indicates that all the components that we will buy here

32
00:02:28,390 --> 00:02:33,130
will be executives in these products database.

33
00:02:33,640 --> 00:02:43,870
Now let's type, create label products, and we need to specify each one of the columns.

34
00:02:44,260 --> 00:02:49,870
The first one product I did, it will be an integer.

35
00:02:49,880 --> 00:02:53,050
No, not no.

36
00:02:53,530 --> 00:02:57,220
And the type how to increment.

37
00:02:57,520 --> 00:03:09,220
It means that when we add products, should this table, each one will have unique I.D. and these unique

38
00:03:09,220 --> 00:03:15,100
ID will be generated automatically by my scale.

39
00:03:15,610 --> 00:03:20,980
Now let's define the next column product name.

40
00:03:21,640 --> 00:03:29,800
It will be very sharp with the maximal size of 50 sharp views.

41
00:03:29,830 --> 00:03:32,710
We are going to start storing data.

42
00:03:33,520 --> 00:03:43,540
Also not know this base that the product occupies in the truck floats.

43
00:03:44,230 --> 00:03:49,540
Not know the price of the product floats.

44
00:03:50,020 --> 00:03:51,070
Not to know.

45
00:03:51,460 --> 00:03:58,940
Now let's define a new column, which will be what quantity and we are going to start.

46
00:03:58,990 --> 00:04:06,610
How many units we have off each one of the products in our last implementation.

47
00:04:06,940 --> 00:04:10,060
We didn't concede there the quantity.

48
00:04:10,450 --> 00:04:20,700
However, a real company has many products and many units of each one of them, so we can consider the

49
00:04:20,710 --> 00:04:24,400
quantity to fast our genetic algorithm.

50
00:04:24,970 --> 00:04:36,490
Now we need to create the primary key constraint how we buy basic products product IP.

51
00:04:36,820 --> 00:04:39,490
This is the name of the primary key.

52
00:04:40,390 --> 00:04:47,440
Let's define here primary key equals product I.D..

53
00:04:47,680 --> 00:04:57,610
We are associating the primary key of this table with these two increments column here, which means

54
00:04:57,610 --> 00:05:04,000
that we cannot have, for example, two products with this same idea.

55
00:05:04,300 --> 00:05:09,070
For example, product one two, three four five and so on.

56
00:05:09,670 --> 00:05:13,540
Now we can select only this part of the codes.

57
00:05:13,900 --> 00:05:15,220
Click this button.

58
00:05:16,230 --> 00:05:20,130
We can see this green massage here.

59
00:05:20,850 --> 00:05:23,700
Let's refresh the data sets.

60
00:05:23,970 --> 00:05:26,850
And now we can see our table.

61
00:05:27,360 --> 00:05:37,530
If you want to visualize the data, we can type select all colors from products.

62
00:05:38,010 --> 00:05:41,340
Let's select only this part of the code.

63
00:05:41,790 --> 00:05:42,630
Run it.

64
00:05:43,050 --> 00:05:46,740
See, that's the table is empty now.

65
00:05:46,740 --> 00:05:52,960
When these two ads, each one of the products to this table should do that.

66
00:05:52,980 --> 00:05:55,650
We can implement and larger comments.

67
00:05:55,980 --> 00:05:59,190
Insert info products.

68
00:05:59,580 --> 00:06:02,190
We need to specify the colors.

69
00:06:02,730 --> 00:06:10,350
The first one product, name, space, price and quantity.

70
00:06:10,680 --> 00:06:19,560
We don't need to specify the first column because it will be automatically generated values.

71
00:06:19,800 --> 00:06:24,690
And now we just need to type the name of the products.

72
00:06:24,990 --> 00:06:39,390
For example, the first one refrigerator a day and the space zero point seven five one the price nine

73
00:06:39,390 --> 00:06:42,690
nine nine point ninety.

74
00:06:43,140 --> 00:06:51,690
And the quantity for this product, only one we can select and run this code.

75
00:06:52,440 --> 00:06:54,780
We can see the green message here.

76
00:06:55,320 --> 00:07:02,760
Now we can select and run these other codes to visualize the data.

77
00:07:03,090 --> 00:07:08,460
See, that's the first product is already added to this table.

78
00:07:08,880 --> 00:07:17,910
We can see the name, space, price and quantity, and we can see here products a day that was automatically

79
00:07:17,910 --> 00:07:18,780
generated.

80
00:07:19,260 --> 00:07:26,530
Now we need to copy and paste this same code to hear these separate Coleman's two ads.

81
00:07:26,550 --> 00:07:35,550
All the products that we were using before are we all just faced this code here?

82
00:07:35,910 --> 00:07:38,700
We already have all products.

83
00:07:39,030 --> 00:07:47,490
You can get these scripts in the course materials, so you don't need to type all this code.

84
00:07:48,330 --> 00:07:51,420
Now let's select all the codes.

85
00:07:51,660 --> 00:08:00,690
See, that's that are different quantities here, for example, one than two five one four.

86
00:08:00,690 --> 00:08:03,660
And so one, let's run these codes.

87
00:08:04,380 --> 00:08:06,340
We can see the green message.

88
00:08:06,810 --> 00:08:12,780
And finally, we can run these other codes to see the results.

89
00:08:13,140 --> 00:08:20,100
See that now we have all the products, according to our case study.

90
00:08:20,430 --> 00:08:29,550
And in the next lecture, we are going to create a new project in by Shaam and we will pass to the code

91
00:08:29,560 --> 00:08:31,410
that we implement as before.

92
00:08:31,890 --> 00:08:32,580
So there.