1
00:00:00,180 --> 00:00:01,390
Hi, welcome back.

2
00:00:01,620 --> 00:00:09,030
In this video, we will learn how to load a database using PostgreSQL and Python.

3
00:00:09,150 --> 00:00:17,880
So the very system we will use C and D to install psychobiology to Python, big package and the following.

4
00:00:17,880 --> 00:00:19,980
So we Orbin seemed.

5
00:00:21,440 --> 00:00:31,610
Then type in stall psychobilly, too, as the following, then run the comment by clicking Enter this,

6
00:00:31,610 --> 00:00:36,130
will install the package and get and get all things OK.

7
00:00:36,290 --> 00:00:39,680
As you see, I have already installed the package.

8
00:00:39,770 --> 00:00:45,190
Now we will use the lab to import and use your admin.

9
00:00:45,290 --> 00:00:48,500
So import psychobilly to as busy to then.

10
00:00:48,950 --> 00:00:57,200
And the second cell connect will be to connect between two brackets database equal airlines between

11
00:00:57,200 --> 00:00:59,150
two entities and user between two.

12
00:00:59,190 --> 00:01:08,360
Parenthesis must address password and board use specified and during installation of PostgreSQL server

13
00:01:08,380 --> 00:01:15,980
called Equal Contact Causers then call Baudot execute between two brackets and two parentheses select

14
00:01:15,980 --> 00:01:23,900
extracts from ticket underscore flight table close parenthesis, close bracket then caudate which many

15
00:01:23,900 --> 00:01:32,210
for the first five records of Ticketfly table call dot which many between two brackets to winning.

16
00:01:33,860 --> 00:01:39,620
This will return the first twenty records from Ticketfly table.

17
00:01:40,610 --> 00:01:49,520
Then if we want to return the first ten rows we will do the same per dot feature many ten records that

18
00:01:49,520 --> 00:01:52,460
will return the first ten records.

19
00:01:53,150 --> 00:02:02,480
Then if we want to fetch all records from Ticketfly table or return or record from Ticketfly table,

20
00:02:03,500 --> 00:02:05,520
we will add all to Fitch.

21
00:02:05,690 --> 00:02:10,730
So caudate which all between two brackets nothing.

22
00:02:10,730 --> 00:02:18,410
It will fetch all the records from Ticketfly table and so on.

23
00:02:51,390 --> 00:02:52,560
Thanks for watching.

24
00:02:52,710 --> 00:02:54,540
See you next with you.