Short Class SQL Introductions for Data Analysis | MySkill

Hello friends. Good night.

Does my voice sound clear?

Friends who are already in the chat column

have also greeted each other like that. Listen,

Sis. Thank you, Sis Salsa, it sounds

clear. Okay, thanks guys

for the confirmation. I would like to

remind you that

tonight we will be holding a class that

starts at 7:30 PM.

So while you guys are still waiting, it's totally

fine to

prepare your combat equipment, maybe.

It can be anything, Sis. Is it

okay to drink coffee or drink tea or

something else? Cai, boba.

What's more, my friends like this, which

usually brings back their focus. It's

definitely okay to prepare because we

still have 10 minutes left

before eating. Well, you can eat maca

with

ice, it's really delicious, right? Or

warm maca is also good for tonight.

Okay, I'm here but I want to get to know my

friends first. Friends,

friends, with friends

who are present here. What do you think your

friends' current status is

so it's easier to call them? Should I

call them Mas, Mbak, Teh, Kak, Bang,

or should I just call them friends? Of course you

can. Can we just spill the

beans,

Sis? Okay.

Ineng eh Inengah Retired.

What do you call her, Sis? I just

want to call him Kak. Sister Lulu PR

graduate, Sis is still a student. Fairus

mabaka. Wow, this is cool, Your Majesty.

Okay, Brother Yugi. Maybe some of you

know Kak Yugi or are acquainted

with Kak Yugi. Tonight there is Kak

Yugi Saiful U. What is his U? Ulala

maybe we don't know. Never

know, it's really okay. He said he was called His

Majesty, my friends.

Okay, here is Sis Fasya,

just friends, Sis. Okay, there's Sister Martina, a

student. There's Sister Salsya, Sister Ananda FR, who

graduated too. New Student Brother Hendarto Fresh Fresh

This Fresh is picked from the tree,

Brother. Here, Sis, there's a new student, Sis Asiraf or

Asraf, how about this, Sis, do you read it?

Press graduates Kak Ilham, Kak

Ferdiansyah. Just call me Honey, Sis. Oh,

positive thinking. The honey in question

is honey, friends. Then

there are also Mab students, Kak Ja, Kak

Lisander Fore. Okay, later Sis, you can

definitely prepare the fore if

you like fore coffee for me. If you like coffee, that's

fine, it's up to you,

whatever you want tonight. So that

our teaching this evening will be

better, it will go more into the brain.

Of course you can. There is Sis Lina, princess,

Sis. Ready, Princess.

Then who is there? Miss. Oh, Sis

Neng. Sis Nenga wants to be called Sis,

call her Ratu.

Oh my, Brother Onik is wearing a fresh graduate. Brother

Yugi wants his Majesty. Freshmen freshmen freshmen.

Ouch, Brother Lukman seems

a bit like Lukman Nur Hakim Cagur,

Sis. It's okay, Sis. There's still

next year. As long as the age is still

sufficient, capable, you can still try,

Sis. There's Sis, call me Sis. Okay.

Hello, Sis Anyya. There is Sis Adisah, a fresh

graduate. Sister Keizadiah called me madam, it was

so funny, I swear. Madam. Madam, what is

this? Madam Bamboo. High school, Sis. Oh, Brother Andi

is still in high school, friends. Call me

Princess, Sis. There's Brother Syah,

Brother. How many days will the service take?

Oh my, Sis Vivin, in the midst of us

joking around, Sis Vivin is still

asking for certificates. But it's okay, Sis

Vivin. I answered that the certificate would be issued no

later than 7 days after the form

was closed. So later, if

the form closes on the 15th, which is H+2

after this class, the test will

come out

7 days after the 15th, if I'm not

mistaken, that means the 22nd, right?

Just wait, my friend, there is Brother Farhan,

Brother. Okay,

we don't need to continue with the ones below that. Okay,

just friends. Okay. R graduate active student

proji. Active student proji.

What does that mean, Sis? Sorry, I'm a bit of a

student plus a housewife, Sis. Wow,

this is really cool, Sis Hikia Putri.

It means that you can manage your time very well.

There's Muhammad Ali, a final year student, right? He's

currently writing his thesis, right?

Scriptan.

Then there was Sister Alia who came from

Suriname. Where do you

think Suriname is, Sis? Just call me Bro, Sis.

Okay, there is Brother Ji Pratama. Let's call

Bro together, okay?

Call me Kim Tehyung, Sis. Just Kim

Tehyung

Jimin too. Princess K wkwk.

There is Sis Daska who wants to be called an angel,

bro King, I call her a princess at high school.

If registration is open, bismillah, bismillah,

Sis, I hope you will be accepted for your

dreams. My friends in

this class who currently really want to upgrade their skills

and this is what I want to be my

entry ticket to get a better career

.

Hopefully it will come true, friends.

Hopefully, it will be easier and

we can digest our material today and then become a

gateway to knowledge for a

broader, even better career. There's

Jini Sangian calling for jobs, Sis.

Jobjob Hipop's older brother's name is really cool

.

Hello, Sis. I'm Adinda. Hello, Sis Adinda

King. Okay, there's Brother Aprilian, we'll call him

King too.

Sis, will there be a link for the certificate later

, Sis? Okay, the certificate link is

usually for the certificate kim. I

will send it periodically every 10 minutes

or every 15 minutes in

this chat column. So, maybe later,

friends, where is the

certificate, where is the form, I will

send it here, maybe it won't arrive

in your email tomorrow, so it's

really okay to save it in

this chat column because it will be with friends.

Hi, Bro. Amen, Sis. Sis,

where do you get the minimum? I'll

share the details here later, Sis

. And after class, after the

explanation, I will explain later.

So. Will

there be a record of this later, Sis, on

YouTube? Yes, friends. Later,

I will also share the recording link

after class or during class

. So,

just monitor it later in case something is

missed. So, when I give you

important links, today's class link,

please save it. Maybe tomorrow,

"Sis, oh my, the email hasn't come in yet, it's

already 10 o'clock. It hasn't come in this morning."

Perhaps there are such cases. Later, my

friends will have a guide,

namely the class link that I gave you

tonight because it will be the same, right,

my friends.

Come on, Sis, it's starting to get impatient. Be

patient, Brother Muhammad Faktur. There are still

4 minutes left

according to the procedure, Sis. So

we'll start at 7:30 PM.

What will the task be like,

Sis? Is it okay, Sis Nabila?

I will explain the assignment later after the

presentation. So just stay tuned, sis.

Sis, this certificate doesn't appear

on the Myel website. That's right, Sis. Because for

example, if we share the certificate, we will usually

share it via the Telegram group.

Maybe some of you have

n't joined the Telegram group yet, where

we can get service information. You can

DM me on Telegram

later, I'll help you answer and

share the service link.

Hello, Sis. I am a PR graduate from the

Falak Science department. This is a total lie, Sis N.

I'm afraid it will be buried, Sis. I'll get the

links later, don't worry, friends. It

won't get buried because I will

send it every 10 minutes or every 15 minutes,

okay?

Sis, where is the FG FBJ background link

? I'll send it here too, Sis

. Just stay tuned, Sis. This is my

first time taking a class like this. I want to

ask, Sis. Is the Tibon uploaded

every class or just once, Sis?

Once a month, Friends.

So maybe some of you have

uploaded it in May and

now it's July and you want to take

all the classes in July. Is it okay to

upload it like that? But if,

for example, I joined in July and just

uploaded it yesterday and want to join the

classes in July, do I

need to upload it again, Sis? No need.

So, simply put, one wibon can be

used for 1 month. But if

the month has passed, is it okay, Sis?

Well, friends, you have to re-upload it

again. Oh, I see. Does

this mean training or

certification? Mm,

actually I can't answer this specifically,

friends. But maybe someone

can explain what training means.

If I were to get certification training,

maybe. Later, I'll try searching first to see

what the differences are. Because

Mimin himself doesn't

know the specifics.

Is there a deadline for submitting the assignments,

Sis? Yes, Sis. So H+ 2 after

this class is held, right? Kaktifnya ada masa

berwalainya tidak buat daftar pekerjaan saya.

No, Sis. As far as I know, we can use this certificate

as long as the knowledge is still

in our heads,

we can be responsible for the certificate, right? Sis,

the tibon is uploaded on Sosmate or on

Tiboniz. Oh yeah, don't get this wrong,

friends. Ee tibonnya is mandatory on

social media, not on WhatsApp.

Basically, on social media where

friends can be seen by the public,

for example Facebook, Instagram, Linkin,

Twitter and so on or TikTok is absolutely

fine. Except don't

post on Fibonac, friends, because it's the

same as not getting a

certificate. So we want Tibon

and Minitas to be posted on

social media. While waiting, we only have

1 minute left.

Sis, the tibon is indeed fresh grade,

Sis. My major is data analysis.

Ready, Sis. Sis, does the tibon have a caption

? There is, friends. Later when

you open the tibon, it will be there, but

if it's not there, you

can see it. Because, for

example, if there are captions there,

you can copy them or

adapt them as long as there is a

hashtag.

Okay, since it's already

19.30. You

can ask your questions at the end after

the presentation is finished, friends.

Especially for the technical class

tonight. So I'll just get started.

Asalamualaikum warahmatullahi

wabarakatuh. Hello. Om swastiastu. Namo

buddhaya and greetings of virtue. Good

evening, friends, whom I am proud of

tonight. Welcome back

to My Skill's Cass short class with

our theme tonight is

data science and analysis and the topic

is SQL Introduction for data

analysis. But before that, let me introduce myself, my name is

Kartika Simangkir. Friends can

call me Kartika or Tika. And

tonight I will be the moderator who

will guide our class

today. For those of you who are

joining MySkill for the first time and don't know

or are still unfamiliar with what MySkill is,

here I will explain a little about what

MySkill is. So

MySill is a skills development platform

with more than 2 million users

throughout Indonesia and is part of the top

Indonesian startup linkin from

2022

to 2024 and has been

certified by the Education Alliance

Finel. What can we get from My Skill

, Sis? In My Skill, we

can get more than 1,400

e-learning materials and portfolio projects.

There are also 12 intensive bootcams that

focus on practice, which will certainly be

very useful for training

your skills. Then there is the

CV review by AI. I will explain one by one,

okay? Well, but before that

, why do we have to choose My

Skill? Especially why we have to join the

full stack intensive My Skill, huh?

The reason is because more than 10,000

MySkill alumni have been accepted by

various top companies

in Indonesia.

For example, friends can see

photos of our older brothers, sisters,

brothers, sisters, brothers, or friends

on my screen

tonight. Starting from Kamanda who is in

awap, Kak Fata, Kak Stefano, Kak Syifa,

Fahmi, and many more who are

currently working in

top companies with titles

or positions that are no

less cool. The content is as a

data manager for the Ministry of Social Affairs of the

Republic of Indonesia as a social

marketing specialist in the beauty industry,

UIUX designer at PT Global Artisan Teknologi, UUX designer at PT

Permata

Indonesia,

intern Fiber Optic Drafter at PT Telkom

Access, and many more of course

for his companies not

only national companies but also

multinational or

international companies. Below there

are also several examples of

companies where

alumni work.

For example, we can see below that there are

Telkom Indonesia, Grab, Bukaka, Tix ID,

Amarbang United Tractors, Member of

Astra, Imuni, DBS, Ciputra, and of course

many more.

So, for those of you who are

really interested in practicing your skills or

deepening your knowledge in data

analysis, we have a full-stage intensive

bootcamp coming up soon, which

will be held from July 31st

to September 18th,

2026. What are the benefits? Well,

the benefit is that friends will join a

live class with our expert or narsun

. Then there is a real project

portfolio or original portfolio,

which will of course be very useful. There are

materials and class recordings, get

e-certificates and career preparation classes,

and access to over 1400

elearning videos. And then from

July 31st to September,

you will get more than 17

live online sessions and practice on

intro to intro to data analysis,

statistics in data analysis, data

formatting, data cleansing, SQL, Pown,

data visualization and many

more. By simply

joining myskill.id.botcam,

bootcamp. Friends, you can get a

15% discount with the promo code My

Skill 15. Payment can be made

via FIS or bank transfer. So,

where are the experts from, Sis?

The experts are of course from

top companies, friends.

For example, there are Pamar Persada

Nusantara

or Finansial Fim Niaga and

many more. Well, for friends, it's not

just a bootcamp, but we also

have a discount for e-learning by only

paying around IDR 40,000. Friends

can access the material for 6 months and

get material on digital

marketing, data science, human resource

development, and much more.

Don't forget to use the promo code

Jago Skill 6 and register at

myskill.id/alarning.

Payment can be made via

Kris or bank transfer.

Well, this is especially for those of you who are

currently still wondering, "Sis, I

've sent so many CVs, so many

applications to companies,

but why haven't I received any calls, Sis?" Oh, I see

. Especially for fresh graduates

or perhaps fellow

students who want to find internships or

friends from high school who also

want to expand their connections and

gain experience. This is the

solution. My Skill has a solution,

friends. So we can upgrade

our CV to be even better

with the CV review program by AI.

Friends, you can register for

this program with just 60,000 or so, you

can get seven

CVs in 2 months. Then, there will be

CV revision results, analysis of

the suitability of career choices and skills,

job recommendations according to

your CV, and application letters will also be made

based on your CV, and of course, there will

be interview practice, HR, and superiors.

And finally there are complete documents

for applying for work. It's ready in 5 minutes

. So, if you are

interested, you can use the

Reqc voucher code.

Well, there's something interesting here. Friends

who are joining MySkill for the first time

and have just found out that

we have a MySkill affiliate program,

perhaps you have some

venomous souls, you can definitely join us by

turning your connections and influence

into money. Another benefit,

friends will be given

ready-to-use promotional content. There is an

exclusive affiliate community and transparent commission tracking

. The commission is up to IDR

50,000 R000 per transaction. So, what are

you waiting for, friends, you can

register as a free affiliate at the

link below. Friends,

you can screenshot or type in case you are

interested or want to continue

registering. Or you can also join

our WhatsApp channel for updates on

our promotions and profit strategies via the

link listed on my screen.

Okay, next one. So, for those of you

who are still wondering what the

benefits are, what are the benefits

we get if we join My

Skill's class? My Skill short class. The

first thing that you are most

looking for is an e-certificate.

Then there are practical, practice and Q&A

with experts

based on case studies, practice in

creating a mini portfolio and also a

question and answer session. And in addition, as

I mentioned before, there are

discounts on bootcamp training, recordings of

class materials, and lifetime community

membership.

Well, for those of you who are still confused

, where can

we include our CV,

where can we

include our certificates? The

first one can be in your CV or you can link it to

your profile or post. For example, you can

see it on my screen on

the left. Later, you can just

enter the CP by entering the

bootcampik

skill period and certificate link as well as the portfolio link

or in the post or profile of the

LinkedIn post in the lense and

certification column. Don't forget to also

write down skills or bags

related to the certificates that your

friends have.

Well, this is what we've been waiting for.

Tonight we will be taught directly

by our expert, namely Ms. Hana

Rosuliana, who currently works as a

business data analyst at a Financial

Technology Company. Well, coincidentally

this evening Sis Hana is here

with us and

we are really welcome to say hello. Hello, Sis Hana.

Hello

Pratika and all my friends.

Hello, Sis. How are you

tonight, Sis?

Alhamdulillah, fine. Thank God,

Sis. Okay, without further ado,

Sis, because my friends also

really want to listen to the presentation

from me. I'll move on to the

next slide before you take

over, okay?

Okay, let's move on, friends, without

further ado, shall we? So, these are the

class rules that are absolutely mandatory

for Patuji friends

tonight. First, friends are asked

to mute the mic and disable

annotation. Then, the class recording

will be shared after class. So for

those wondering if the recording will be

shared? Yes, it will be shared,

friends, and the material will not be

shared with participants. So please

note down the important points or you

can study again later through the

recordings that we will share

later. Fourth, there is no

absence form. There is only a certificate form.

Where did you get it, Sis? Don't worry,

I will share it via the chat column and there will

be a QNA session or question and answer session

using Slido.

I will also send the link via the chat column. And

finally, friends are asked to be

100% present and focused on attending the class.

So, these are some of the steps to

get the e-certificate. The

first is to upload the wibon to

social media. Social media,

guys. It's not WhatsApp, nor is it a

private account, our social media

is publicly accessible, so when

friends include the link,

it's easier for Mykel's team to check

whether it complies with the provisions or not.

For the link, you can go to

tibonize.com/shortclasskelton.

Later, friends can

use the captions listed when

accessing the tubon or if you don't find them,

you can also copy and paste them or adjust them

to suit your needs. But

don't forget to include

hashtags like the ones below

. Next. Well, then later we will

provide a link to the minimum requirements independently

that you have to work on. When

working, don't forget to write

the name in the bullet point or in the

right corner like this, friends.

Then, after your friends have completed

their mini projects, they share them or post them

on social media. For social media,

you can use Linkin, TikTok, Facebook,

whatever you think is

public and

social media, you can share it

there and don't forget to include the

hashtag learn atmill. So, what must be

uploaded to our social media

are the results of minimal work,

such as the example on the side.

This is it. Meanwhile, the post that I will

send later does not need to be posted,

just do it in the form.

So, after you have fulfilled all

the rules above, you are

free to open the certificate claim link

. Well, there you will be

asked to upload the

twibon post link and its details. Don't

forget to include it, friends.

Share and copy links from

friends' posts. Here is the Twibon, then

here is the mini bag and also the

minitas file will also be placed on the ee form

later, okay? This will be closed H+2

after class. So, this is now on the

13th and will close on the 15th at

2359

and then for the certificate you will have

to wait a maximum of H+ 7 after the

form closes. So, H+ 7 after the 15th

.

Finally, we would like to remind

you to always be wary

of suspicious messages claiming to be

from MySill, such as

those inviting you to make sales, affiliate offers,

and so on, outside the

official MySill platform. If you receive

these messages, please

report them to us via WhatsApp

or the official my Skill Telegram

below. So, there are three official or

official contacts from My Skill, namely

WhatsApp customer service, official

Telegram customer service, and official

Telegram Mycale. Don't forget to capture

or screenshot it in case your friends

need it. Losses

arising from messages from

external parties that are not affiliated with

Meskill are not the responsibility

of Well, next, friends, you are welcome to

take out your cellphones

tonight, we share our productive activities

on our respective social media and don't

forget to include

#learn@mskill and don't forget to tag mein

my scale on Instagram, TikTok,

Linkin or Twitter. next. Well,

since we've come to the end,

I'll just send it or

hand it over to Sister Hana for

further material. Please, Sis Hana.

Hello, thank you, Sis Tika.

Okay, I'll try to share the screen first

.

Yes Is my screen visible yet,

Sis?

Okay, Sis.

Okay, ready. If so, I'll get started,

Sis. Sorry, let's slide show for a moment.

Okay.

Okay. Can you see it, Sis? My share

screen

looks very clear, Sis.

Okay, ready. Hello, good evening everyone.

Good night friends.

Hey, welcome to the Introduction

to SQL class. First of all, let me introduce myself here,

my name is Hana.

Hey, currently I'm a data analyst, you know

. Well, tonight we will learn

about SQL. Ee, I hope that from

tonight's class, my friends will learn a lot of knowledge that my

friends can learn and that will be

useful for my friends in the

future.

Hey, for example, if I saw earlier, yeah,

yeah, when I was still interacting with

Kartika, she said that there were still many

students, some were still in high school,

yeah. So I assume there are still a

lot of beginners here and of course, don't worry

because this class is

really suitable for you.

So, there's no need to worry for

those of you who have never used SQL, who

have never known what SQL is

like before. ee we will study

tonight like that. So the goal

of the class is for friends to understand, ee,

what the basic concepts are, starting from what a

database is, what SQL is, and then ee,

why SQL is important. Until

finally, friends will also learn

how to write queries like that. Later

in the last session, we will also have a

practical session, okay? We will try to

write a query live together so that our

friends will have an

idea and can

try it out straight away.

Then ee ee before we start, also from

me, ee, if it is possible,

friends can join the class

using a laptop or PC because later

we will have a practical ee and it

will be easier if

friends use a laptop directly.

So we can try it together right away

. Maybe that's all before we

start, I'll move on to the next slide.

Okay, let's get straight to it. So, before we get

into SQL, we have to understand first that there is something

called a database.

What is a database? So, in simple terms, a

database is a collection of data

or information that is stored in a

structured manner.

For example, in our

daily lives, we often find data

in the form of tables. For

example, student data or there is also

transaction data, customer data or

maybe also data from our short class participants

tonight. All of that, ee,

is data and we definitely

find it in our

daily lives. There must be data for everything

and it is recorded in the data.

Well, in our spreadsheet, the

data is in the form of a table, we

have rows and columns. In the database it is

also the same, usually it is arranged in the

form of a table, where each row

represents one data or one

record.

Meanwhile, each column will

represent certain information.

Well, for example, if

there is a student table, we

can have columns such as student ID, the

student's name, and

also information such as

blood type, IP, and even date of

birth. It's all stored in

columns and ee later, for example, the

student's name will be in one row, that's the

data. Well, if

the spreadsheet is usually used for

relatively small data, or

also manually, if the database is

used for

larger data, that is already

larger. Apart from that, we also frequently access the data

and need to use it by

many people at the same time, you know, it

's used all at once. Therefore

we will need a system. So

we need a database, we

can no longer use simple data

in spreadsheets

. Then next.

So, why do we need a

database? What are the actual benefits

of using a database?

Well, of course there are many benefits. The

first one is that the database will

process it. By using the database

we can process data to be

[clears throat] easier and also

faster.

Why is that? Because in this database, the

data form will be

structured like that. So we

will process it more easily and

also ee if for example the data is small

maybe the spreadsheet is still enough.

But if the data is already in the thousands, millions

, or even tens of millions of rows,

we need a more robust or

structured system.

Secondly, the database is ee with the

database data integrity is

better. This database will help us

maintain data integrity. So, the

stored data will be neater and more

valid, and it will not be easily damaged

, because it is stored properly. So,

even if we process ee data

many times, we process it a lot

or it is accessed by many people, the

data will still be stored

properly and ee is safe. So it won't be

damaged or anything. Then also the

third one, with the database data that

we have, what we store

will be more consistent. For example,

customer data, for example, we have

several data, such as

customer data or transaction data and also

product data, we can then

connect them to each other and

the results will definitely be consistent

because there is already a table that maintains

each of these data. And

what I said earlier is that the data

will not change even if we process

or access the data many times and

simultaneously.

Ee next, the last one is

the benefit of the database, also with the

database we have

more efficient storage.

Hey, so we don't need to

store a lot of data, repeatedly in

many places. For example, I want to wear it,

and for example, there is Big Sister Tika who wants to

wear it too. That's enough for us to save it just

once. but we

can both access it. Those are the

benefits of databases. So, it's

based on those benefits, right? We

have seen that

this database is very powerful and very important

because almost all modern applications

now also use a

database behind it. Okay.

So, now that we understand databases,

let's move on to the relationship

between databases and SQL, shall we?

So, the database is the place where the

data is stored. While SQL

is the language we use to

interact with the data. So,

I'll repeat maybe one more time, okay? So,

the database is where the data is

stored. Meanwhile, SQL is a

language that we use to

interact with ee data.

Maybe you're still

a bit confused from the definition. I'll try to continue first.

So, if we want to

retrieve data, for example, or

change it, add it, delete it, or

interact with the data, we

use SQL. So SQL is a

communication tool.

Firstly, there is another term called DBMS

. So what is DBMS? In BMS,

it is a system that manages the database

. So the database doesn't

run alone. There's someone

who manages the database, right? So no no

no just standing alone. There is a

system that manages what we usually

call a database management system or

we shorten it to BMS.

Okay, in this BMS ee with BMS ee will

allow its users

to create, access,

or manipulate databases. So, for

example, the database is the

storage place.

Okay, if the database is the

storage place, then in BMS

we can think of it as the guard, the

guard or manager of

the storage place. So, for example, we

are users, we as

users use an application,

right?

Well, this application doesn't directly

manage data like that, manage data

or files manually, but

this application will connect and

communicate with eh sorry and

communicate with the BMS.

Well, then in the BMS this is what will

manage the ee process to the database.

So, the way I try to repeat it once

again from the user or we the users

will use an application and the

application will definitely ee ee by

using the application the application

will definitely access the data ee so that it

can run where the data is

stored in the DBMS.

So, in this BMS, we will

manage the process from the database.

So that's more or less how it

works. For example,

if we open an

e-commerce application, and we

want to see our order history and see

what we have ordered, the

application will request the database

via DBMS to see the

transaction data that we want to see.

Only after the application

gets the data, it displays it in

the application, displays it back on

our screen. So in this BMS, ee plays a role

as a manager and liaison between

users, applications, and databases.

There are many BMS that are used like that, right?

Some popular examples

here are MySQL, Postgra SQL,

SQL Server, Oracle, and

other databases. Ee

[snort] actually in

principle each BMS

has a similar function, namely to

manage the database. But usually

the difference is only in the syntax or in the

detailed features. Well,

but specifically in this class we

will try the most common approach

or one that is starting to be understood, okay?

Hey, later for practice we will

use SQL which is also free and we can

access.

Okay,

now we come to the

main question, what is SQL? So SQL

stands for structured query

language. So this is a

programming language that is used to

access, change, and manipulate

relational-based data. So SQL is a

language, the way we

communicate is SQL.

Well, eh, SQL is known to follow the

American National Standard

Institute or ANSI Standard which is used in

relational database management.

like that. There are three main types of operations

in SQL. The first is creating an

object in the database, which we usually

call a data definition

language.

Furthermore, there is also taking data

from the database or also called data

query language and also changing data in the

database, namely data manipulation

language.

Well, for beginners,

we usually use it most often

in the data query language, right? So

we usually take

data using silect, I'll

start bridging a little bit with

the queries that we'll use

to write later.

Okay,

next. So in SQL, there are several comments

that we usually use

to create this database, there are three

comments. The first one is create. Create

this if for example we want to create an

object like that. So, the objects in the

database are databases and then there are

tables too. So, for example, if we want to

create something, then we use the

create command. For example, if

we want to delete it, we can also

use the drop command and if

we want to change the object, there is the

alter command.

Then ee next type of comment

get. So to take it

, to take the data,

we usually use select. This is what

will be used most often by data

analysts or business analysts.

Then the last thing for the

SQL comment is changing or manipulating.

There are three comments here, namely insert

to enter data, continue update

to change data, and delete to

delete data.

OK,

next we'll get into the

SQL functions.

So in general, SQL has two

functions, namely to change or

access the database or perform the

required queries.

And also the second ee functions as a

link between applications and

various databases. For the

first one, ee changes or accesses

it, for example, if we want to see

how many transactions there are this month. Then,

for example, if we want to calculate

sales, how many are there per city

? For example, how many

sales are there in Jakarta, how many are there in Bandung,

for example, if we want to find out who the customers are who

make the most transactions

. it is a SQL function that changes

or accesses. Then, if the ee

functions as a link between the

application and the database, for example, it's

like when we log in to the application.

Well, later the application will check the

user data in the database. So when

we make a transaction, the transaction data

will be saved by the ee application in the

database. So, SQL is

not only important for

data analysts, it is not only important

for retrieving data, but it is also

important for developers, data engineers

or many other professions who

use ee data to work.

Next, we will go into the

SQL data type. So, here SQL

has many data types, right? So it's

not just about the data, it's just like

okay, just name, phone number, and

also the date, that's all. But we

have to know what the data types are

like and what their definitions are

. So for that data type,

there are three big data types, right?

So the first one is character,

numeric, and temporal. And this is important

for us to determine what type of data

and what type of values ​​we can

store in that column.

Here we will try to

use postg.

Well, for the most common data types

for characters, there are two here,

namely varchar and text. If

varchar is for strings with

varying sizes.

Then for text there is a string

with unlimited size. So, it's like that,

it's not like that, it's

not unlimited. We can write

ee, the data content can be as long as we want

because it is unlimited. Then secondly

there is numeric. These numbers include integers,

floats, and bulls. This integer is a

whole number. So it's like 1 2 3.

Meanwhile, flot is a

decimal number that has commas. So

like 0.5, 0.7, 1.2, basically it's not

round or round like that. He's in a coma.

Then the third numeric is

bull or bulean. This is like right

or wrong, true or false. Or

maybe there are usually those who replace

true with 1 and false with 0.

And finally, there is the concept of data ee eh

there is a temporal data type, namely date ee

which is a date. So the format is

usually year, month, and day. Ee

contains three

ee there are year, day and month. And

then there is the

time stamp, which is the time stamp.

So the date is not just a date,

not just the year, month, and day, but

also the time. The time is also

recorded, starting from the hour, minute to second.

Okay, here we will try to see an

example, okay? Hey, so from

these types of data, for example,

how can you, friends, be able to

draw a better picture?

So for example here first there is the

student ID. This student ID contains ee 1

2 3 4 like that. So this ee is included in the

integer data type ee because it is a

whole number. Then here there is also this

because this is student data, so here

there is the ID, name, blood type, IP

and date of birth. Well, then for

this name, the type is farcar

.

Because

this eechure can be used for texts that are ee

varied but usually still limited.

Usually, people don't use names that are

too long, like descriptions

or, for example, book summaries.

What does that mean when it's long

? Ee to text. Meanwhile, if the

ee is still limited, it is called varer.

So the name is included in the variable data type

. Then there is blood type.

This blood type is still included in the

farchar section, but it has another

specification that we call enum,

okay? So it's text but it seems like the

choices are already limited.

So we're just like there

are only four blood types, A,

B, AB or O. Well, if

the choices are limited like that,

we can include the enom data type.

Then there is IP. This IP is a float

because it is in the form of a comma. Like Arif's

IP is 3.98,

Hadit's IP is 3.42. So, this

includes the ee data type flot.

Then the last one here is the

date of birth. If it's a birth date,

people usually only get to the date

, it's very rare for it to arrive. Ee,

we never even see if, for example,

we are asked for personal data, the

end date, right down to the last minute,

no. So because ee only contains

the date, month, and year, it is

included in that data type

. So, friends, it's

important to understand data types,

so that later we know

when we write queries, we won't make

mistakes because we can't

retrieve data if it doesn't

match the data type stored

in the database.

[clears throat]

Also, from this example, we can

see that for example, every data

must have its own data type, the

appropriate data type. We can't

just call them

integer data, for example, or call them all

vchures, but they must

contain data that matches their

respective types.

Okay.

Well, let's continue. Hey, now what is

the role of SQL in the industrial world?

So, SQL is widely used by

people in various professions, right? Ee

as here SQL is also used by

developers to write

data integration as well as by data analysts to

organize and run analytical queries

. So, there are indeed a lot of people who

use ee data in various professions.

Any profession that uses data

will definitely require SQL, right?

As previously, developers use it to

write data integration. Meanwhile,

data analysts organize and

run analytical queries. There are also

friends who must have known

a lot about data, knowing that

usually data is a profession, there are

also data engineers or

business analysts. Well, data engineers

use SQL to build

pipelines and process

large amounts of data. Meanwhile,

business analysis is more or less

similar to data analysis. But

usually, they are specific to

answering business questions, right? So

SQL is a

very important EE skill for

anyone who wants to work in the field of

data, technology, business, or EE in the

operational field.

Okay, now we're on the

last slide, there are examples of

professions that require SQL, right?

As I've already tried to

give an example, there are also data scientists, ee, who

usually

use SQL to retrieve data

before carrying out further analysis,

or ee, they usually

create machine learning models, right?

Well, they need to retrieve the data

using SQL. Then also

for data engineers, they build,

uh, use SQL to build

or manage the data flow.

So, those who manage it are usually

data engineers, then there are also data

analysts or business analysts who

will make reports here, right?

making reports, doing analysis, ee

looking for insights from existing data

, like that. Then there are also database

administrators who are

responsible for managing

the performance and security of the database.

Then there are also quality assurance

testers. Eh, here they

usually use SQL to check

[clears throat] whether the data that appears is

correct. ee the stored data is

clean, it is good, there is no more

anomalous data that does not match the

ee data stored in the database.

So, SQL is a skill that is not

only used by one profession

, but there are many professions

that use SQL.

So, SQL is indeed a

cross-functional skill that is used in many

fields.

Okay,

now we'll move on to

that material for now. Now we will move on

to the demonstration, to the practical part. So

in this session, our goal is

not to immediately become an

SQL expert, but our goal is

more for us to learn and understand the

basic patterns of queries first.

So later I will try to start from the

simplest ee query. Then

later we will try, for example, adding a

filter or adding a sequence or

calculation like that.

And if, for example, when we

practice like that, I also hope that

while trying, if for example there

are still errors or mistakes, that's totally okay

. Instead, we have to

try and learn until

we can finally write queries without

errors. But errors are also

not a problem at all. Even

experts often still make mistakes

when writing queries. Whether it's

an error, it's usually just a typo.

there is something written wrong. So, it is

still very normal for errors to occur.

J ee maybe that's the bridging before

we start the demonstration.

Before I continue here, friends, are you

ready for us to continue

the presentation, ee, to the demonstration?

Okay.

Okay. So for the demonstration here

we need to prepare two of them, okay? The

first is the data set. The data set and

the second one is the ee tools.

Friends, you have got the link for

the ee database and the SQL link, right?

Okay, safe. So here we try it

together, okay?

Okay, first I will open the

data set.

This is already visible, right? There's already

the syntax here. Then I'm also

going to open SQL Lite

SQL. Let

me try to refresh first.

OK, this is the default view for SQL.

So, ee, this UI here already has a

default one, right? So,

we can just delete the star select from this demo

.

Then we can open this

free database, friends, you can download it, you can

download it first or you can directly

access it from here.

If I were here I would try to

give an example of ee for direct access, okay?

Because it's already open here,

we can just copy it straight away. So we

select from the top, we select and then we

copy. Ctrl C. Then we open it again to

ee SQL online.

For example, if you look on the left

, there is a table here and the table

here is just a demo table. There is only

one table which is demo. Now we

will try to insert or create a

table in SQLite using the database

that we copied earlier. So let's

copy and paste it here.

Okay, this has a query

from the beginning, from top to bottom. Then

we can directly press run here

or if you want to use a

shortcut, we can

press control enter, which is the same as

pressing run here. I

'll try using run first,

use the run button here.

Well, after we run it, the

ee table appears here, the transactions. If

only there was a demo, right? Well, here

the transaction has appeared.

Okay, it's

safe, guys. It's

all been successful to access the database.

Okay.

Okay. If that's the case, it means that

all my friends can do it and the

transaction table has appeared here.

If so, we can just delete the query

. So we don't have to save this query

. And we can see that

for example the data in the table

already exists and is stored in SQL over here

.

Okay, then we'll continue.

We will try some queries for

our ee practice together here. The

first thing we will definitely try is the

most basic one. The most basic one is

definitely a query called

select.

We have already created a table

called transactions. Now we want to

see what the contents of the transaction table are like

. So we're going to look at all

the data, the entire data. We can

use the ee syntax, namely select star.

So this star means we will ee

take all the data. Here we

will try to run.

Okay,

sorry for the

short delay.

Oh, sorry star. So, for example, if

our query has an error, it

will appear like this,

SQL error, and there will be a definition of the

error. So here it is

informed if for example not table

specified. So there is no table that

we can choose. Sorry. For

example, if we select it, we should

define it clearly, right?

We have to mention everything. So

what is the name of the select star from table? We have a transaction table.

So we will take all the data

from the transaction table.

then we run this.

Well, here the

transaction data that we just entered

into the transaction table immediately appears.

Can you see

how many columns there are here? 5

11 columns. There's a transaction ID, there's a

date, there's the owner's name, right?

We can just move this around. For

example, if we want to see the definition, or want to

see the full form, or

what the table or column is called,

we can just open it. Or, for

example, if there is something called

cover-up, for example like this and we

want to see who Dewi is, this is

flexible, we can move it so it can

be seen, but it will still

adjust to the tools, depending on the tools

we use. Some can

shift, some can't.

There is the region of origin, then there is also the

quantity,

there is the number of items, then there is the

unit price, there is the total payment, there are

payment methods and also there is the status ee

the payment status should be like that.

Okay, that's easy, guys. Of course it's

still easy.

We're still just being silly.

If so, then next time

, maybe I'll explain a little.

If you select this star, that's the

syntax for retrieving all data.

This is usually

useful, but it is not recommended

if our data is already

too large. usually, if

the data is already hundreds of thousands, millions,

hundreds of millions, especially if

we take all of it, the

SQL performance will decrease,

right? So we make a query the result

will be very long. So, for example, if

we want to take the entire column but we

only want to take that example, we

can use the syntax called

limit.

So here I will write a query

like this.

For example, if we only want to take 10, then

we write the limit as 10. And for

this SQL syntax, it's not that rigid

. We don't have to write long

to the right. For example, I want to write select

stars from transactions like this, that's

possible. Or, for example, if I

want to go down like before to make it neater,

both can work in the

same way. Here we will try to be

scary with the addition of the syntax limit of

10.

Okay, that's it. So the data that comes out is only

10. If, for example, we didn't

use this,

the data would still come out up to 50 or the

entire data. And if we

only want to take 10 rows, we can

use a limit of 10

.

Okay, next. Here, for example, after we

see all the data, it turns out we

don't want to take it all. we just want to

take a few columns. For example, we

only want to know the customer's name. So

here I can call the customer's name.

We remove the limit because we want to

take all ee so we can

just say what the column name is.

Then we will run. Well, it will

come out straight away if, for example, the

customer's name is Budi Santoso, Siti

Aminah, Andi Wijaya and others

like that. Then, for example, we can also

take ee apart from the customer name, we want to

take two columns at once, right?

So the customer name is also the product category,

this is the product category. Well, usually in

SQL, when we start typing the

column name, it will also

give recommendations about what column

we should write.

Usually we can continue writing

or we can also just select

it and it will also be written

here immediately.

Then we will run this.

Well, it immediately comes out as the customer's name

and also the product category. So from

this transaction data, we can see that,

for example, Budi Santoso bought

electronic products, while Siti Amina bought

clothing products, Andi Wijaya bought

hobbies, and so on.

Next

we can also write this like this.

It doesn't have to be to the side, but it can also be

downwards. For example, if I have

a lot of columns, I usually

prefer to go to the bottom because it will be

easier to see. And if,

for example, we have five columns like that

, then this can move to the right and the right, it

can be covered on the screen. we don't

see all the complete queries like that.

So, I prefer to go down and I

also recommend my friends

to write like this. So

actually, SQL doesn't

have any rigid rules

for writing. Whether we want to continue to the side

or continue to go down is up to us.

But from me, I

recommend that, friends, you

start getting used to

writing neat syntax, even from just learning. So, for

example, if we are running and suddenly

we get a long time and then we run and

suddenly there is an error, we can more

easily find where the error is. Is

there a [clears throat] typo or is there a comma

missing. It's easier if

we write in a good and

neat format. For example, here I

write only the customer's name.

I wanted to get the customer name and

product category but I forgot to put a

comma. Now. [clears throat]

Oh okay. Sorry, if it's like this, it will

still come out.

I'll continue first. So, for example, we want to

take the customer name and

product category, but we want to change the name.

So we don't want the customer's name to

remain written in the table as the

customer's name. We want to give him

column names like that. So we just want to change it

to the name.

Then, if we want to change the product category,

we just need to change the category.

Here we can use the ee syntax S. So S

means alli, right? So the

customer name as the name and also the

product category as the category. We'll

try this and he'll come out. What comes out is

no longer the customer's name here, no

longer the product category, but just the name

and category.

And also, if we don't

want to use S, it can be set as the

default. If we take one

column and then next to it there is

another column name and without a comma, it will automatically

assume that the second column name we

wrote is the name of the alliance

that we called first

as long as there is no comma, right?

We can also run this and the result will be the

same, still the name and category. So we

can use S here, we can use S.

You can also not use S, the result

will be the same. His SQL can already

understand what we mean.

So what if, for example, we want this

to be

two words, for example, full name

and here the purchase category.

For example,

if we want to name a column

with two words, we can't

write it like this, there can't be

spaces. Later it will give an error.

This is the error, it's almost a complete error.

Because it detects there is a space here.

So if we want those two words, we

can use underscore

so that they remain connected as one

word. Well, it worked.

So we change the customer names to

full names and we change the product categories

to purchase categories.

But if, for example, we want the

table name to be neat when we take the data,

it's good, for

example, so if, for example, we want to

download it directly and then, for example, we

want to share it with someone, to our team, to our superiors,

it's neat and we don't need to

edit it again in Excel,

for example, we can also use quotes.

So if we want to use spaces, we

have to use quotation marks. It's the

same here too. So the full space name

and then the purchase space category

this cycle. Well, then he

can output the column name with

spaces like that. It's

still safe so far, friends.

Okay, I want to and I will continue to the

next syntax.

If we had previously selected ee there are many

columns like that, for example here there are two columns like that

. Now we

want to take for example the name of the customer ee

purchase category from

our ee transaction data, right? So if

we look at the purchasing categories here,

there are electronics, Budi

bought electronics, Siti Aminah bought

clothes. But we actually want to see

what is available in our data,

just the purchase categories, and

what are there? So we only

look at the product category without looking at

who bought it. we can

use distinguishing.

So, this distinguishing feature will output

unique data from the column we

select.

If we look here,

there are still two electronics, two clothes,

two or more. If, for example,

we use listing, the result will be

like this.

So, it

turns out that there are only four product categories in our transactions,

namely electronics, clothing, hobbies, and

furniture

. We can also do the

same. For example, we want to see the

name, the name of the customer.

This is also the same cycle and we get a

unique ee, a unique name from the buyer.

Okay, next

we'll try [clears throat] to go back and

get the overall data.

Sorry, the shortcut is shift shift enter

not control enter.

Okay, here, for example, we want to see

transaction data that only comes from the

western region, for example.

We can do that using

SQL with syntaxware.

So, the function of this syntaxware is to

provide a filter to the data that we

retrieve, like that.

For example, we wanted to see the origin

of transactions originating from the

western region, so we have to define where the

origin of the region is the same as if

we had to write a filter ee to provide a

data filter that matches the

data type. So if the origin of this region

contains varcar, then we have to

write it in quotation marks.

because it is text, it is

in the form of farchar. We will run.

Okay, here we use the

single quote.

Well, all the data

coming from the western region will come out.

How many are there? We can see. There is Si

Budi, there is Dewi, there is Joko Widodo who

are consumers from the

western region.

For example, we can also see people

who buy more than one, where

buying more than one means the number of

items is

more than one, so it will come out, we

can shift enter, the result is this. So

who is Budi? It turns out he bought

more than one item, he bought two.

Eko apparently bought four wooden chairs

.

So, we can use this where for

all data types that exist in

our data, like that.

Then

we can also use this

multiple times, right? So it's not just

one category, but for example, I want to

take a transaction originating from the west

with one item. So earlier

we already had a filter for the number of items

more than one, then we will

add the query N. N number eh sor n

origin region is the same as barokaran.

Well, these are ee three transactions that

come from the western region and the number of

items is ee not more than one

.

Then, eh, there are a lot of syntaxes in this place,

huh? Like this, there is where

and then we also have something called

or.

Friends, you understand that there is no difference between that and the

same. This is actually the same way it

works in logic and mathematical logic

. So there is N and OR ee it's the same

ee how it works here. For

example, if N means ee the first filter

must be true, must have ee

must be true and the second filter

must also be true, right? So if N

must fulfill both, whereas if

OR H can fulfill only one. So

where the number of goods is more than one or the

region of origin is from the west. We

will try this. Well, this is the result.

If it turns out that Budi fulfills

two criteria. He's from the west and

the number of items coming in is more than one.

That's why the first data came out.

Then the second one here is ee, the

area of ​​origin is from the south

but the number of items is more than one.

This means that if he meets one of

the criteria, he will still be

out because here we use OR. Oh, I see

. And if N is the example,

we have to fulfill both,

namely the one that comes from the west and the number of

items is more than one.

Okay.

Then

for where this is also still there.

Earlier, we filtered it for

numeric data types, and also for

text data types. Now, what if,

for example, we want to filter ee based on

names that contain certain words

. For example, here I want to take

the names of customers that contain the word Budi,

we can use like.

So we can choose not only not

have to write like the full name. For example, the

customer's name is the same as Budi

Santoso.

This can be

this can cycle and the results will

come out. But we can also, for example,

only take the ones that contain the

word Budi. If so, we

can use like with

ee what is this use of ee?

That's the percent sign, right? So we can write it like

before, we have to write it in quotation marks

first then we add the percentage

at both ends and the name. This is

the cycle where the results come out with Budi.

So there is only one

customer name that contains Budi from

our transaction data.

Okay,

I'll continue. Maybe I'll be a bit

quicker as we don't have

much time left.

Then for the next syntax it

exists.

Okay, let's go back to

the table first. Let's take a look at the table first.

Here there is ID, date,

status.

OK, for example, if we want to see the

transaction data

from the most

purchases to the smallest,

we can sort the data

using a syntax called order

buy.

So, this buy order will sort

the data based on the column we

choose, like that. Since I wanted to see

ee based on the most purchases

, that means we will try to

use the number of items here.

We order based on the quantity of goods.

Let's try, run.

The result [clears throat]

comes out from here from ee the smallest number of items

first. One. Then

we can see that the most are

in the top 10. So, what if, for example,

we want to take ee but it's the other way around, we

want the largest one to be the

top one, and we can use the

syntax des.

So by default, for example, if we

use order by in SQL, it will be

applied automatically, eh, reading as ASC

or ascending. Ascending is in order

from smallest to

largest. So if we don't set

anything here, we don't write it,

it will automatically sort from

smallest to largest. But if for example we

want it from largest to smallest, we

can use the syntax des which means

descending. Well, if we get the results

like this. So the top 10

then 5 then 4 until finally the

number of items is one,

right?

Then, this order by is not

only something we can use for

one column, but also for more than

one. For example, we want to see ee ee mm

data that is sorted ee based on the number of

items on each

date, right? So for example

here we will select the date

then the number of items

if the cycle is

oh sorry what was it called earlier, the

transaction date, sorry

ee, this transaction cycle, then it will be

in order of date but it will

sort from the largest

number of items to the smallest,

this is the transaction date one, there is a quantity of

1 du. Then, for example,

on the 11th, there were also

purchases of two or three

items.

Okay,

then

here for writing order by it's

not only ee we have to be so we

have to select the column but we don't

always have to write the name of the column

. For example, it's like this.

So, for example, we want to take specific

columns, for example, only the

transaction date, then the same product category,

then the number of items.

Then we want to sort by

transaction date only, we can

choose that, we can write

sort, we can write like this. Order by the

date our transaction runs. It will be

sorted by transaction date

but we can also run it by

selecting by writing one. So

what does this one mean? This one means

that we choose order by the

first column.

So the first column here is the

transaction date. Then it will be

sorted by transaction date.

Then

we try to get used to writing neatly first,

sorry. Then we try, for example, if we

want to sort by the number of

items, we can write the number of items

or we can directly select the number of

items here, which is the 1st 2nd 3rd column

that we write in select, then we can

select the order by 3. Then, for example,

I want to sort it from the

largest, so the order by 3 is descending.

Well, this is the result. So, the items with the

largest number of items immediately

appear at the top, right?

Let's continue, okay?

So next

in SQL we can also do ee

aggregation like that, right? So

what does aggregation mean? What is meant by that is the

syntax of

mathematical operations such as count or

calculating.

Then there is also sum,

then there is also average,

there is min, and there is also max. I'll try to

write the syntax first. Here,

for example, if we want to count the number of

data, we can select count ee

star.

Then for SAM, we can, for example,

add up the unit prices

or just add up the number of items

. Then we

add up the average unit price. Eh, sorry

I pressed the unit price. Then for the

minimum, for example, we want to see the total

payment.

We can also see the total number of buyers,

which we can do all in

SQL. And if we want to

take it all at once like this, don't forget

to use a comma. So we have to

put a comma in each column we

take.

This is if we try.

Oh sorry, I didn't use it in the end

.

Well,

the count of all the star counts comes out

or we count all the rows of data,

there are 50. Then the same is the number of items. The

number of items purchased was 91. The

average unit price or average

price of each item was Rp.

280,000

and the smallest total payment was Rp.

75,000

and the largest was

Rp. 1,200.

Then, for example, if we want

the writing to be neater,

we can also use allas like before

. So we can just

give it a name, for example, we name the amount of our data

as the amount of data, then ee, the

total number of items,

we want to change it directly to the total number of

items, the

average unit price, for example, we want to

write the average price,

min total payment, for example, is the

smallest purchase.

And finally, Mas, the total payment

is the largest purchase.

Don't forget,

underse. This is also possible and the results

are immediately neater, yes,

for the writing format, ee, the

columns like

that.

This is also the same if, for example, friends

don't want to use S, they can.

we can just run it straight away. The results are

also the same. It seems like nothing has changed

because the results are the same,

right, friends?

But here we will try to get used to

using S first so that friends don't get

confused. Okay. So, next, besides

aggregation like the one above, we

can also do ee aggregation

based on columns, right? So, for example, if

we want to see ee, we can see the

total data for the whole

table. When we use

the star, we take all the ee rows

in this table. Now we want to see the

entire line but based on the ee

region of origin. So what does that mean? So,

we want to see, for example, in the west,

from the western region, how many transactions there are,

we can count the stars. So we

select the region of origin then count the

stars and for example, if we want to

see the total purchase, we

add S to the total payment.

Okay, so it's nice, let's give it a name

as total transaction. the

transaction amount

and also the total payment amount as the

payment amount.

Well, we can do this. But there is

one addition. If, for example, we want to

see based on the region of origin, ah,

we need one more syntax that

we can call group buy. So,

this buy group means that we want to

group the number of transactions and also

the amount of payments based on the

region of origin. So, we want to group

the aggregations performed in this syntax

based on the columns we select.

This is if we try. Well, the result

will be like this. So, in the west there are 10

transactions. Oh, it turns out they're all the same.

In the west, center, south, cucumber. East

or north, there are 10

transactions in total. This means our transactions

are spread evenly, right? Then ee,

but if we look at the

payment amount, it is not the same in each

region. The largest one is in

the central region and the smallest one is

in the northern region.

Then we can also add a

buy order. So, if we use group buy,

we can group

the groups based on the region of origin and

we can freely choose the buy order.

So we want to sort it based on the

order here, the region of origin. If it is

based on the region of origin, it means it

will be sorted alphabetically,

right? But if for example we want

something else, for example the number of transactions is the

same, we can just choose

order by 2. But because here the number of

transactions is the same, so I want to

sort it based on the

payment amount only. So I'll choose

column 3 like that. So we'll see

data like this. I'll try it first.

So the order is no longer based on

region of origin but based on the amount

of payment. Because we have selected

order by 3. So this is still valid, right?

One 1 2 3 will be based on

our choice in silect. The order

we choose is selected.

Because I want to sort by

payment amount I choose three. And because

I didn't write anything here

ascending or descending, it will

automatically sort from the smallest. The

smallest is at

R2,435,000.

RIB is in the northern region and the largest one,

R million, is in the central region, right?

Then, for

example, if I want to do this, we can

see all the data, all the origins of the region,

right? For example, if I only want to

filter the largest region from the

largest region, ee not the largest, sorry,

the one with the most payments, the

syntax is also the same as this. But

we can add one more syntax,

namely limit.

Because we only want to see

one largest area, we can

choose limit 1. So it will choose the

largest ee.

Hey, just the biggest one. Because

we want to start from the largest one,

don't forget to add descending order,

then we run it.

Only one data came out because

we limited the data earlier. If we remove the limit,

it will all come out. But if

we want to see only one, we can

increase the limit by one so that only one data will come out

. This can also be limited to more than just

one. For example, we want to see the top

three, the top three regions based on

the number of payments. we can use a limit of

3 and the result will be three

data with the largest payment amount

. three areas with the

largest number of payments

like that.

Okay,

maybe that's all from me for the practical session,

ee, that's all for now. Looks like

our time is up too,

Mr. Tika. That's

absolutely right, Sis. So, does Ms. M

Hana have anything else she would like to add

?

Okay, maybe I'll

add a little something to conclude. So,

from this practice, from the material and

practice, we have learned, starting

from the definition of SQL, and also

data types. We have also tried to

practice the basic concepts of SQL, right?

From SINTAK Select, there is where, there is

Orderby and many

other SINAKs. Eh, I hope that this material

can be useful and that it can be beneficial

for all my friends. Oh, and also,

if, for example, after

this class, my friends feel that there's a lot of

SQL that needs to be learned,

that's very normal. Hey, just relax,

just try to practice it slowly because

learning SQL requires

a lot of practice so that you

can get used to writing scripts or

writing queries. The important thing is that

friends already understand the basic pattern first

. Later, once you understand the

basic patterns, it will be easier for

you to learn

more advanced queries. Ee maybe that's from me

. Thank you very much, friends,

for your attention and also for

your time. Hey, for now I'll

return it to Kak Tika. Thank You.

Okay, thank you too Sis. E so ee

a little explanation too, maybe some of my

friends are still

wondering, "Sis, how does the

minimum work work?" So,

I'm going to share my screen with you guys for

a little explanation before we get into the

Q&A session using Slido. So,

perhaps since earlier,

quite a lot of friends of Kak Hana have been

asking questions in the chat column and maybe

the questions that I didn't get a chance to

see earlier are really welcome to be thrown

to Slido because later there, if

your friends' questions are sufficient

or representative enough, please like them

so that the question appears at the top

and I can get more priority.

Well, I will explain a little technically

how to do the minimum,

Sis? First, my friends,

I have shared this link earlier in the

chat column. Please just download it. Later

here, the owner's name is just write

your name. For example, Kasmurangkir or Ahmad

Dani or whatever your friends will

use the name for. Then, for the

first instruction,

this document is not open access, so download it

first and then work on

each device. Then you

can do the post-test

first. And for today's class recording,

it's at point number two. Here at

point number,

you can access the data set

that we used for practice.

Maybe someone missed it and

wants to repeat it through the recording, that's totally

fine, you can practice it after

this class. Well, then later

after you upload the results of your

friends' work on the template on one of

your social media, what is uploaded can

be a PPT file or a screenshot file

from this file except for slide 2. So, you

don't need to share this work instruction slide

on your social media, friends

. Well, don't forget to

tag #learnmyscale later. So, for the

post link or post link and

the tuon, you can e up or

enter it into this form, number

5, no later than Wednesday, July 15th

at 23.59.

Well, later you can fill this in

with a course summary or

brief explanation of what you received today

. You can enter it

here and in the right column, you can

put your name later. Well, the

case study example is also at

this point, read it carefully and then

work according to the instructions.

Later, you can include the results of processing the data set on SQL

Light Online on this slide,

it can be in the form of a

screenshot or something like that.

Well, then later, after

you have practiced, fill it in with the

results of your analysis that you have

done in the online SK on the following slide

. Well, that's it. Easy, right friends? It's

easy because my friends understand how

to do the minimum work. And

next we will continue to the

question and answer session, Sis. We still have

about 7 to 10 minutes left.

So, perhaps there are questions that have

not been answered previously in the

chat column, we can ask them directly in the

Slido application. So, friends, you can

now open the Slido application

or the Slido website, which I have

also shared. I will share it here.

Well, if the question is

representative enough, please like it,

friends. because it is really not

possible for the admin to scroll

down. So, for example, if he

represents, just like it like this.

If you press like, it will appear at the

top. So I'll start with the

most liked questions

to make things easier. Okay, let's get

straight to it, Sis, there's a question from

Anonymous.

Hello, Sis. I want to study

further for SKL. For beginners,

which SQL is better to install? My SQL or HG

Gray SQL yes. Okay, Sis Hana can answer

.

Okay, for beginners,

both of these are actually very beginner

friendly in my opinion. So,

just adjust

the specifications so that they are compatible with

your laptop. Ee so ee

both of them are beginner friendly. So just use the one that's

most comfortable for you

because the syntax is also

[snort] SQL, the syntax in it

will be more or less the same and won't

be much different. So you don't

need to think about which one to learn from

first, just learn the most comfortable one first. Later,

once you're fluent, it will be easy to

move to other SQLs.

Okay, I hope that answers your question, Anonymous.

We're next, Sis. On to the

next question.

Hey, there's another question from Anonymous.

What is the difference between using Python and SQL? Is Python

a data engineer and SKLU

or data analysis or both of them

use what data as analysis? This is a

half-hearted question. But

I hope Sis Hana understands, Sis.

Can you answer, Sis Hana?

Okay. Okay. Eh, so SQL and Python have

different usages, huh? If there is a

lot of Python in Python, it is more

advanced. He can start from ee

pulling data, exporting data, processing

data. There's a lot more that can be

done in Python. Then in Python you

can also do what's it called, like that

. So taking SQL queries or

running SQL in Python like that. Meanwhile,

SQL is usually only for

databases. Whether it's

ee making ee creating data, then also

processing data, accessing data like that. So,

in terms of tools,

Python is more advanced and more complex. Ee

continues to also work as a data

and SQL engineer. Actually,

both data engineers and SQL,

or both data analysts can

use SQL or

Python, depending on

what they want to do. Ee

so it's not actually limited, data

analysis can also be done in

Python, eh, it can also be done in SQL.

But eh SQL is specific only

for the database.

Hopefully the answer is yes.

Okay, I hope that answers your question, Anonymous.

Let's move on, Sis, to the

next question, which is still from Anonymous. Sis,

if you are a beginner, can you practice on your own every

day? So

what data can be used for the practice example, Sis?

Okay, what might the data set look like,

Sis? You can answer, Sis Hana.

Okay, for beginners, you can definitely

practice every day. Nowadays,

internet access is very easy

, there are so many examples of

exercises, like the ones My Skill provides, there

are also free short classes,

and there are also examples of SQL exercises from YouTube or

other social media, and there are so many

examples of

databases, and there are so many

kinds of

databases on the internet, and for example,

eh, I usually use a website for exercises

, it's

called kegle K A G.

There are one or two gs. That

can be used for ee, there are

lots of ee databases available there, from

free to paid ones, which

you can use for practice, and the

data there is

usually quite similar to real data,

right? There is transaction data or there is hospital ee data, there are

lots of different

types. So you can try

exploring there and can try practicing

using that

from the name Kegel.

Okay, I hope that answers it, Sis.

Maybe it will be very useful later. Is

this a website or an application, Sis?

Hey, there are lots of them on the website,

they are available on the website.

Later, friends, you can explore Kegle, that's what it's

called, Sis. Maybe later we will.

Okay, next time, Sis. There is

another question from Anonymous. Sis, do you usually

use SQL or Python more often in the work world

? Hana can do it.

Okay, maybe it's different, depending on the profession

too. His profession too, yes. So, for

example, if you are a data analyst, you will probably

use SQL more often because

your focus is usually only on

data collection and data analysis,

data processing. But for

example, data scientists or

data engineers usually

use both, but more

often Python because they are the ones who

manage the data, they are the ones who

flow the data, they are the ones who

manage the database. Then also,

eh, data scientists usually

use Python to create models

, machine learning models. So it

depends on the profession.

Okay, I hope that answers your question, Anonymous.

Then next, Sis, to the

next question.

So, Sis, if you want to learn about

language, comment or query language,

what are the tips or where can you learn

? You can answer, Brother Han.

Okay. So, if you want to learn, you can

use the example we

gave earlier, practice together like that

. Just use the free online ones first

, then also look for data sets. The data

set is also the same, just look for a free one first

. Then we try to do

lots of practice. So, ee,

if for example writing this query is

the most effective way,

we have to practice a lot, try

out lots of questions like that, okay? So,

this SQL query is usually

used to answer questions.

What do you mean by answering the question? So, for example, like the one earlier,

if I were practicing, I

would ask, "We want to see

what products are the most purchased,

for example, or we want to see

which region has the

most purchases, and also what are the

most purchased products in that region, for example,

just practice a lot

with case examples that are

close to the relief, close

to the case examples that are usually used in

businesses, for example,

what products

sell the most. So,

that's my advice,

practice a lot.

Okay, I hope that answers it, Sis. Don't

forget to practice and

explore a lot, Sis.

Then there's another one from Anonymus,

Sis. Sis, if you want to learn more about data analysis

, what software can you

learn or is commonly used in

large companies, such as for

visualization and so on? You can

answer that, Sis.

Okay. Actually, what kind of software is used?

Every company

already has the software they

use. But you

don't need to worry about what software.

Because usually the software

works in a similar way. That's it. So

as long as you understand and can

query in one software,

usually moving to another software

will be very easy. You just

need to adjust to using the

software. Then,

for visualization, it's also very similar.

So, as long as you're good at it, just try to

learn how to make

charts, make tables, and charts,

for example, there are P charts, bar charts

, try to learn how to make tables and

charts first. Later,

you will definitely follow how to use the tools

. So you don't need to

worry about which software to use.

Okay, the important thing is to explore the

methods first so you understand better

, okay, before using

more advanced software. Okay, I hope that answers

it, Anonymous. Let's move on to the

next question, okay?

Sorry for the comma usage, do you

use a comma at the end of every word

? You can answer, Han.

Okay. So, not at the end of every word

. So, for example, if we take

or select data, select

columns, for example, we take column A,

column B, column C.

We have to put a comma after every column name.

So, we use commas in

all the columns we select, but not

in all the syntax. So, for

example, if we select A B C from transaction,

for example, in the from transaction,

we don't need to add a comma again,

otherwise it will give an error. So, just stop

before from.

Okay, I hope that answers it, Anonymous.

Next, we'll take another question from

Anonymous. Is freelance data analysis

common, and secondly, are there

data analysis agencies? You can answer, Sis.

Okay, freelance data analysis is

very common because, in my opinion, this is a

field that not everyone really

needs, but the demand is still

high, but uh, the supply is not yet

sufficient, you know.

So, there's still a lot of potential for

you to become a freelance data analyst

because the opportunities are very big.

Also, for [clears throat], agencies are

usually more like vendors,

if in the data field, it's

usually in the form of vendors. So,

joining a vendor consultant

as a data analyst.

Okay, next time, Sis. I'll take a moment off

because the em My network suddenly got a bit

stuck, Sis. I'll go next, Sis. For the

next question,

it's from Anonymous again. Is data

analysis still relevant for the next 5 years

and beyond? Thanks, Sis.

Can you answer it?

Okay. Wow, I'm like a psychic. But

if you look at it from now on,

uh, what's it called?

This field of data analysis

will continue to grow because uh,

we always use

data for everything, there's definitely data, and this data is

very powerful. So of course it will be

very relevant, will still be relevant, and will still be

needed in the future

because uh, especially now that technology is

developing. AI is also

developing a lot, uh, and

behind it are the machines

[clears throat] that learn to use data

. So uh, for data analysis, it's

still very relevant for the next 5 years

or maybe the next 10 years

.

Okay, I hope that answers it, Sis Anonymous.

Then we'll go to the next one, Sis.

We'll take the last two questions

, Sis, for tonight. And

Sorry guys, if we

can't answer all your questions

tonight. If you really want to advance

in this field, you can join our bootcam

or we can join the

next class. That's it. I have

another question, Sis. Sis, I

wanted to ask, uh, in the

formula, there's the highest sales. Is the

highest sales the same as the

best-selling one? Can you answer that, Sis?

Yes, that's right. Usually, it's like that

if we say, for example,

at a shop. The simplest way is

to ask

the seller, "Sir, what's the best-selling one

here?" Uh, the guy or girl

will definitely answer which product is

bought the most, right? So, by

definition, is the highest sales the

same as the best-selling one? Yes, that's

right. So the best-selling one is the one

bought the most.

Okay, [clears throat] the definition is still the same

as the general definition, Sis.

Okay, let's go to the next one, Sis. Sis,

where's a good way to start learning data analysis? May I?

I told you, Sis. Hana.

Okay. Actually, there are many roadmaps for learning data

analysis, but

some people work right from the start

, they start directly in

the field of data analysis, but there are also those who

start from, for example, professions

related to data, for example,

in data operations. Data

operations usually still process

data, although not as ee in not

doing analysis like data analysts

. So they process data ee

tidy up data or also ee do

data cleansing ee that is still very much

in line with data analysis. And

I think that is also one of the

other options to

start. So it doesn't have to be directly from

data analysis, but from

any profession that uses data, like that.

Because if, for example, we have started to

get used to using data, have started to

get used to accessing, processing data, it

will definitely be

easier for us to process data until we

can finally find insights

and become expert data analysts

.

Okay, I hope that answers

your question, Sis. Let's take the last two questions

from Anonymous and

Prabowo Sudianto, Sis. Okay,

first let's read First of all, Sis. What's the

best application to use for syntax writing,

Sis? So that it doesn't get tired of

handwriting? You can answer, Sis Hana.

Okay. There are actually many for syntax writing

. Uh, this

means study notes. That's

my suggestion, adjust it to

how you usually feel comfortable studying

. Some people, for example, if

you're tired of handwriting, you prefer

typing. The simplest

is we can use Google Docs.

That's also free from Google. We can

just write in Google documents or,

for example, if we want to write in notes on a

laptop notepad, that's possible.

Or, if, for example, you want to use

more varied note-taking,

which is more flexible and can be decorated, there

's also something called Notion, which is

written as N O T I O Nion. That's also

one of the tools for

taking notes, whether it's material that

uses coding or

other learning materials. So,

just adjust it, but there are lots of

applications you can use.

Okay, so the key is, it's okay to just

explore it first Is that so, Sis.

Okay, last question, Sis.

Ee the question, Sis, for the

long term, is it better to have a large project,

My SQL or [ __ ] DB? You can answer, Sis

Hana.

For the long term, it actually comes

back to the long term, eh, it depends

on what the project is like. Then also

usually every company has what they

call it? Has its own SOP.

Do they want to use which tools

and later you can see which tools

are more compatible with which language

. Are they

using SQL or MongoDB?

And ee for

this ee also needs to be adjusted to

what the project is like and

how long the long term is. So

to determine that, you have to detail what

your needs are like. Later,

you can check which one is

most suitable for your needs,

then that one is chosen.

Okay, that question also concludes

our class e perk tonight. Ee

thank you to Sis Hana for

taking the time of course

tonight and for providing an explanation that is

certainly very. And I hope that

we can absorb this material and also

be able to practice to be

better, okay, Sis.

Okay, since the presentation session is

over, I want to invite you guys

as usual to open the camera first

because we will be doing a

documentation session, guys. It's

okay to be on cam later I will

count 1 to 3. You guys can

give your best pose

tonight, okay. Okay, I'll count to three. You

guys can smile or you can

give your best pose, okay. 1 2 3.

Okay, one more time.

1 2 3.

Okay, wait. Repeat. 1 2 3.

Okay, next slide. There are

still many, guys, on the

next slide. 1 2 3.

Okay,

thank you guys for

coming tonight. I hope you have a

better sleep tonight

and also hopefully the material presented

today can be useful, beneficial for

us so that later for every

career path we choose can

lead us to the success we

want or desire. Like that, okay.

Well, I also apologize if there are any

mistakes during this class.

And again I want to say

thank you to Sis Hana and have a good

rest, Sis. May your sleep be more

restful and safer and more comfortable

tonight. See you again, Sis

Hana.

Thank you, Sis Tika and friends.

And for the class tonight, I

would like to thank you for your enthusiasm and

also for my friends

tonight who are still enthusiastic if you

have any questions, you are welcome to

DM us on Telegram, later I will help

answer your questions

about the short that we attended

tonight. Therefore, that's all

for tonight. I, Kartikair, take my leave

. Wasalamualaikum

warahmatullahi wabarakatuh. Yeah.