Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,750 --> 00:00:03,840
‫Hold on, you didn't learn anything in the last video.
2
00:00:04,080 --> 00:00:05,650
‫Oh, boy, you're a tough cookie.
3
00:00:05,820 --> 00:00:09,650
‫Don't worry, we will get into more and more advanced topics later in the course.
4
00:00:09,660 --> 00:00:15,160
‫But let's finish our talk on database's because again, I want to connect the dots for us.
5
00:00:15,660 --> 00:00:22,080
‫We learned that a database is essentially a computer with some database software on top.
6
00:00:22,990 --> 00:00:28,930
‫In a way, if you've ever used something like Google Sheets or Excel, that's a database, right?
7
00:00:28,990 --> 00:00:30,610
‫It's a way for us to store data.
8
00:00:30,610 --> 00:00:34,360
‫And the Excel software allows us to manipulate that data.
9
00:00:34,630 --> 00:00:38,660
‫In a way, a pen and paper is a database as well.
10
00:00:38,680 --> 00:00:41,430
‫It's not digital, but it's a way for us to store data.
11
00:00:42,710 --> 00:00:52,430
‫Now, the reason we always see these images as database's is because of this, this is called drum memory
12
00:00:52,580 --> 00:00:55,130
‫and I'll link to this resource so you can read more about it.
13
00:00:55,320 --> 00:01:01,420
‫But back in the day before we had disk drives, this is how we stored data.
14
00:01:01,550 --> 00:01:03,440
‫It was called drum memory.
15
00:01:03,440 --> 00:01:05,510
‫And as you can see, it's cylindrical.
16
00:01:05,510 --> 00:01:12,740
‫And that's why for historical reasons, just like our save button on a computer is a floppy disk, this
17
00:01:12,740 --> 00:01:16,040
‫drum memory represents usually databases.
18
00:01:16,280 --> 00:01:19,870
‫But again, in this day and age, they're all just computers.
19
00:01:20,780 --> 00:01:28,730
‫So because a database is just a computer and some software, are there many different types of databases?
20
00:01:29,210 --> 00:01:30,440
‫Well beyond there are.
21
00:01:30,680 --> 00:01:33,290
‫I mean, we talked about Excel, right?
22
00:01:34,010 --> 00:01:39,450
‫Essentially, you can use a spreadsheet that you get in Excel to store data.
23
00:01:40,250 --> 00:01:43,640
‫So why don't we just use that for all companies?
24
00:01:43,640 --> 00:01:48,690
‫Why do we need something bigger, something like a database that we're going to talk about?
25
00:01:49,160 --> 00:01:53,870
‫You see, the problem with things like Excel is that eventually you'll get to a point where you have
26
00:01:54,080 --> 00:01:58,810
‫too much data where an Excel or a spreadsheet just can handle it.
27
00:01:59,360 --> 00:02:04,610
‫And on top of that, there are many things that databases that will learn about in this course will
28
00:02:04,610 --> 00:02:09,290
‫solve, such as making sure that database has integrity.
29
00:02:09,320 --> 00:02:13,220
‫So that is not everybody can just modify data or delete a database.
30
00:02:13,670 --> 00:02:17,780
‫You can store terabytes of data, you can combine different databases.
31
00:02:17,780 --> 00:02:24,260
‫You can automate steps and use programs to do some really interesting things that you might not be able
32
00:02:24,260 --> 00:02:25,580
‫to do on a spreadsheet.
33
00:02:26,030 --> 00:02:28,490
‫Again, something we'll cover later on in the course.
34
00:02:28,820 --> 00:02:32,740
‫But some of the most popular databases are here.
35
00:02:33,020 --> 00:02:41,750
‫This is just a fraction of the databases out there because data is so different, because every company,
36
00:02:41,750 --> 00:02:44,780
‫every user uses data in a different way.
37
00:02:45,290 --> 00:02:52,100
‫We have different databases that do things differently, and each one of these have pros and cons.
38
00:02:52,550 --> 00:02:57,200
‫Now, the beauty is that in this course, we're going to cover some of the main databases and way to
39
00:02:57,200 --> 00:02:58,040
‫interact with them.
40
00:02:58,040 --> 00:03:04,220
‫And later on, we'll learn about the pros and cons so you can decide which database you should use based
41
00:03:04,220 --> 00:03:05,110
‫on your situation.
42
00:03:05,630 --> 00:03:08,750
‫But let's take Kako Corp as an example.
43
00:03:09,320 --> 00:03:13,370
‫How would Kako Corp or a company use a database?
44
00:03:14,530 --> 00:03:20,740
‫Well, we mentioned that there's lots of data coming into a company and a company as big as Kako Corp.
45
00:03:20,740 --> 00:03:22,640
‫has a lot of uses for data.
46
00:03:23,500 --> 00:03:30,820
‫For example, you might have product managers and product managers always have to know the product that
47
00:03:31,090 --> 00:03:31,960
‫they are working on.
48
00:03:32,230 --> 00:03:37,240
‫For example, drones, they need to get data and learn about the products.
49
00:03:37,240 --> 00:03:43,270
‫Health, whether a product is working properly, learn from data, learn from different information
50
00:03:43,270 --> 00:03:44,830
‫to perhaps improve a product.
51
00:03:45,870 --> 00:03:53,910
‫You have things like marketers and marketers, you need to find out information from data you want to
52
00:03:53,910 --> 00:03:59,340
‫analyze business decision, give you insights about how to market a product.
53
00:04:00,260 --> 00:04:08,170
‫Or you might be a web developer, a mobile app developer that creates apps on phone or on the Web,
54
00:04:08,660 --> 00:04:15,710
‫and those apps usually have things like user signings or profiles that you need to store somewhere so
55
00:04:15,710 --> 00:04:22,580
‫that when a user comes back onto your app, they're able to reload their information or maybe they're
56
00:04:22,580 --> 00:04:27,590
‫playing a game and they need to start the game from their last saved location.
57
00:04:28,960 --> 00:04:37,000
‫You also have things like data analysts or data scientists that understand data, that analyze data
58
00:04:37,000 --> 00:04:44,710
‫of a company and make decisions such as perhaps even building machine learning models so that a company
59
00:04:44,710 --> 00:04:51,790
‫can serve better information to a user, better products to a user, analyze different parts of the
60
00:04:51,790 --> 00:04:58,240
‫company to maybe see which employees should get a raise, who to hire.
61
00:04:58,970 --> 00:05:03,760
‫And then you also have data engineers or database administrators.
62
00:05:04,060 --> 00:05:10,870
‫These are the people that actually help set up the databases and a company update software, install
63
00:05:10,870 --> 00:05:14,260
‫things, make sure that databases are connected with one another.
64
00:05:15,100 --> 00:05:21,490
‫They might use things like Hadoop, Facebook's Presto, Google's big query, Amazon Redshift and set
65
00:05:21,490 --> 00:05:27,040
‫up all this infrastructure in place for other parts of the companies to use databases.
66
00:05:28,280 --> 00:05:35,870
‫Now, as you can see, there's lots of data and more importantly, there's lots of different databases,
67
00:05:35,870 --> 00:05:40,350
‫different people in a company that use databases in different ways.
68
00:05:40,850 --> 00:05:41,720
‫But hold on a second.
69
00:05:42,050 --> 00:05:45,460
‫All this data is used differently by different people, right?
70
00:05:45,680 --> 00:05:48,470
‫Different operations, different options.
71
00:05:48,800 --> 00:05:52,180
‫Each of these people are interested in different parts of data.
72
00:05:52,670 --> 00:05:55,580
‫And this is why you're taking the course.
73
00:05:56,770 --> 00:06:03,010
‫You're taking this course because you want to hopefully be able to work in any of these fields, and
74
00:06:03,130 --> 00:06:09,610
‫the good news is that even though there's all sorts of databases, even though there's all sorts of
75
00:06:09,610 --> 00:06:17,140
‫jobs, one of the most common ways to work with databases to ask a database, a question what we call
76
00:06:17,140 --> 00:06:24,220
‫a query, to interact with it, to use that information that is so useful, we use ask you, well,
77
00:06:24,580 --> 00:06:29,430
‫a way for us to interact or communicate with that database.
78
00:06:29,440 --> 00:06:31,350
‫And that's what this course is all about.
79
00:06:32,290 --> 00:06:34,360
‫Let's take a break and I'll see you in the next video.
8770
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.