WEBVTT

1
00:00:01.750 --> 00:00:03.909
in this section we're going to look at

2
00:00:03.909 --> 00:00:06.279
databases and the sqlite database
in this section we're going to look at

3
00:00:06.279 --> 00:00:08.020
that's included with the python
databases and the sqlite database

4
00:00:08.020 --> 00:00:10.809
standard modules now if we are going to use a
that's included with the python

5
00:00:10.809 --> 00:00:13.210
database in our programs it's very
standard modules now if we are going to use a

6
00:00:13.210 --> 00:00:15.040
important to understand specifically
database in our programs it's very

7
00:00:15.040 --> 00:00:17.650
what a databases is s think of a
important to understand specifically

8
00:00:17.650 --> 00:00:19.570
database is just an organized collection
what a databases is s think of a

9
00:00:19.570 --> 00:00:21.789
of data that can be used to store
database is just an organized collection

10
00:00:21.789 --> 00:00:24.100
information on a computer or access from
of data that can be used to store

11
00:00:24.100 --> 00:00:27.800
a web server over the Internet
information on a computer or access from

12
00:00:27.800 --> 00:00:30.410
also though if you've used an android or
a web server over the Internet

13
00:00:30.410 --> 00:00:33.140
iOS phone or tablet and run an app on one of
also though if you've used an android or

14
00:00:33.140 --> 00:00:35.239
those devices chances are really high
iOS phone or tablet and run an app on one of

15
00:00:35.239 --> 00:00:37.760
that a sqlite database has been used in
those devices chances are really high

16
00:00:37.760 --> 00:00:40.579
some capacity Android itself uses many
that a sqlite database has been used in

17
00:00:40.579 --> 00:00:42.649
databases to store things like your
some capacity Android itself uses many

18
00:00:42.649 --> 00:00:45.170
contact info text messages and your
databases to store things like your

19
00:00:45.170 --> 00:00:47.900
browser history search history is also
contact info text messages and your

20
00:00:47.900 --> 00:00:49.909
stored in the database which is how the
browser history search history is also

21
00:00:49.909 --> 00:00:51.920
Google search on your android phone if
stored in the database which is how the

22
00:00:51.920 --> 00:00:54.110
you've got one knows watching search for
Google search on your android phone if

23
00:00:54.110 --> 00:00:56.000
previously can then offer suggestions
you've got one knows watching search for

24
00:00:56.000 --> 00:00:58.040
anything that stores and retrieves
previously can then offer suggestions

25
00:00:58.040 --> 00:00:59.930
information can really be called a
anything that stores and retrieves

26
00:00:59.930 --> 00:01:02.149
database these days though the term
information can really be called a

27
00:01:02.149 --> 00:01:04.580
database is normally used to refer to
database these days though the term

28
00:01:04.580 --> 00:01:09.380
more structured data
database is normally used to refer to

29
00:01:09.380 --> 00:01:12.350
now vendor such as Microsoft Oracle and
more structured data

30
00:01:12.350 --> 00:01:15.049
IBM produce database management systems
now vendor such as Microsoft Oracle and

31
00:01:15.049 --> 00:01:18.320
based on a relational database over here
IBM produce database management systems

32
00:01:18.320 --> 00:01:20.869
data is stored in rows and columns with
based on a relational database over here

33
00:01:20.869 --> 00:01:23.270
a row corresponding to a single record
data is stored in rows and columns with

34
00:01:23.270 --> 00:01:26.179
and the columns representing the fields
a row corresponding to a single record

35
00:01:26.179 --> 00:01:28.429
that make up a record such as the name
and the columns representing the fields

36
00:01:28.429 --> 00:01:30.770
address and date of birth in the case of
that make up a record such as the name

37
00:01:30.770 --> 00:01:32.960
a person's record or stock number
address and date of birth in the case of

38
00:01:32.960 --> 00:01:35.450
description qty in a stock keeping
a person's record or stock number

39
00:01:35.450 --> 00:01:39.570
application
description qty in a stock keeping

40
00:01:39.570 --> 00:01:41.370
now theirs a huge number of database
application

41
00:01:41.370 --> 00:01:43.140
systems out there probably the most
now theirs a huge number of database

42
00:01:43.140 --> 00:01:44.970
well-known of the traditional databases
systems out there probably the most

43
00:01:44.970 --> 00:01:48.840
being sql server oracle and db2 the
well-known of the traditional databases

44
00:01:48.840 --> 00:01:51.870
Oracle own the Java language after
being sql server oracle and db2 the

45
00:01:51.870 --> 00:01:54.180
buying sum micro systems but they were
Oracle own the Java language after

46
00:01:54.180 --> 00:01:56.369
originally created as a database company
buying sum micro systems but they were

47
00:01:56.369 --> 00:01:58.650
now these traditional databases
originally created as a database company

48
00:01:58.650 --> 00:02:00.600
typically use structured query language
now these traditional databases

49
00:02:00.600 --> 00:02:03.960
shortened to sql or SQL depending how
typically use structured query language

50
00:02:03.960 --> 00:02:05.880
you want to pronounce it and use these
shortened to sql or SQL depending how

51
00:02:05.880 --> 00:02:07.890
for performing or use a sql for
you want to pronounce it and use these

52
00:02:07.890 --> 00:02:10.619
performing operations such as query and
for performing or use a sql for

53
00:02:10.619 --> 00:02:13.350
updating data but is now also a growing
performing operations such as query and

54
00:02:13.350 --> 00:02:15.840
interest in no sql databases used for
updating data but is now also a growing

55
00:02:15.840 --> 00:02:20.830
storing and processing big data
interest in no sql databases used for

56
00:02:20.830 --> 00:02:23.740
getting back to android the android
storing and processing big data

57
00:02:23.740 --> 00:02:25.120
operating system includes a public
getting back to android the android

58
00:02:25.120 --> 00:02:26.920
domain database engine called sqlite
operating system includes a public

59
00:02:26.920 --> 00:02:29.320
and Python includes support for
domain database engine called sqlite

60
00:02:29.320 --> 00:02:31.030
sqlite databases in the standard
and Python includes support for

61
00:02:31.030 --> 00:02:33.550
library now unlike traditional database
sqlite databases in the standard

62
00:02:33.550 --> 00:02:35.290
management systems such a sql server
library now unlike traditional database

63
00:02:35.290 --> 00:02:38.230
or oracle sqlite is completely
management systems such a sql server

64
00:02:38.230 --> 00:02:40.120
self-contained it doesn't actually need
or oracle sqlite is completely

65
00:02:40.120 --> 00:02:42.940
a separate server to run on now sqlite
self-contained it doesn't actually need

66
00:02:42.940 --> 00:02:44.920
was designed to be embedded into systems
a separate server to run on now sqlite

67
00:02:44.920 --> 00:02:46.720
originally actually missile guidance
was designed to be embedded into systems

68
00:02:46.720 --> 00:02:49.360
systems so it uses the sql language
originally actually missile guidance

69
00:02:49.360 --> 00:02:52.060
which makes it very easy to use if you
systems so it uses the sql language

70
00:02:52.060 --> 00:02:54.370
already know a bit about databases and
which makes it very easy to use if you

71
00:02:54.370 --> 00:02:55.780
it really means that you can move on to
already know a bit about databases and

72
00:02:55.780 --> 00:02:58.360
use another sql database or other
it really means that you can move on to

73
00:02:58.360 --> 00:03:00.760
databases once you've learned the basics
use another sql database or other

74
00:03:00.760 --> 00:03:05.560
of sql with sqlite
databases once you've learned the basics

75
00:03:05.560 --> 00:03:07.330
and getting back to the history of
of sql with sqlite

76
00:03:07.330 --> 00:03:09.550
sql it was developed originally from
and getting back to the history of

77
00:03:09.550 --> 00:03:12.040
Edgar F Codds work on relational
sql it was developed originally from

78
00:03:12.040 --> 00:03:14.410
databases in the nineteen seventies and
Edgar F Codds work on relational

79
00:03:14.410 --> 00:03:17.709
became an ansi standard in 1986 now
databases in the nineteen seventies and

80
00:03:17.709 --> 00:03:19.270
sqlite implements most of the
became an ansi standard in 1986 now

81
00:03:19.270 --> 00:03:22.300
features of sql 92 and although their has
sqlite implements most of the

82
00:03:22.300 --> 00:03:24.340
been for revisions of the standard since
features of sql 92 and although their has

83
00:03:24.340 --> 00:03:26.349
sql 92 includes everything needed
been for revisions of the standard since

84
00:03:26.349 --> 00:03:29.260
for most database tasks and just as an
sql 92 includes everything needed

85
00:03:29.260 --> 00:03:32.230
aside text messages on iphone are also
for most database tasks and just as an

86
00:03:32.230 --> 00:03:34.480
stored in a sqlite database so really
aside text messages on iphone are also

87
00:03:34.480 --> 00:03:36.040
sqlite is used quite
stored in a sqlite database so really

88
00:03:36.040 --> 00:03:40.569
heavily out there
sqlite is used quite

89
00:03:40.569 --> 00:03:42.370
now if you freaking out about now at
heavily out there

90
00:03:42.370 --> 00:03:43.810
the prospect of having to learn yet
now if you freaking out about now at

91
00:03:43.810 --> 00:03:45.040
another language
the prospect of having to learn yet

92
00:03:45.040 --> 00:03:47.469
don't worry sql is the language but
another language

93
00:03:47.469 --> 00:03:49.689
it's nowhere near as complicated as Java
don't worry sql is the language but

94
00:03:49.689 --> 00:03:52.060
or Python in fact you can actually do a
it's nowhere near as complicated as Java

95
00:03:52.060 --> 00:03:54.040
lot of database work with only the four
or Python in fact you can actually do a

96
00:03:54.040 --> 00:03:57.639
commands select insert update and delete
lot of database work with only the four

97
00:03:57.639 --> 00:04:00.879
if you are going to do a lot of database
commands select insert update and delete

98
00:04:00.879 --> 00:04:02.980
work then you will need to learn sql
if you are going to do a lot of database

99
00:04:02.980 --> 00:04:05.260
more fully than what we need here and
work then you will need to learn sql

100
00:04:05.260 --> 00:04:06.340
you'll also need to learn about things
more fully than what we need here and

101
00:04:06.340 --> 00:04:08.889
like normalization but the basics that
you'll also need to learn about things

102
00:04:08.889 --> 00:04:11.290
i'm going to cover will allow you to create programs
like normalization but the basics that

103
00:04:11.290 --> 00:04:13.689
that can do basic storage update and
i'm going to cover will allow you to create programs

104
00:04:13.689 --> 00:04:18.609
retrieval of information in a database
that can do basic storage update and

105
00:04:18.609 --> 00:04:20.590
so sqlite itself has been around
retrieval of information in a database

106
00:04:20.590 --> 00:04:23.199
since around the year 2000 it's a very
so sqlite itself has been around

107
00:04:23.199 --> 00:04:26.110
fast and very stable standalone database
since around the year 2000 it's a very

108
00:04:26.110 --> 00:04:28.900
in fact it's the most widely deployed
fast and very stable standalone database

109
00:04:28.900 --> 00:04:31.539
database engine in the world actually
in fact it's the most widely deployed

110
00:04:31.539 --> 00:04:33.099
close to being the most widely deployed
database engine in the world actually

111
00:04:33.099 --> 00:04:35.110
piece of software any kind which is
close to being the most widely deployed

112
00:04:35.110 --> 00:04:36.460
pretty impressive if you think about it
piece of software any kind which is

113
00:04:36.460 --> 00:04:38.800
so if you want to go and check out some
pretty impressive if you think about it

114
00:04:38.800 --> 00:04:40.990
examples of its use in justifications for
so if you want to go and check out some

115
00:04:40.990 --> 00:04:42.610
the claim that it's the most widely
examples of its use in justifications for

116
00:04:42.610 --> 00:04:44.710
deployed database engine in the world
the claim that it's the most widely

117
00:04:44.710 --> 00:04:46.930
check out....
deployed database engine in the world

118
00:04:46.930 --> 00:04:51.550
....
check out....

119
00:04:51.550 --> 00:04:53.620
you can also find more information out
....

120
00:04:53.620 --> 00:04:55.510
about sqlite that same website
you can also find more information out

121
00:04:55.510 --> 00:04:57.760
just visit...
about sqlite that same website

122
00:04:57.760 --> 00:04:59.470
or if you happen to have
just visit...

123
00:04:59.470 --> 00:05:00.940
been on the other pages click on the
or if you happen to have

124
00:05:00.940 --> 00:05:02.800
sqlite logo to get back there good
been on the other pages click on the

125
00:05:02.800 --> 00:05:04.150
information on that site you want to
sqlite logo to get back there good

126
00:05:04.150 --> 00:05:05.980
find out more about sqlite
information on that site you want to

127
00:05:05.980 --> 00:05:07.210
alright so let's start off in the next
find out more about sqlite

128
00:05:07.210 --> 00:05:09.010
video by having a look at some basic
alright so let's start off in the next

129
00:05:09.010 --> 00:05:11.440
database terminology for things like
video by having a look at some basic

130
00:05:11.440 --> 00:05:14.560
tables records and fields recordsets and
database terminology for things like

131
00:05:14.560 --> 00:05:17.170
why they're important and after we've
tables records and fields recordsets and

132
00:05:17.170 --> 00:05:18.880
done that we'll then move onto actually
why they're important and after we've

133
00:05:18.880 --> 00:05:20.830
using sqlite to create databases
done that we'll then move onto actually

134
00:05:20.830 --> 00:05:23.020
and store information but in the next
using sqlite to create databases

135
00:05:23.020 --> 00:05:24.610
video as i mentioned we'll go ahead and
and store information but in the next

136
00:05:24.610 --> 00:05:26.800
start looking at that terminology see
video as i mentioned we'll go ahead and

137
00:05:26.800 --> 00:05:32.550
you in the next video
start looking at that terminology see