Centennial Tower

5F, Jl. Gatot Subroto No.24-25, RT.2/RW.2, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota, Jakarta Selatan, Indonesia, 12930

Grand Slipi Tower

Jl. Letjen S. Parman No.24, RT.1/RW.4, Palmerah, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta , Jakarta Barat, Indonesia, 11480

The City Tower

12F, Jl. M.H. Thamrin No.81, Dukuh Atas, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota , Jakarta Pusat, Indonesia, 10310

Explore Our Courses

SQL: Basics to Intermediate

 35 Hours
Pelatihan langsung yang dipimpin instruktur di Jakarta (online atau di lokasi) ditujukan untuk analis data tingkat pemula hingga menengah, profesional basis data, dan pengembang perangkat lunak yang ingin belajar SQL mengelola basis data secara efektif. Pada akhir pelatihan ini, peserta akan mampu:
  • Memahami dan menggunakan perintah dan kueri dasar SQL.
  • Membuat dan memanipulasi tabel dan database.
  • Gunakan SQL untuk mengurutkan, memfilter, dan meringkas data.
  • Menerapkan operasi yang lebih kompleks seperti operasi gabungan, subkueri, dan operasi set.
  • Terapkan teknik perantara seperti indeks, tampilan, prosedur tersimpan, dan pemicu.
Read more...

Analytic Functions Fundamentals

 21 Hours
This instructor-led, live training in Jakarta (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions. By the end of this training, participants will be able to:
  • Understand the concept and importance of Analytic Functions.
  • Apply various Analytic Functions to solve complex analytical problems.
  • Combine Analytic Functions with other SQL features for comprehensive data analysis.
  • Optimize queries for better performance using Analytic Functions.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours
Pelatihan langsung yang dipimpin instruktur di Jakarta (online atau di lokasi) ditujukan untuk ilmuwan data dan pengembang yang ingin menggunakan dan mengintegrasikan SQL, Python, dan Tableau untuk melakukan analisis, pemrosesan, dan pemrosesan data yang kompleks visualisasi. Pada akhir pelatihan ini, peserta akan mampu:
  • Siapkan lingkungan yang diperlukan untuk melakukan analisis data dengan SQL, Python, dan Tableau.
  • Memahami konsep utama integrasi perangkat lunak (data, server, klien, API, titik akhir, dll.).
  • Dapatkan penyegaran tentang dasar-dasar Python dan SQL.
  • Lakukan teknik pra-pemrosesan data pada Python.
  • Pelajari cara menghubungkan Python dan SQL untuk analisis data.
  • Buat visualisasi data dan bagan yang mendalam dengan Tableau.
Read more...

SQL in Microsoft Access

 14 Hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
Read more...

SQL in SQL Server

 14 Hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between T-SQL and other dialects
  • practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
Read more...

SQL in MySQL

 14 Hours
  • How to build a query?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL Advanced

 14 Hours
This instructor-led, live training in Jakarta (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management. By the end of this training, participants will be able to:
  • Perform advanced querying techniques using unions, subqueries, and complex joins.
  • Add, update, and delete data, tables, views, and indexes with precision.
  • Ensure data integrity through transactions and manipulate database structures.
  • Create and manage databases efficiently for robust data storage and retrieval.
Read more...

Transact SQL Advanced

 7 Hours
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
  • Use queries to return complex result sets
  • Manage database objects to aid query performance
  • Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
Read more...

Transact SQL Basic

 14 Hours
Delegasi akan memperoleh pemahaman tentang prinsip dasar Bahasa Kueri Terstruktur serta mampu melakukan masing-masing hal berikut:
  • Membuat query untuk mengekstrak dan memfilter data dari database SQL Server
  • Buat hasil ringkasan
  • Ubah, dapatkan, dan format data agar sesuai dengan keluaran yang diperlukan
  • Mengubah data dan memelihara komponen dan definisi basis data
Kursus ini diperuntukkan bagi siapa saja yang membutuhkan informasi dari basis data Microsoft SQL Server. Kursus ini cocok bagi pengembang sistem atau orang-orang dari bidang lain yang perlu menggunakan SQL untuk mengekstrak dan menganalisis data.
Read more...

SQL Advanced in MySQL

 7 Hours
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
Read more...

Data Analysis with SQL, Python and Spotfire

 14 Hours
Dalam pelatihan langsung yang dipimpin instruktur di Jakarta ini, peserta akan mempelajari tiga pendekatan berbeda untuk mengakses, menganalisis, dan memvisualisasikan data. Kami mulai dengan pengenalan database RDMS; fokusnya adalah mengakses dan menanyakan database Oracle menggunakan bahasa SQL. Kemudian kita melihat strategi untuk mengakses database RDMS secara terprogram menggunakan bahasa Python. Terakhir, kita melihat cara memvisualisasikan dan menyajikan data secara grafis menggunakan TIBCO Spotfire. Format Kursus
Ceramah dan diskusi interaktif.
Banyak latihan dan latihan.
Implementasi langsung di lingkungan laboratorium langsung.
Read more...

SQL For Data Science and Data Analysis

 14 Hours
This instructor-led, live training (online or onsite) is aimed at software developers, managers, and business analyst who wish to use big data systems to store and retrieve large amounts of data. By the end of this training, participants will be able to:
  • Query large amounts of data efficiently.
  • Understand how Big Data system store and retrieve data
  • Use the latest big data systems available
  • Wrangle data from data systems into reporting systems
  • Learn to write SQL queries in:
    • MySQL
    • Postgres
    • Hive Query Language (HiveQL/HQL)
    • Redshift 
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Course Customization Options
  • To request a customized training for this course, please contact us to arrange.
Read more...

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

 7 Hours
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
Format of the Course
  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Read more...

SQL Advanced level for Analysts

21 Hours
Tujuan dari kursus ini adalah untuk memberikan pemahaman yang jelas tentang penggunaan SQL untuk berbagai Database (Oracle, SQL Server, MS Access dan lain sebagainya) Memahami fungsi analisis dan cara menyatukan tabel yang berbeda dalam database akan membantu delegasi untuk memindahkan analisis data Operasi ke sisi database, bukannya melakukannya dalam aplikasi MS Excel. Ini juga bisa membantu dalam menciptakan sistem IT, yang menggunakan database relatif apa pun.
Read more...

SQL Fundamentals

 14 Hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
Read more...

Microsoft Access – Downloading Data

 14 Hours
Pelatihan langsung yang dipimpin instruktur dalam Jakarta (online atau di tempat) ini ditujukan untuk profesional tingkat pemula hingga menengah yang ingin meningkatkan keterampilan mereka dalam mengekstraksi, menganalisis, dan memanipulasi data dalam Microsoft Access menggunakan kueri dan SQL. Pada akhir pelatihan ini, peserta akan dapat:
  • Memahami berbagai jenis query dalam Microsoft Access.
  • Gunakan alat desain kueri untuk mengekstrak dan menganalisis data secara efektif.
  • Tulis SQL kueri untuk mengambil dan memanipulasi data.
  • Melakukan agregasi, pemfilteran, dan penyortiran data menggunakan kueri.
  • Terapkan teknik kueri tingkat lanjut untuk pemecahan masalah dan pengoptimalan.
Read more...

SQL Development Bootcamp

 35 Hours
This instructor-led, live training in Jakarta (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge. By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
Read more...

SQL language in MSSQL

 14 Hours
The course answers questions
  • How to build a query?
  • What opportunities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

Last Updated:

Testimonials (11)

Gunnar menciptakan hubungan yang baik dengan para hadirin dan cepat mengidentifikasi kebutuhan kami. Ia sangat menarik dan berpengetahuan luas, dan kami menikmati humornya.

Kurt - Complete Coherence

Course - SQL For Data Science and Data Analysis

Machine Translated

Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.

Stefan

Course - SQL in SQL Server

analytical functions

khusboo dassani - Tech Northwest Skillnet

Course - SQL Advanced

The training materials.

Mona Dobre - DB Global Technology

Course - SQL Advanced level for Analysts

They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.

Aynanie Kiram - Aarki, Inc.

Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

Interactive exercises

Matthew Viner - Thames Water Utilites Ltd

Course - Transact SQL Basic

The course built lesson to lesson, and the pacing was a big deal for me.

Bradford Moore - Regis College

Course - SQL in MySQL

I genuinely enjoyed the lots of labs and practices.

Vivian Feng - Destination Canada

Course - Data Analysis with SQL, Python and Spotfire

The Trainer Subject Knowledge

Rares Serea - eMAG IT Research

Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.

Jim Lane

Course - Transact SQL Advanced

The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.

Shawn McAndrew

Course - SQL Fundamentals

Upcoming Courses (Minimal 5 peserta)

Data Analysis with SQL, Python and Spotfire

2025-05-26 09:30
14 hours
Grand Slipi Tower
40300000 IDR (Online)
40305454 IDR (Classroom)

Microsoft Access – Downloading Data

2025-06-09 09:30
14 hours
The City Tower
40300000 IDR (Online)
40305454 IDR (Classroom)

Microsoft Access – Downloading Data

2025-06-23 09:30
14 hours
Centennial Tower
40300000 IDR (Online)
40305454 IDR (Classroom)

Data Analysis with SQL, Python and Spotfire

2025-07-07 09:30
14 hours
Grand Slipi Tower
40300000 IDR (Online)
40305454 IDR (Classroom)

SQL Advanced

2025-07-21 09:30
14 hours
The City Tower
40300000 IDR (Online)
40305454 IDR (Classroom)

Other regions in Indonesia

Other Countries

These courses are also available in other countries

Consulting

SQL Consulting
Online SQL Pelatihan pada Jakarta, SQL kursus pelatihan pada Jakarta, Akhir pekan SQL Pelatihan pada Jakarta, SQL pelatihan pada Jakarta, SQL Instruktur Kepala pada Jakarta, Akhir pekan SQL Pelatihan pada Jakarta, SQL pelatihan satu lawan satu pada Jakarta, SQL kursus privat pada Jakarta, Online SQL Pelatihan pada Jakarta, SQL instruktur pada Jakarta, SQL instruktur kepala pada Jakarta, SQL Pelatihan pada Jakarta, SQL kelas pada Jakarta, Selamat malam SQL Pelatihan pada Jakarta, SQL di-tempat pada Jakarta, SQL kamp pelatihan pada Jakarta