1
00:00:05,600 --> 00:00:10,590
Here we've been since the last video we have done creating the table by using a square like tree.

2
00:00:10,650 --> 00:00:16,080
In this model we are going to create table with posterior square so for that one.

3
00:00:16,110 --> 00:00:19,470
First of all here had the item code from the last video.

4
00:00:20,380 --> 00:00:24,270
And now we go to the idea terminal but it's still not OK.

5
00:00:24,310 --> 00:00:25,870
Maybe it will get fixed by today.

6
00:00:26,910 --> 00:00:35,470
But we have determiner so let one first of all aim to give you a situation like the one that we have

7
00:00:35,470 --> 00:00:40,010
considered before like putting some stuff in your drawers.

8
00:00:40,060 --> 00:00:45,950
Then the procedure is like this but you need to go to a drawer open that one as you could do a process

9
00:00:46,150 --> 00:00:48,760
be sure and close Denman.

10
00:00:48,880 --> 00:00:52,690
Now what if I say you that you need to put the stuff in another drawer.

11
00:00:53,720 --> 00:00:54,740
How could you do that.

12
00:00:55,460 --> 00:01:03,500
So you need to again find it open open that one execute be sure and close Dedmon insured deposits is

13
00:01:03,500 --> 00:01:05,130
nearly safe.

14
00:01:05,210 --> 00:01:11,080
You need to go to the different bank like the position maybe in a different room different house or

15
00:01:11,150 --> 00:01:18,660
maybe somewhere else what I need to see you here is no not matter that what kind of database you are

16
00:01:18,660 --> 00:01:23,520
using the default one like this one or any other data.

17
00:01:23,520 --> 00:01:30,210
The ESC will light sorting the Eskil commands are seen because as I've told you a skill is just generally

18
00:01:30,660 --> 00:01:33,000
server query language so that will be same.

19
00:01:33,000 --> 00:01:35,440
The commands will be seen in all the cases.

20
00:01:35,580 --> 00:01:39,140
You just need to change the addresses of the databases.

21
00:01:39,330 --> 00:01:41,840
All the things will Boxee.

22
00:01:41,940 --> 00:01:43,980
Let me show you that million or so for that one.

23
00:01:43,980 --> 00:01:46,100
I'm just hoping this one and pasting it here.

24
00:01:47,670 --> 00:01:50,570
But before that one let me have a look at our database.

25
00:01:50,870 --> 00:01:57,860
So this elephant icon you will find on the launch pad like this one on the window bar individuals.

26
00:01:57,860 --> 00:02:04,220
So when you click that one it will open and if it did not go to that icon and create new P.G. For me

27
00:02:05,570 --> 00:02:10,570
then you will get a base like this one that you need to add to the password you had created.

28
00:02:10,580 --> 00:02:17,540
That is post G R E S I have created in my own okay and you will get this interface.

29
00:02:18,930 --> 00:02:23,940
Here to check your databases click on the servers so that it will expand and then you will find all

30
00:02:23,940 --> 00:02:25,620
of the databases that you have created.

31
00:02:25,650 --> 00:02:31,890
So here I have four databases that I have done here for simple examples like the one venue create a

32
00:02:31,890 --> 00:02:37,860
simple database how will you create first thing is just click on this database just like selecting like

33
00:02:38,010 --> 00:02:46,850
if I have selected this one tables this No no database go to object create database and then you will

34
00:02:46,850 --> 00:02:55,640
find options like this one name that and see the one we are going to take an example in this video data.

35
00:02:57,010 --> 00:03:06,690
Base or just data because we also have a database here save you will find here.

36
00:03:06,700 --> 00:03:11,190
This is an unpublished database so this will be game like these published.

37
00:03:11,220 --> 00:03:17,840
Then you get some data in that 1 after that it will appear like this one when you extend that one he

38
00:03:17,840 --> 00:03:22,000
will find different options out of each in schemes you will get your tables.

39
00:03:22,040 --> 00:03:28,100
Here we have this one tables below I did not have added something in that one but here in this one data

40
00:03:29,180 --> 00:03:34,920
I have created a basic example Dell table seemed like the one example we are taking.

41
00:03:35,000 --> 00:03:36,590
It causes two columns.

42
00:03:36,590 --> 00:03:45,690
Rule number Neiman Marcus so you can just create table by selecting table object and create table.

43
00:03:46,010 --> 00:03:51,380
But there is something weird you are not going to handle your database to a user who is using your program.

44
00:03:51,380 --> 00:03:55,610
Maybe use computer or some of it as you are not going to do this thing.

45
00:03:55,790 --> 00:04:00,160
So I'm going to teach you that how you can create table by using programming.

46
00:04:00,170 --> 00:04:07,100
Otherwise you would just do that one because you need to connect this program or your interface that

47
00:04:07,100 --> 00:04:09,140
you are going to build with your database.

48
00:04:09,350 --> 00:04:14,060
Not like adding the design database again and again and using the program.

49
00:04:14,210 --> 00:04:16,850
So we are not focusing on that letter that is but very easy.

50
00:04:16,850 --> 00:04:18,480
You can check that one.

51
00:04:18,740 --> 00:04:27,120
Now how we will do that the first thing you need to do here is just in your database you need to create

52
00:04:28,080 --> 00:04:33,230
a database in which you are going to enter this stuff like I have created a data tool right now.

53
00:04:33,570 --> 00:04:41,450
So I'm going to consider this one and now here on this one the disclosure I had just only change two

54
00:04:41,450 --> 00:04:41,840
things.

55
00:04:41,840 --> 00:04:44,950
First thing is the address of my new begins to draw.

56
00:04:45,470 --> 00:04:51,130
And second thing is this liberty because we are not working with Esko lied to right now.

57
00:04:51,500 --> 00:04:58,110
We are working with a different liability so that liability in this case is known as Psycho Beach too.

58
00:04:58,280 --> 00:04:59,980
So we'll be focused on dispelling.

59
00:05:00,050 --> 00:05:03,090
There is no edge in that one is just psycho beachy too.

60
00:05:03,620 --> 00:05:13,400
And there are more libraries also like PGA eight thousand and you can just google out libraries for

61
00:05:13,850 --> 00:05:26,600
interface with post jihadi esque aerial and you will find the alphabet mentioned the Python 3

62
00:05:29,780 --> 00:05:33,210
we just add bytes and not so with

63
00:05:37,630 --> 00:05:39,240
you.

64
00:05:39,800 --> 00:05:46,620
So here whenever you check annual diva site most of the cases they will be listed everywhere.

65
00:05:48,080 --> 00:05:56,450
Like this one cycle P G two that we're currently working with PGA thousand B by Post ask well.

66
00:05:56,540 --> 00:05:58,750
And there are a lot more.

67
00:05:58,760 --> 00:05:59,740
So we are going to work.

68
00:05:59,760 --> 00:06:07,790
Psychopath you do and this is a library considered one of the hardest to install because you will find

69
00:06:07,790 --> 00:06:10,110
an to install in that one.

70
00:06:10,520 --> 00:06:14,180
So we will go installing this one because this is not by default into a computer.

71
00:06:14,610 --> 00:06:19,280
And I will teach you a simple matter to avoid issues like this.

72
00:06:19,430 --> 00:06:21,940
Let me first give you the issue.

73
00:06:22,040 --> 00:06:28,960
Just simply you can install any library by using pip install psycho P.G. do.

74
00:06:29,060 --> 00:06:30,420
This is the name of the library.

75
00:06:30,500 --> 00:06:35,080
Just like the Metro Lucy won't be a hit return or rent on Windows.

76
00:06:35,180 --> 00:06:44,650
You will get collecting psycho package then loud chatter sewing showing some common Python failure with

77
00:06:44,650 --> 00:06:46,030
error code one.

78
00:06:46,130 --> 00:06:54,470
And also if you do something like P capital because the library name is with P Capital and psycho busy

79
00:06:54,470 --> 00:06:57,600
too you will again get this letter.

80
00:06:57,620 --> 00:07:02,290
But if you are getting this library installed in your computer then that will be very good.

81
00:07:02,300 --> 00:07:07,430
Just give us some part of this video of true up to which we are working on this one.

82
00:07:08,770 --> 00:07:10,500
Not for those who are getting smarter.

83
00:07:11,000 --> 00:07:14,310
Either they are on Windows and on Mac they will get DNA.

84
00:07:14,950 --> 00:07:22,370
So to solve this urgently the matters are just google out celebrities and search for that one and this

85
00:07:22,370 --> 00:07:23,700
will take a lot of time.

86
00:07:23,720 --> 00:07:28,060
Sometime you will not find the library and then many shows like the department.

87
00:07:28,610 --> 00:07:34,960
So I have a general and very simple solution for these kinds of issues.

88
00:07:35,090 --> 00:07:42,800
What you need to do is you need to work with Conda or against Anna Nicole's condom distribution is something

89
00:07:42,890 --> 00:07:48,200
that contains most of the libraries and every library will get installed in the condom distribution

90
00:07:48,470 --> 00:07:49,610
even if they are not good.

91
00:07:49,790 --> 00:08:01,040
In this one I mean also just do corner install and then just write cycle b g two.

92
00:08:01,130 --> 00:08:06,920
This is the reason even when I am working with the data science I'm doing colder distribution most of

93
00:08:06,920 --> 00:08:08,050
the time.

94
00:08:08,370 --> 00:08:11,720
So because this will install all the light it is dead.

95
00:08:11,930 --> 00:08:20,620
So you just need to wait for the file and it will collect it and install the LAPD would solving environment

96
00:08:22,330 --> 00:08:27,130
so I'm just skipping some part of this video and delay to get install and check if they have a deadline

97
00:08:28,560 --> 00:08:36,210
so you will get this option just cried why he didn't return it will extract packages and just take a

98
00:08:36,210 --> 00:08:38,120
little time maybe go with that.

99
00:08:38,430 --> 00:08:40,060
Now the libraries install.

100
00:08:40,620 --> 00:08:46,970
If you go to the Anaconda now we had this one all day long let me show something else.

101
00:08:47,130 --> 00:08:55,300
If you do Python 3 here that and tried to import psycho busy too.

102
00:08:55,380 --> 00:08:58,940
You will get this imported here now.

103
00:09:00,070 --> 00:09:05,830
This is really a very simplified the same you will get on the Jupiter notebook but it worked there so

104
00:09:05,830 --> 00:09:10,870
I did not need to show you that man now.

105
00:09:11,140 --> 00:09:12,300
One more thing here.

106
00:09:12,490 --> 00:09:18,610
In case you are getting more do not fun because maybe you will get this one even after installing this

107
00:09:18,610 --> 00:09:20,460
thing that the model is not found.

108
00:09:21,130 --> 00:09:29,880
So in that case what you need to do is first check on the Jupiter notebooks whether this one is installed

109
00:09:29,880 --> 00:09:30,330
or not.

110
00:09:30,540 --> 00:09:32,150
So it may be possible.

111
00:09:32,340 --> 00:09:34,320
It really get not installed in your computer.

112
00:09:35,280 --> 00:09:37,560
So do check all that man go to Ancona.

113
00:09:39,360 --> 00:09:41,270
And check into Jupiter notebook.

114
00:09:41,280 --> 00:09:50,970
Installing these like bridges by just import psycho PGD to shifted on they would get this sun inputting.

115
00:09:51,270 --> 00:09:54,160
Now what about those cases.

116
00:09:54,340 --> 00:10:04,450
Let me first close this note book a page because I need that but only know what to do in that cases

117
00:10:04,810 --> 00:10:11,590
because that may also be possibly two cases here will new to this one.

118
00:10:11,590 --> 00:10:12,400
You will get it.

119
00:10:12,430 --> 00:10:20,020
So just go to the anaconda files by right clicking here right click and not right click.

120
00:10:20,020 --> 00:10:27,610
Just come on and click them so that their files will be shown like this one and they are generally available

121
00:10:27,880 --> 00:10:37,770
in computer disk and you will find an idea of getting this one but you will find that Anaconda somewhere

122
00:10:38,310 --> 00:10:39,340
in your local drive.

123
00:10:40,710 --> 00:10:41,270
We had to.

124
00:10:42,130 --> 00:10:48,700
And in windows you have this one in local D C maybe because that maybe your windows drive.

125
00:10:49,210 --> 00:11:01,380
So in that one go to library search for site go P. G to they will find some folders containing the liabilities

126
00:11:05,360 --> 00:11:08,720
and getting these for does

127
00:11:13,960 --> 00:11:14,350
David.

128
00:11:14,380 --> 00:11:14,840
Here.

129
00:11:25,170 --> 00:11:32,910
I'm not getting this folder because mine is maybe stolen main P.C. because I'm getting no entity importing

130
00:11:32,910 --> 00:11:34,260
that in Python.

131
00:11:34,440 --> 00:11:39,030
So again for those who are getting added you will find these three folders there.

132
00:11:39,510 --> 00:11:46,300
I will try to include these folders with the modem because I'm not sure whether we can update these

133
00:11:46,300 --> 00:11:47,530
or folders one day.

134
00:11:47,670 --> 00:11:48,350
You read me or.

135
00:11:48,900 --> 00:11:53,790
But still I will try these or otherwise I will try to provide a link.

136
00:11:53,840 --> 00:11:59,180
So what do you need to do with these folders is just copy these folders to one end commodity and this

137
00:11:59,180 --> 00:11:59,680
procedure.

138
00:11:59,690 --> 00:12:06,410
I'm telling you by so much attention because this can be helpful in any case wherever you are getting

139
00:12:06,560 --> 00:12:14,110
issues in importing any library based them on desktop and just change here.

140
00:12:14,110 --> 00:12:22,720
The directory CDE desktop and then by turn 3.

141
00:12:23,100 --> 00:12:34,000
Import cycle PGD do Daily Eagle if I just remove these from the index top then in that case let me show

142
00:12:34,000 --> 00:12:34,660
that also.

143
00:12:36,700 --> 00:12:41,870
Just this this and this command delete and I will try this command again.

144
00:12:43,800 --> 00:12:46,400
Binds and 3 input cycle.

145
00:12:46,570 --> 00:12:53,600
And I'm getting no error so maybe my computer is a smart it has already installed this.

146
00:12:53,750 --> 00:12:59,870
So that's why I did not able to show you the errors but I hope you get that thing if you are getting

147
00:12:59,870 --> 00:13:02,260
the Arabs those who not getting them.

148
00:13:02,270 --> 00:13:07,970
This will be very good for them and you can apply this method again for any kind of issue with the libraries

149
00:13:08,000 --> 00:13:11,780
because installing labeled it is a simple concept.

150
00:13:11,780 --> 00:13:14,230
You do not have to provide much time for them.

151
00:13:14,450 --> 00:13:21,040
Now let me move to a creating a table so the cycle page is now installed.

152
00:13:21,170 --> 00:13:29,660
You also need to change this one with psycho beachy David Goldman and to also the last thing you need

153
00:13:29,660 --> 00:13:32,050
to change here is this headdress.

154
00:13:32,060 --> 00:13:34,090
That is the main part.

155
00:13:34,220 --> 00:13:37,940
So just remove this part and tried a few commands here.

156
00:13:38,510 --> 00:13:39,420
First of all.

157
00:13:39,650 --> 00:13:45,990
Any school library soda any school language common is all visited done in between quotes.

158
00:13:46,340 --> 00:13:49,260
So this is one of the things that you need to focus.

159
00:13:49,550 --> 00:13:51,800
Maybe I have also told you with creating the execute.

160
00:13:51,800 --> 00:13:52,160
Come on.

161
00:13:52,550 --> 00:13:52,930
They are.

162
00:13:52,940 --> 00:13:58,050
We have also done that one in quotes so make sure you are adding quotes them.

163
00:13:58,160 --> 00:14:02,070
After that when you need to pass a few parameters.

164
00:14:02,600 --> 00:14:07,310
The basic demonstration for that one is like when you have to draw it at your house then you are familiar

165
00:14:07,310 --> 00:14:08,900
with that one.

166
00:14:09,060 --> 00:14:16,010
Now just assume that is not possible however but still assume you have to put some down any door that

167
00:14:16,010 --> 00:14:18,770
is present at someone's as home.

168
00:14:18,770 --> 00:14:26,270
So you need to have their house address then they are users like who is the owner of that house and

169
00:14:26,270 --> 00:14:28,150
then the door entries.

170
00:14:28,280 --> 00:14:30,020
So let's begin with that.

171
00:14:30,080 --> 00:14:35,460
First of all database name just like the house address.

172
00:14:35,600 --> 00:14:41,420
We have data too and that will also be passed in courts and him.

173
00:14:41,510 --> 00:14:46,730
I have used double quotes and inside that when I'm using single quotes because if you will do double

174
00:14:46,730 --> 00:14:52,610
quotes here python will get confused with this one and this one it may consider this one as a closing

175
00:14:52,610 --> 00:14:59,450
of this one so use different kinds of quotes whenever you are using quotes inside quotes and finding

176
00:14:59,540 --> 00:15:06,750
using quotes here because we are not going to use your mind that but to be sure with that one coal mine

177
00:15:06,780 --> 00:15:08,220
is not required in the connect.

178
00:15:08,220 --> 00:15:08,570
Come on.

179
00:15:08,570 --> 00:15:15,520
Never so that's why I have told you focus always on commas in quotation marks only day will be the source

180
00:15:15,520 --> 00:15:20,640
of error in your program while working the databases after let me have this one.

181
00:15:20,800 --> 00:15:23,530
Then just to use a name.

182
00:15:23,680 --> 00:15:30,640
This is the go on you will all those required in any of the database the database name user name that

183
00:15:30,640 --> 00:15:43,310
is both key areas in the case then password complete password and that again boast G ideas after these

184
00:15:43,820 --> 00:15:46,640
three common things you need to pass do more.

185
00:15:46,730 --> 00:15:56,210
First one is known as the port which is if you remember we have 5 3 3 5 4 3 2 and oppose it from 5 to

186
00:15:56,210 --> 00:15:57,260
2.

187
00:15:57,410 --> 00:15:58,480
That is easy to remember.

188
00:15:58,950 --> 00:16:06,890
Hey forget food after that one last thing you need to pass host that are you working on line or you

189
00:16:06,890 --> 00:16:08,540
are working on local host.

190
00:16:08,720 --> 00:16:12,570
So here we are booking a local host so just local hosts.

191
00:16:12,630 --> 00:16:17,480
Also you will get this host if you are a plus about a safari they are this thing.

192
00:16:17,480 --> 00:16:18,200
Then you click here.

193
00:16:18,200 --> 00:16:24,050
This one is a local host not online one because you do not have as GDP people kind of address.

194
00:16:24,170 --> 00:16:26,010
The protocol is not included there.

195
00:16:26,630 --> 00:16:29,770
So this one local host get H1N1.

196
00:16:30,110 --> 00:16:31,640
So just local host.

197
00:16:31,640 --> 00:16:33,410
Now we are done with this.

198
00:16:33,530 --> 00:16:35,420
Just save this one.

199
00:16:35,750 --> 00:16:37,540
Go to terminal exit.

200
00:16:37,550 --> 00:16:40,380
This one now.

201
00:16:40,980 --> 00:16:42,200
Python 3.

202
00:16:42,890 --> 00:16:44,270
And what's the name of a whirlpool.

203
00:16:44,300 --> 00:16:47,420
I'm their DP to not be late.

204
00:16:47,480 --> 00:16:49,220
I hope I don't get an.

205
00:16:49,550 --> 00:16:50,810
They read all of.

206
00:16:51,080 --> 00:16:52,540
So decode is successful.

207
00:16:53,030 --> 00:17:03,210
If you now open your this door closed below that one but I think that one is a daily looking go to database

208
00:17:03,210 --> 00:17:03,690
too.

209
00:17:04,080 --> 00:17:12,800
So you have noticed this one now color is changed because we have some data that skims tables and in

210
00:17:12,800 --> 00:17:19,520
that one if you check the column there we have rule number name and marks the one we have included here.

211
00:17:19,520 --> 00:17:23,250
Rule number name and marks.

212
00:17:23,600 --> 00:17:23,810
So.