APA ITU DATABASE ? Tonton ini 5 Menit Langsung Bisa DIJAMIN

Hi, welcome back to the Detektives channel. In this video, I want to explain about database understanding. From what is a database, types of databases, and how to make a good and correct database. As usual, in every video I only explain what I think is important for you to know. For things you want to ask or know but I don't explain here, you can leave questions in the comments column.

Okay, let's get into the main discussion. What is a database? Simply you can mean a database as a data storage place or a information storage place. There are several database products that you can use, including Oracle, MySQL, SQL Server, and Microsoft Access.

and of course there are still many cool products that you can use to be compared to the applications that you will make later. Database has several components, at least there are two components that you need to know. The first is Table and the second is Query. We discuss one by one. The first is Table. Table is a collection of data or information that is organized into a row

or record and column or field This is an example of a table shape The top line is black and filled with the title is a field while the next lines you can call a record In making a table, there are several terms that you need to know The first is a data type This data type is used to identify the boundaries or writing format in a field

For example, integer is used for a field containing numbers, then text or varchar is used for a field containing characters, letters or numbers, as well as datetime is used to record dates or times. Then the second, primary key. Primary key is a function to differentiate between one record and another record, or can be called a unique field. And the last is auto increment.

Autoincrement is a function that operates on fields that have integer data that is used to give automatically orderly values every time there is an additional record on the table. After you understand the table understanding, you need to understand a little about query understanding. Query is a syntax or command used to access and display data in the database system.

Query is divided into three types, the first type is Data Definition Language DDL is a SQL query method used to define data in a database With this query you can create a new table, change the table, or determine the table structure Then the second is Data Manipulation Language DML is a query method that is usually used to add

change or delete records on a table. Meanwhile, the third is data control language. DCL is a query method used to give the right to authorize access to the database to users. For this initial introduction, I think the basic understanding of the query seems to be enough, because after this I want to give other basic understanding that is not less important.

Next, I want to give a case study if we have a business, namely a drink shop. In addition to selling various drinks, of course we want our business to have a good data, whether it is internal data or data for external needs. Well, to be able to meet those needs, I usually start by analyzing the documents that we want to produce later.

For example, we want to produce a sales structure document like in the following image. In this image there are several information that you can see. The first is information about the date of the sales transaction, then what items are sold, then the buyer's name, and who is the cashier who is in charge. Well, the first thing we need to prepare is a database

For example, in the database we give the name "db_penjualan" Then in the database, we have to make several tables that function to contain all the data related to the sales transaction such as in the sales script The first table we make is the item table This item table will later contain the drinks list that becomes the sales list in our store After we make the item table, then we make the second table, namely the cash table

This table functions to support the employee list or cashier who is in charge of serving the buyer. After both tables have been made, we will make the last table, which is the sales table. In this table, we will later store all the sales transaction data such as when the transaction was made, what goods were sold, and who is the cashier in charge.

By making a database like this, we can accommodate our needs regarding data and making sales structure.

Okay, that's my video this time, I know this video is still very lacking, there is still a lot of material that I haven't explained yet, because it's difficult for me to explain it all in one video only. So from that support me by subscribing, liking, commenting, and sharing this video. Because that way I can be more excited to make the next videos. I'm Falah Nur, let's study.

Hopefully this video is useful for you, don't forget to like, share and subscribe, okay?