dibuka Program Training Online / Webinar !

Tetap bisa training sekalipun #diRumahAja

PUBLIC TRAINING - PURNAMA ACADEMY

Kami Bekerjasama dengan hotel bintang di 4 kota Bandung-Jakarta-Bali-Cikarang untuk memberikan kenyamanan peserta public training

REQUEST FOR INHOUSE TRAINING

Inhouse Training adalah pilihan paling tepat untuk jumlah peserta perusahaan yang banyak dengan mengutamakan efisiensi biaya training.

PORTFOLIO : INHOUSE TRAINING ANDROID - PLN MALUKU

Inhouse Training Android Application Development di PT. PLN Wilayah Maluku selama 4 hari

PORTFOLIO : INHOUSE TRAINING MAGENTO - INFOTECH JAKARTA

Inhouse Training Magento E-Commerce berdurasi 7 hari dibagi 2 sesi Fundamental dan Advanced.

Friday, November 13, 2020

TRAINING IT PROJECT MANAGEMENT

IT PROJECT MANAGEMENT
Duration    :    2 Day (09-00 – 15.00)
Online
       
Description    :    What are the skills and capabilities required to succeed as an IT project manager?
The evidence suggests that the success rate for IT projects is poor  - more than half of projects are challenged in some aspect, whether in terms of cost, time or the quality of what is delivered.
Outstanding IT project managers understand that, in the real world, successful IT projects isn't just about crafting a project plan - it's about assessing the ROI of projects, defining a clear scope, estimating in a rational manner, building a high-performance team, managing stakeholder expectations, and more.
This course is designed for those involved in managing IT projects.  Unlike PMP, this course is specific to IT projects, which have their own distinct set of complexities.
The course is broken down into distinct, easy to digest modules:
•    Develop a project mindset
•    Prepare a project proposal
•    Manage project scope and requirements
•    Plan and schedule projects
•    Estimate projects in a rational manner
•    Manage stakeholder expectations
•    Conduct agile projects
•    Build a high-performance project team
•    Analyse project risk
•    Manage a project portfolio
       
       
Goals & Values        •    This Purnama Academy training topic will give you the understanding of : Develop a project mindset, Prepare a project proposal, Manage project scope and requirement, Plan and schedule projects, Estimate projects in a rational manner, Manage agile projects, Build a high-performance team, Analyse project risk, Manage a project portfolio
 

Participants    :    •    IT project managers
•    Individuals preparing to take on an IT project manager role
•    IT professionals seeking to enhance their project management skills

       
Prerequisites    :    At least has 1 year in  IT project experience
       
Details    :    IT Project Management Review
Develop a project mindset  
•    Diversity of IT projects

•    Project characteristics and the project goal

•    Essential concepts in project management

•    What is project management?

•    Project success triple constraints and project outcomes

•    Project trade-offs

•    Project lifecycle

•    Qualities of a project manager

Prepare a project proposal  
•    Writing a project proposal

•    Bedenk's project canvas

•    Getting buy-in

Manage project scoping and requirements  
•    Importance of scope

•    Project versus product scope

•    Visualising scope

•    Directional versus deliverable requirements

•    Requirements as a major pain point

•    Fixing requirements later is more expensive

•    The requirements process  activities

•    Two methods wire-framing and competitive benchmarking

•    Prioritising requirements using MOSCOW and priority matrix

•    Evaluating requirements in a SMART way

Plan and schedule projects  
•    Introduction to project planning

•    Decomposition and breakdown structures

•    Creating a Work Breakdown Structure (WBS)

•    Responsibilty matrix

•    Examining Project dependencies

•    Gantt and PERT charts

•    Evaluating project plans

Estimate projects in a rational manner  
•    What is estimation?

•    Parkinson's law

•    Estimation methods

•    Bias in estimation

•    Delphi method

•    Cone of uncertainty

•    -point estimation

Manage agile projects  
•    Backwards versus forwards planning

•    Shift towards agile systems

•     agile principles

•    Introduction to SCRUM

•    Traditional versus agile approach

•    Challenges with agile

•    Practical advice for agile

Build a high-performance project team  
•    Group versus team

•    High-performance vs. low-performance teams

•    Tuckman model of team development

•    Belbin's Team Inventory (BTI)

•    Team chemistry

•    Creating a positive team culture

•    Negativity in the workplace

•    Building a team of 'A' players

Analyse project risk  
•    All projects have risk

•    Mckinsey-Oxford study in project failure

•    The risk management process

•    The risk assessment matrix

•    Four strategies for managing risk

•    Project feasibility

•    Tools for managing risk - prototyping, pilot project and descoping

Managing a project portfolio  
•    Need for project portfolio management (PPM)

•     layers - portfolio, programme and projects

•    -step process for PPM

•    Project selection

•    Calculating net present value (NPV)

•    Project selection matrix

•    Benefits of PPM

     
 


       



TRAINING SQL SERVER PERFORMANCE TUNING AND OPTIMIZING SQL DATABASES

 

Description    :    You will get a conceptual understanding of various SQL Server database performance issues and learn about different places to check for the performance information along with tuning approach.

Broadly this Purnama Academy training  topic will cover following:
Understanding SQL Server waits and how to resolve it.
Tempdb contention issues.
Learn about database statistics, optimizer and maintenance plan for tables and indexes.
SQL Tuning techniques.
Partition in SQL Server.
General guidelines for avoiding performance issues in SQL database.
       
       
Goals & Values        This training  will provide comprehensive material of SQL Server performance tuning along with handy tips for issue resolution.
Provide details about SQL waits and resolution.
Learn about database statistics, optimizer and maintenance plan for tables and indexes.
SQL Tuning techniques
General guidelines for avoiding performance issues in SQL database.
 

Participants    :    •    This course is meant for all levels of SQL professionals (developers and DBA's). It provides roadmap of how to diagnose and resolve performance issues related to SQL Server database. Pre-requisite for this course is basic understanding of SQL Server and T-SQL.
•   
       
Prerequisites    :    Basic understanding of SQL Server and some experience in writing T-SQL
       
Details    :    SQL Server Performance Tuning Overview
SQL Server Waits Lesson
•    How SQL Server executes query
This lecture provide details about following topics
. How SQL executes query.
. Query life cycle.
Pratinjau
•    Waits -
This lecture provide details about following topics
1.    Understanding waits in SQL.
2.    Details on wait types.
3.    CX packet waits.
4.    async_network_io_wait

•    Waits -
This lecture provide details about following topics
1.    Pageiolatch_ex wait details and tips to reduce this wait.
2.    sos_scheduler_yield wait details.
3.    Theadpool

•    Waits-Lesson Exercise
This Lesson Exercise section will provide details on how to get wait details on SQL server.
1.    Check blocking session and wait details.
2.    Query to check if server is under CPU pressure.
3.    Query to check waits details on server.
4.    IO wait details query.

•    SQL Server performance counters
This lecture provides information about SQL server performance counters and description of some important counters related to performance tuning.

Indexes
•    Index Types
This lecture covers following topics
1.    Index structure.
2.    Index types
3.    difference between clustered vs non-clustered indexes.

•    Index Lesson Exercise -
This Lesson Exercise provides information on how to create clustered and non-clustered indexes in sql server and which system tables to refer to get information about indexes in database.

•    Un-used and missing indexes
This lecture covers following topic
1.    Column order
2.    missing index information in sql
3.    un-used index information

•    Index Lesson Exercise -
This Lesson Exercise will provide information on affect of multiple indexes on query. It also Lesson Exercisenstrate the affect of column order in index and in SQL query. Finally we will look, how we can retrieve missing index and un-used index information in SQL server.


•    Index Maintenance
This lecture provides information about following topics
1.    Fragmentation in SQL server
2.    Caused of fragmentation and page split
3.    Index maintenance plans
4.    Index rebuild vs Index reorganize options.

•    Index Lesson Exercise -
This Lesson Exercise list the scripts for the index maintenance we usually perform on sql server databases.

Tempdb
•    Tempdb Contents
This lecture provide information on
1.    Tempdb content.
2.    Tempdb user objects
3.    Tempdb size.

•    Tempdb Content Lesson Exercise
This Lesson Exercise list the scripts which help us see content of tempdb.

•    Tempdb Best practices
This lecture provide details on best practices for the tempdb files.

•    Tempdb Contention
This lecture provides information on following topics
1.    Space Allocation in SQL
2.    Latch contention
3.    How to avoid latch contention

•    Tempdb Lesson Exercise
Lesson Exercise to check tempdb speed and temdb file usuage.

Diagnostic Tools
•    Statistics IO and Statistics Time

•    Diagnostic Tools - Lesson Exercise

•    SQL Server Profiler

•    Activity Monitor Lesson Exercise

SQL Databse Query Tuning
•    Introduction
This lecture provides basics of query tuning and which queries to tune.

•    Optimizer Hints
This lecture provides information on Optimizer hints and general sql optimization techniques.

•    Parameter Sniffing
This lecture provides basics of parameter sniffing and details on how to resolve it.

•    Parameter Sniffing Lesson Exercise
Scripts in this Lesson Exercise Lesson Exercisenstrates parameter sniffing scenarios and resolution techniques.

•    Server Configuration
This lecture explains what happens when we change some server level parameters like  Cost threshold for parallelism, Max degree of parallelism

Partition in SQL Server
•    Partition
This lecture provides information on what is partition and how it is useful for easy maintenance of tables and in performance tuning.

Lesson Exercise Scripts
•    Waits Lesson Exercise

•    Index Lesson Exercise Scripts

•    Tempdb Lesson Exercise Scripts

•    SQL Tuning Lesson Exercise Scripts

•    Diagnostic Tools Lesson Exercise scripts



     
 


       
 

Sunday, November 1, 2020

TRAINING APACHE NIFI DATAFLOW - JAKARTA, BANDUNG, ONLINE

Purnama Academy Training Center Bandung (0838-0838-0001)  provides Apache Nifi Training for individual, company and groups (Online / ofline public and inhouse training) , please contact our sales 


What is Apache Nifi ?
Put simply, NiFi was built to automate the flow of data between systems. While the term 'dataflow' is used in a variety of contexts, we use it here to mean the automated and managed flow of information between systems. This problem space has been around ever since enterprises had more than one system, where some of the systems created data and some of the systems consumed data. The problems and solution patterns that emerged have been discussed and articulated extensively. A comprehensive and readily consumed form is found in the Enterprise Integration Pattern

Some of the high-level challenges of dataflow include:

Systems fail
Networks fail, disks fail, software crashes, people make mistakes.

Data access exceeds capacity to consume
Sometimes a given data source can outpace some part of the processing or delivery chain - it only takes one weak-link to have an issue.

Boundary conditions are mere suggestions
You will invariably get data that is too big, too small, too fast, too slow, corrupt, wrong, or in the wrong format.

What is noise one day becomes signal the next
Priorities of an organization change - rapidly. Enabling new flows and changing existing ones must be fast.

Systems evolve at different rates
The protocols and formats used by a given system can change anytime and often irrespective of the systems around them. Dataflow exists to connect what is essentially a massively distributed system of components that are loosely or not-at-all designed to work together.

Compliance and security
Laws, regulations, and policies change. Business to business agreements change. System to system and system to user interactions must be secure, trusted, accountable.

Continuous improvement occurs in production
It is often not possible to come even close to replicating production environments in the lab.

Over the years dataflow has been one of those necessary evils in an architecture. Now though there are a number of active and rapidly evolving movements making dataflow a lot more interesting and a lot more vital to the success of a given enterprise. These include things like; Service Oriented Architecture [soa], the rise of the API [api][api2], Internet of Things [iot], and Big Data [bigdata]. In addition, the level of rigor necessary for compliance, privacy, and security is constantly on the rise. Even still with all of these new concepts coming about, the patterns and needs of dataflow are still largely the same. The primary differences then are the scope of complexity, the rate of change necessary to adapt, and that at scale the edge case becomes common occurrence. NiFi is built to help tackle these modern dataflow challenges.