Python & SQL: Tingkatkan Produktivitas dan Keputusan yang Efisien

Tujuan Pembelajaran
Tujuan Umum
Peserta pelatihan mampu meningkatkan pemahaman dan keterampilan dalam bahasa pemrograman Python dan SQL, peserta mampu mengembangkan aplikasi dan mengelola basis data dengan menggunakan Python dan SQL. Mereka akan dapat merancang algoritma, mengolah data, dan mengoptimalkan query SQL untuk mencapai tingkat keberhasilan minimal 60% dalam menghasilkan solusi yang efisien dan akurat dalam sesi unjuk keterampilan.

Tujuan Khusus
1. Peserta mampu menerapkan konsep berpikir komputasional dalam pemrograman Python
2. Peserta mampu membuat dan merangkai syntax dalam pemrograman Python
3. Peserta mampu menerapkan konsep Pemrograman Berbasis Objek pada Python
4. Peserta mampu membuat dan menerapkan syntax pada SQL secara dasar (read data, query, aggregate data)
5. Peserta mampu membuat dan menerapkan syntax pada SQL secara mendalam (sub query, pembuatan desain database, konsep ERD)

Pertemuan 1 (180 menit)
Sesi 1: Introduction Fundamental python for Data science (18.45 - 21.15 WIB)
Computational thinking+Intro python + IDE programming

Pertemuan 2 (180 menit)
Sesi 2: Basic Python skills for data science (18.45 - 21.15 WIB)
- Data type, looping, if conditional
- Library pandas (data frame group by, filtering, subsetting)

Pertemuan 3 (180 menit)
Sesi 3: Concept Fundamental python for Data science (18.45 - 21.15 WIB)
- OOP

Pertemuan 4 (180 menit)
Sesi 4: Introduction Data analytics using SQL Tools (18.45 - 21.15 WIB)
- Introduction Database
- Load data, aggregate data, query basic


Pertemuan 5 (180 menit)
Sesi 5: Create Data analytics using SQL Tools (18.45 - 21.15 WIB)
- ERD schema
- Subqueries

Instruktur
Doni Rubiagatra
Pengalaman Bekerja
Senior Software Engineer – Zero One Group – 2019 - sekarang
- Membuat seamless Continuous Integration / Continuous Deployment
- Maintain clients’ in-house legacy application
- Collaborate using Agile software development principles and practices
- Maintain Optimisation Software written in Python
- Implement new Optimisation Software Using Clojure and Clojurescript

Software Engineer – Kumparan – Mar 2018 - Dec 2019
- Maintain legacy javascript system and migrate to the new stack
- Implement microservices that scalable up to 500.000 concurrent users using Golang
- Create automated spam detector and training for internal editorial using Python
- Lead mini team for internal project

Software Engineer and Operation – PT Edaptec Solusi Indonesia – Jan 2017 - Aug 2017
- Design and implement ODOO ERP system for clients
- Create integration ODOO with VB POS System
- Maintain Bare Metal server
- Make sure deployment went well


Pengalaman Mengajar-
Technical Mentor – RMDS Narasio Data – Oct 2020 - Present
Associate Lecturer – UPN "Veteran"​ Jawa Timur – Aug 2022 - Oct 2022
Technical Mentor – Catalyst Tech – Jan 2022 - Mar 2022
Technical Mentor – Rakamin Academy – Jul 2021 - Sep 2021
Technical Mentor – DeepNusa.Ai – Agustus 2021
Associate Lecturer – Universitas Ciputra Surabaya – Jan 2020 - Jan 2021

Pengalaman Lainnya
Sertifikat/Penghargaan Pada Bidang yang Relevan Dengan Materi Pelatihan
-Mathematics for Machine Learning and Data Science - Courseera - Jun 2023
- TensorFlolw: Data and Deployment - Coursera - Jun 2023
- Blockchain SpecializationBlockchain Specialization - Coursera - Issued Oct 2021
Deep Learning SpecializationDeep Learning Specialization - Coursera - Issued Mar 2018
- Data Engineering on Google Cloud Platform SpecializationData Engineering on Google Cloud Platform Specialization - Coursera - Issued Dec 2017
- Data Science with Python Career Track - DataCamp - Issued Aug 2017
- Data Analyst Track - Dataquest.io - Issued Jun 2017
- Linux Academy logo
- Linux Foundation Certified System Administrator (LFCSA v2.16) -
Linux Academy - Issued Mar 2017

Pengalaman Presentasi Publik (Public Speaking) Dalam 5 Tahun Terakhir
- Oct 2019 – NATS: A high-performance messaging system for communication between service – Gophercon Vietnam
- Jul 2019 – Interactive Python Dashboards with Plotly and Dash – PyCon Thailand
- Feb 2019 – Turn your Flask App into Async using Quart – PyCon APAC
- Aug 2018 – How Python Saved My Life – PyCon Korea

Instruktur
Doni Rubiagatra
Pengalaman Bekerja
Data Analyst Frontier Group
Responsible for analyzing and visualizing survey data.
Introducing Python as a programming language for process optimization in data analytic.

Pengalaman Mengajar-
RMDS Narasio Data - Data Science Mentor & Trainer - Sep 2021 - Present
Online Instructor for Power BI and Machine Learning for data clustering.
Mentor in junior and advanced data science courses.

Laboratory Assistant - Universitas Gadjah Mada (UGM) - Feb 2019 - Dec 2019
Assisting the lecturer in teaching students in the Programming I experiment and Advanced Electronics experiment.
Preparing experiment tools and pre-test questions.
Scoring student lab work.

Instrumentation Engineer - Meteorology, Climatology, and Geophysical Agency - Jan 2019 - Feb 2019
Responsible for communicating with the internship coach during the internship.
Building mechanic system for an IoT-based automated weather instrument built by the team.

Data Analyst - Frontier - Apr 2021 - Jan 2023
Building a terminal based application using Python for data cleansing in one of the Government Institution projects.
Responsible for questionnaire set up and cleansing survey data
Scout Instructor - SMP Negeri 1 Sleman - Aug 2016 - Aug 2018
Communicating with other teachers in curriculum making.
Teaching scout to students at junior high school.
Coaching the camping committee.

Pengalaman Lainnya
Sertifikat/Penghargaan Pada Bidang yang Relevan Dengan Materi Pelatihan

Syarat dan Cara Mengikuti Pelatihan

Syarat
1. Memiliki laptop / PC sendiri
2. Memiliki kuota internet / Wifi yang akan terhubung ke platform pelatihan

Cara Mengikuti Pelatihan
Langkah Redeem Kode Voucher
1. Buka website https://sinau.narasiodata.com/
2. Klik Akun Profil yang berada di bagian pojok kanan atas.
3. Pilih “Daftar Transaksi” seperti pada gambar di bawah ini.
4. Klik “Lihat Detail Pembelian”.
5. Selanjutnya akan muncul tampilan halaman “Detail Pembelian” seperti pada gambar di bawah ini. Kode voucher dapat dicek melalui tampilan tersebut yang di highlight warna hijau.