SQL Server

Actual Training

Training SQL Server Performance Tuning

Pada tanggal 23 – 25 Juni 2025 telah dilaksanakan training dengan judul SQL Performance Tuning. Pelatihan ini diikuti oleh peserta dari PT Adaro Logistics.

Pelatihan ini membekali peserta dengan keterampilan penting untuk mengoptimalkan kinerja database SQL Server. Materi mencakup dasar-dasar Query Tuning Assistant, strategi untuk menganalisis dan meningkatkan efisiensi query, serta teknik optimasi tingkat lanjut. Di akhir pelatihan, peserta diharapkan mampu untuk mendiagnosis dan menyelesaikan masalah performa, sehingga SQL Server dapat berjalan secara optimal. Pelatihan ini sangat cocok bagi mereka yang ingin meningkatkan performa database melalui penerapan yang praktis di dunia nyata. Adapun beberapa materi yang dibahas pada pelatihan ini meliputi:

  • Foundations of Query Tuning     
  • Interpret and Apply Query Optimizations             
  • Analyzing the Query Store Metrics 
  • Developing a Plan for Continuous Improvement
  • Mastering Execution Plan and Query Optimization
  • Advance Indexing Strategies and Performance Tuning

Jika anda tertarik mengikuti pelatihan ini, anda bisa mengirimkan request ke email info@actual-training.com untuk mendapatkan silabus lengkap beserta dengan penawarannya.

Actual Training

Pelatihan Microsoft SQL Server Integration Services and Analysis Services

Pada tanggal 18-20 Maret 2020 telah dilangsungkan pelatihan inhouse dengan topik Microsoft SQL Server Integration Services and Analysis Services. Peserta dari pelatihan kali ini adalah pengembang aplikasi dari PT Focus Inti Solusi, Jakarta. PT Focus Inti Solusi merupakan salah satu perusahan pengembang software yang mempunyai spesialisasi di multifinance dan fintech.

Trainer pada pelatihan ini adalah Bapak Kiki Rizki Noviandi yang merupakan salah satu Microsoft MVP (Most Valuable Professional) di bidang SQL Server.

Adapun materi yang dibahas pada pelatihan ini adalah sebagai berikut:

  • Understand MSBI application development Life Cycle.
  • Understand basic Data Warehousing Concepts.
  • Understand the Concept of OLTP and OLAP.
  • Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • Learn SSIS Architecture, Components of SSIS.
  • Gain complete understanding of different control flow tasks, containers and precedence
    constraints.
  • Learn to work with variables, data types, functions, expressions and parameters and
    providing Dynamism in SSIS.
  • Learn working with event handler, Logging, Configuration Files.
  • Learn Error Handling and Debugging in SSIS.
  • Learn package deployment and project deployment.
  • Gain understanding of Security and Package management.
  • Understand need of OLAP.
  • Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table,
  • Fact Table, Hierarchies etc
  • Understand Star and Snow Flake Schema.
  • Use SSDT (SQL Server Data Tools) to develop OLAP Database
  • Work with Data Source and data Source View.
  • Develop Cube using Cube Wizard.
  • Create Dimensions using Wizard and Designer.
  • Work with Regular, Snow Flake and Time Dimension
  • Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
  • Work with attribute relationship, Role playing dimension.
  • Work with measure group, adding removing measures.
  • Understand relationships like Fact relationship, referenced relationship etc.
  • Work with Calculation, Named Query and Named Calculation.
  • Work with KPI, Perspective, Translation.
  • Work with Partition, Aggregation.
  • Understand different storage modes like ROLAP, MOLAP and HOLAP
  • Work with Security, Roles
  • Understand Processing and Deployment.
  • Learn MDX (Multidimensional Expressions Language).

1

Actual Training

Pelatihan Microsoft SQL Server Integration Services and Analysis Services (PT EPSON)

Pada tanggal 23-25 Oktober 2019 telah dilangsungkan pelatihan inhouse dengan topik Microsoft SQL Server Integration Services and Analysis Services. Peserta dari pelatihan kali ini adalah pengembang aplikasi dari divisi Sistem Informasi PT EPSON Batam.

Trainer pada pelatihan ini adalah Bapak Kiki Rizki Noviandi yang merupakan salah satu Microsoft MVP (Most Valuable Professional) di bidang SQL Server.

Adapun materi yang dibahas pada pelatihan ini adalah sebagai berikut:

  • Understand MSBI application development Life Cycle.
  • Understand basic Data Warehousing Concepts.
  • Understand the Concept of OLTP and OLAP.
  • Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • Learn SSIS Architecture, Components of SSIS.
  • Gain complete understanding of different control flow tasks, containers and precedence
    constraints.
  • Learn to work with variables, data types, functions, expressions and parameters and
    providing Dynamism in SSIS.
  • Learn working with event handler, Logging, Configuration Files.
  • Learn Error Handling and Debugging in SSIS.
  • Learn package deployment and project deployment.
  • Gain understanding of Security and Package management.
  • Understand need of OLAP.
  • Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table,
  • Fact Table, Hierarchies etc
  • Understand Star and Snow Flake Schema.
  • Use SSDT (SQL Server Data Tools) to develop OLAP Database
  • Work with Data Source and data Source View.
  • Develop Cube using Cube Wizard.
  • Create Dimensions using Wizard and Designer.
  • Work with Regular, Snow Flake and Time Dimension
  • Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
  • Work with attribute relationship, Role playing dimension.
  • Work with measure group, adding removing measures.
  • Understand relationships like Fact relationship, referenced relationship etc.
  • Work with Calculation, Named Query and Named Calculation.
  • Work with KPI, Perspective, Translation.
  • Work with Partition, Aggregation.
  • Understand different storage modes like ROLAP, MOLAP and HOLAP
  • Work with Security, Roles
  • Understand Processing and Deployment.
  • Learn MDX (Multidimensional Expressions Language).

epson_pak_Kiki_1_thumb[2]

Actual Training

Pelatihan SQL Server Performance Tuning and Optimization (PT EPSON)

Pada tanggal 24-26 September 2018 telah dilaksanakan Pelatihan inhouse training dengan Judul SQL Server Performance Tuning and Optimization. Pelatihan ini diikuti oleh 13 orang peserta. Peserta dari pelatihan ini adalah developer dari PT EPSON Batam, Kepulauan Riau.

Adapun topik yang dibahas pada pelatihan ini adalah sebagai berikut:

  • SQL Server Architecture
  • SQL Server I/O
  • Database Structures
  • SQL Server Memory
  • SQL Server Concurrency
  • Statistics and Index Internals
  • Query Execution and Query Plan Analysis
  • Plan Caching and Recompilation
  • Tips for Optimizing SQL Server Performance

12