Skip to content

Mini Course
Complete Series ✨
Other Course
Others

Mini Course
Complete Series ✨
Other Course
Others

Mini Course
Complete Series ✨
Other Course
Others
Register
Login

Mini Course
Complete Series ✨
Other Course
Others
Register
Login

DA-01 Basic Pengolahan Data dengan SQL & Excel

Level

Sertifikat

Forum

Tentang Kelas

Materi Pembelajaran

Course Content

Pengenalan Data Analytics 6 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/6 Steps

Pengenalan Data Analytics

Pengujian Hipotesa

Pengenalan Metode Ilmiah

Contoh Metode Ilmiah Lain

Pembahasan Metode Ilmiah

Contoh Kasus 1 (Nasabah Macet vs Cicilan)

Pengenalan Data Analytics Quiz

Ilmu Statistik untuk Data Analytics 8 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/8 Steps

Uji T-Test dengan Microsoft Excel

Mengelolah Data Pencilan (Outlier)

Bagaimana Mencari Outlier

Persentil pada Microsoft Excel

Regresi dan Korelasi

AB Testing dan Random Sampling

Contoh kasus (menguji keberhasilan sebuah model yg memerlukan champion challenger)

Ilmu Statistik Data Analytics Quiz

Microsoft Excel dalam Data Analytics 7 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/7 Steps

Pengenalan Dasar Microsoft Excel

Export dan Import Data .csv

Pengenalan Cell Type dan Visualisasi Data

Memahami Tipe Data Tanggal

Memahami Tipe Data Numerik

Pengelompokan Data (Tiering)

Pivot Table pada Microsoft Excel

Microsoft Excel dalam Data Analytics Quiz

Data dan Database dalam Data Analytics 6 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/6 Steps

Perkenalan Database dan SQL

Persiapan Sistem SQL Server

Dasar Perintah SQL

Perintah SQL Dasar untuk Membuat dan Memodifikasi Table

Menyisipkan Data

Menyunting Tabel

Data dan Database dalam Data Analytics Quiz

SQL untuk Data Analytics 9 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/9 Steps

Select Statement Dasar

Perintah Select From

Logika AND dan OR Part I

Logika AND dan OR part II

Perintah BETWEEN

Perintah ORDER BY

SQL untuk Data Analytics Quiz

SQL Lanjutan: Agregat dan Join untuk Data Analytics 10 Topics | 1 Quiz

You don't currently have access to this content

Pelajaran Content

0% Complete 0/10 Steps

Mengenal Fungsi Agregat

Agregat Dalam Kondisi

Perbedaan WHERE Dan HAVING

Mengenal Fungsi JOIN

Mengenal INNER JOIN

Mengenal LEFT JOIN dan RIGHT JOIN

Mengenal IN vs JOIN

Mengenal NOT IN vs LEFT JOIN

SQL untuk Data Analytics Lanjutan Quiz

Basic Pengolahan Data dengan SQL & Excel Final Quiz

You don't currently have access to this content

Gabung forum diskusi

Gabung Forum Diskusi

Tanyakan apa saja di forum diskusi.

No Associated Forum Found

No forum assigned for this course.

Gabung forum diskusi

Gabung Group Telegram ITBOX

Bisa diskusi dan bangun relasi dengan sesama sobat digital

Join Grup Sekarang

Program

Mini Course
Complete Series (Bundle)
Other Course
Event & Workshop

About

Blog
Certificate Verifier
Affiliate Program
Privacy Policy
Terms Conditions

Kendala Teknis & Administrasi

ITBOX Official - 0812-1231-1232

Follow Us on Our Social Media

Instagram Youtube Linkedin

Copyright © 2026 ITBOX. All Rights Reserved.

Shopping cart0

There are no products in the cart!

Continue shopping

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

belajar it

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.