MySQL Installation on Windows

MySQL Installation on Linux

MySQL Installation on Mac OS

Preparation

SQL Dummy Data - Preparation

Cara Import SQL FILE (Workbench)

Sesi 1A - Introduction to Data Analysis

Sesi 2 - 2.1:Basic Database Terminology

Sesi 2 - 2.2:Database Design

Sesi 2 - 2.3 : Introduction Mysql & Workbench Overview

Sesi 2 - 2.4 : Overview MySQL Command & Data Types

Sesi 2 - 2.5 : DDL (Data Definition Language)

Sesi 2 - 2.6 : Basic DML & TCL

Sesi 2 - 2.7 : Mysql Select Commands

Sesi 2 - 2.8 : Mysql Operators & Function

Sesi 2 - 2.9 : MySQL JOIN Queries

Sesi 2 - 2.10 : Aggregate Functions

Sesi 2 - 2.11 : Database Indexing

Sesi 2 - 2.12 : Database Backup & Restore

MySQL ASSIGNMENT

Sesi 3 - 3A Data Cleaning Techniques & Text Cleaning

Sesi 3 - 3B : Transforming Data into a Usable Format

Sesi 3 - 3C : Overview of Data Visualization

Sesi 3 - 3D : Overview of Looker Studio

Sesi 4 - 4A : Data Visualization using Looker Studio

Sesi 4 - 4B : Build Interactive Dashboards

Sesi 5 - 5a Persiapan Akun ChatGPT

Sesi 5 - 5b Pengenalan Generative AI

Sesi 5 - 5c Prompt yang efektif untuk Data Analisis dan Reporting

Sesi 5 - 5d Langkah Data Analysis dan Reporting dengan ChatGPT

Sesi 5 - 5e Assignment Pembuatan Laporan Analisa Data