1
00:00:00,570 --> 00:00:03,680
Hello and welcome to this video.

2
00:00:03,870 --> 00:00:14,130
In this video I will be introducing you to some of the key database concepts like database table relational

3
00:00:14,130 --> 00:00:20,580
database relational database management systems database.

4
00:00:20,790 --> 00:00:34,200
A database is a collection of organized information of data stored in a table it table stores information

5
00:00:34,320 --> 00:00:36,680
in rows and columns.

6
00:00:36,900 --> 00:00:50,400
Just like an Excel spreadsheet a relational database is a database with two or more related tables.

7
00:00:50,490 --> 00:00:55,400
So two or more of the tables must be related.

8
00:00:56,070 --> 00:01:07,380
A relational database management system also known as are DBI m.s. s for short it's software that manages

9
00:01:07,560 --> 00:01:16,130
the databases so relational database management system software that manages the databases.

10
00:01:16,530 --> 00:01:28,590
Examples include Oracle Microsoft secure server dbe to my school and a few others.

11
00:01:28,920 --> 00:01:32,770
This is an illustration of a database.

12
00:01:32,820 --> 00:01:35,260
The database is the blue cylinder.

13
00:01:35,460 --> 00:01:45,540
It has two tables at the table of fruits and table core vegetables both tables have got three columns

14
00:01:45,870 --> 00:01:48,690
and two rows.

15
00:01:48,760 --> 00:01:53,120
I see the name on the column I mean name uncoloured.

16
00:01:53,310 --> 00:01:55,720
They are afraid to ask columns.

17
00:01:55,770 --> 00:01:58,190
They've both got two rows.

18
00:01:58,350 --> 00:02:01,030
The rows are one and two.

19
00:02:01,170 --> 00:02:03,410
So these are refers to as role.

20
00:02:03,500 --> 00:02:04,430
Going this way.

21
00:02:04,540 --> 00:02:08,260
So everything in record 2 is known as a roll.

22
00:02:08,340 --> 00:02:18,210
So if I want to reference records from records from row number two I'll be talking about idae the name

23
00:02:18,390 --> 00:02:19,900
and the collazo or these.

24
00:02:19,900 --> 00:02:27,020
Here Brown Kiwi and two collectively known as is required from a roll.

25
00:02:27,330 --> 00:02:28,880
So book tables.

26
00:02:28,890 --> 00:02:38,940
I've also got some relationship they but have a column called Carla and the day tucked inside the kolok

27
00:02:39,210 --> 00:02:42,450
column are identical.

28
00:02:42,450 --> 00:02:48,170
You've got a colour green here you've got the colour green then you've got a colour brown and ikle of

29
00:02:48,180 --> 00:02:48,780
brown.

30
00:02:48,900 --> 00:02:52,730
So there is some relation between both tables.

31
00:02:52,860 --> 00:03:04,030
So this data base can be considered a relational database because it has two tables with a relationship.

32
00:03:04,440 --> 00:03:10,760
In this video we went through some of the key database concepts.

33
00:03:10,860 --> 00:03:20,520
By definition we describe what a database is is a collection of organize information of data stored

34
00:03:20,520 --> 00:03:21,530
in a table.

35
00:03:21,810 --> 00:03:32,700
A table stores information in rows and columns relational database database with two or more related

36
00:03:32,700 --> 00:03:37,610
tables and their relational database management system.

37
00:03:37,610 --> 00:03:41,300
This is the software that manages the databases.

38
00:03:41,610 --> 00:03:44,470
Thank you so much for watching this video.

39
00:03:44,700 --> 00:03:47,960
I hope the vehicule has been useful.

40
00:03:48,000 --> 00:03:49,530
You have a good day.

41
00:03:49,530 --> 00:03:50,560
Bye for now.
