PT. HM. SAMPOERNA, Tbk. - Pasuruan Jawa Timur

INHOUSE TRAINING VBA MACRO PROGRAMMING

PT. PLN PERSERO MALUKU / MALUKU UTARA

INHOUSE TRAINING I.S GOVERNANCE

O-Shop, SCTV, Infotech (Jakarta)

PUBLIC TRAINING MAGENTO ADVANCED

PT. ASKRINDO - JAKARTA

PUBLIC TRAINING PMP PMBOK EXAM PREPARATION

Bank Fama International - Bandung

INHOUSE TRAINING CYBERSECURITY AWARENESS PROGRAM

Wednesday, July 22, 2020

Xampp cara akses localhost dari komputer lain , how to access xampp localhost from another computer

Berikut cara cara akses XAMPP localhost dari komputer lain , how to access xampp localhost from  another computer.

Buka httpd.conf

 
  • <Directory />
  • AllowOverride none
  • Require all denied
  • </Directory>
  • #ubah menjadi
  • <Directory />
  • AllowOverride All
  • Require all granted
  • </Directory>
    • Terakhir simpan dan restart service apace

    Tuesday, July 21, 2020

    TRAINER IT OUTSOURCING MANAGEMENT - HERY PURNAMA

    HERY PURNAMA 081223344506 - CORPORATE IT TRAINER FOR TRAINING IT OUTSOURCING MANAGEMENT WITH ITIL V.3


    SYLLABUS


    Durations : 2 Days (09.00 – 16.00)
    Descriptions
    IT Outsourcing Management Framework Based on ITIL Due to rapidly advances in technology, increasingly demands for IT applications and the inadequate supply of internal IT personnel, many organizations have looked for outside providers to effective product delivery and also to remain competitive. Therefore the need for governance in outsourcing relationships is undisputed. On the other hand service recipients and service providers have some difficulties to manage their outsourcing relationships. So in this paper, we would identify the main problems and challenges related to IT outsourcing. In addition, we will determine the ITIL V3 processes which are suitable and adaptable for outsourcing management. Then at the final stage a framework will be suggested which is arisen from the ITIL V3 framework. This framework would illustrate the practical processes and stages which are helpful in managing IT outsourcing resources

    What you'll learn
    -      You will learn how to manage your IT Outsourcing using ITIL V.3 Outsource Toolkit

    Requirements
    -      NO prior knowledge is required

    Who this course is for
    -      IT Manager
    -      IT Governance

    Contents
    Introductions
    -      introducing the outsourcing
    -      Introducing IT Governance, ITSM
    -      IT Outsourcing Relationships

    Outsourcing
    -      Outsourcing Definitions
    -      Benefits & Chalenges
    -      IT Outsourcing Strategies
    -      IT Outsourcing Governance

    Understanding of ITIL V.3 Lifecycle
    -      Service Strategy
    -      Service Design
    -      Service Transition
    -      Service Operation
    -      Continual Service Improvement

    IT Oursource Case Analysis
    -      Reasons of outsourcing project
    -      Benefits gain by outsourcing
    -      Problems of using outsourcing
    -      Time to solve any downtime problem by outsourcing company
    -      Level satisfaction of outsourcing service

    ITIL V.3 – IT Outsource Problems, Process and Function Alignment
    -      Downtime Problem
    -      Recurring same problem
    -      Cost Problem
    -      Misunderstanding of the contract statement.
    -      Misunderstanding of the requirements.
    -      Effective plan to manage the relationship with outsourcer.
    -      How to manage project when requirement change.
    -      Reduce additional cost and time when changes occur.
    -      Security problem when conducting with outsourcers
    -      Conduct, Control & Monitoring
    -      Conclusions






    Trainer MongoDB , Hery Purnama

    Hery Purnama 081223344506 is Corporate IT Trainer for MONGODB Developer and DBA training in jakarta, bandung, surabaya, for inquiry please whatsapp.


    Silabus Mongodb

    MONGODB FOR DEVELOPER

    DURATIONS : 5 DAYS (09.00-16.00)
    Description
    MongoDB is one of the most important NoSQL databases you can work with these days. It's extremely popular and MongoDB developers are in high demand.
    No matter if you're building web applications, mobile applications or any other kind of application or if you're a data scientist - you'll need to work with data. Storing data, querying it efficiently and minimizing complexities whilst optimizing performance are crucial tasks.
    MongoDB makes working with data simple - it's built on a philosophy that prioritizes performance and efficiency.
    In this course, you'll learn all about MongoDB from scratch. No prior MongoDB or database experience is required!

    What you'll learn
    Use MongoDB to its full potential in future projects
    Write efficient and well-performing queries to fetch data in the format you need it
    Use all features MongoDB offers you to work with data efficiently
    In detail, you'll learn
    >>  how to install and use MongoDB locally and in the cloud (MongoDB Atlas)
    >>  how to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases
    >>  how to filter for data efficiently
    >>  how to work with both the Mongo Shell and drivers (e.g. Node.js driver)
    >>  how to increase performance by using indexes (and how to use the right indexes!)
    >>  how to use the amazing "Aggregation Framework" that's built into MongoDB
    >>  what replica sets and sharding are
    >>  how to use MongoDB Atlas - the cloud solution offered by MongoDB
    >>  how to use the serverless platform (Stitch) offered by MongoDB
    >>  and much more!

    Requirements
    NO prior knowledge on databases (of any kind) is required
    General web development or mobile development knowledge will help you but is not a must-have
    You can use any operating system - Windows, macOS, Linux, it'll all work!
    This course is a hands-on course - you'll learn by writing code/ commands. We'll work on a wide variety of example data and use-cases and by the end of the course, you'll have all the knowledge you need to work with MongoDB in your next project!
    This course is for you, no matter which programming language you plan on using, you'll learn a uniform way of interacting with MongoDB that can be easily applied to any language.

    This course is for you
    >>  if you're brand-new to MongoDB and databases in general
    >>  if you got some basic database or even MongoDB experience - in this course, there are different entry points you can choose from!
    >>  if you are a web or mobile app (or desktop app) developer who considers using MongoDB
    >>  if you're working in a team that considers using MongoDB (or already does use it)
    >>  if you are primarily using SQL-based databases so far and you want to explore the most popular NoSQL alternative

    This course is NOT for you
    >>  if you're looking for a guide on administrating MongoDB servers => This course focuses on the commands/ queries you write, it's NOT an administration course

    Who this course is for
    Developers or data scientists who plan on (or are already) working with MongoDB
    Everyone who's interested in NoSQL databases
    Both beginner and advanced MongoDB users who want to explore all the core features

    Course content
    Introduction
    Introduction
    What is MongoDB?
    The Key MongoDB Characteristics (and how they differ from SQL Databases)
    Understanding the MongoDB Ecosystem
    Installing MongoDB
    MongoDB Installation FAQ + Support
    Time To Get Started!
    Shell vs Drivers
    MongoDB + Clients The Big Picture
    Course Outline
    How To Get The Most Out Of The Course

    Understanding the Basics & CRUD Operations
    Module Introduction
    Understanding Databases, Collections & Documents
    The Shell & MongoDB Drivers for Different Languages
    Creating Databases & Collections
    Understanding JSON Data
    Comparing JSON & BSON
    Create, Read, Update, Delete (CRUD) & MongoDB
    Finding, Inserting, Deleting & Updating Elements
    Understanding "insertMany()"
    Diving Deeper Into Finding Data
    "update" vs "updateMany()"
    Understanding "find()" & the Cursor Object
    Understanding Projection
    Embedded Documents & Arrays - The Theory
    Working with Embedded Documents
    Working with Arrays
    Accessing Structured Data
    Time to Practice - The Basics & CRUD Operations

    Schemas & Relations How to Structure Documents 
    Resetting Your Database
    Module Introduction
    Why Do We Use Schemas?
    Structuring Documents
    Data Types - An Overview
    Data Types in Action
    Data Types & Limits
    How to Derive your Data Structure - Requirements
    Understanding Relations
    One To One Relations - Embedded
    One To One - Using References
    One To Many - Embedded
    One To Many - Using References
    Many To Many - Embedded
    Many To Many - Using References
    Summarizing Relations
    Using "lookUp()" for Merging Reference Relations
    Planning the Example Exercise
    Implementing the Example Exercise
    Understanding Schema Validation
    Adding Collection Document Validation
    Changing the Validation Action

    Exploring The Shell & The Server
    Finding Available Options
    Setting "dbpath" & "logpath"
    Exploring the MongoDB Options
    MongoDB as a Background Service
    Using a Config File
    Shell Options & Help

    Using the MongoDB Compass to Explore Data Visually
    Module Introduction
    Exploring the MongoDB Compass

    Diving Into Create Operations
    Creating Documents - An Overview
    Understanding "insert()" Methods
    Working with Ordered Inserts
    Understanding the "writeConcern"
    The "writeConcern" in Practice
    What is Atomicity?
    Time to Practice - Create Operations

    Read Operations - A Closer Look Module Introduction
    Methods, Filters & Operators
    Operators - An Overview
    Query Selectors & Projection Operators
    Understanding "findOne()" & "find()"
    Working with Comparison Operators
    Querying Embedded Fields & Arrays
    Understanding "$in" and "$nin"
    "$or" and "$nor"
    Understanding the "$and" Operator
    Using "$not"
    Diving Into Element Operators
    Working with "$type"
    Understanding Evaluation Operators - "$regex"
    Understanding Evaluation Operators - "$expr"
    Time to Practice - Read Operations
    Diving Deeper Into Querying Arrays
    Using Array Query Selectors - "$size"
    Using Array Query Selectors - "$all"
    Using Array Query Selectors - "$elemMatch"
    Time to Practice - Array Query Selectors
    Understanding Cursors
    Applying Cursors
    Sorting Cursor Results
    Skipping & Limiting Cursor Results
    Using Projection to Shape our Results
    Using Projection in Arrays
    Understanding "$slice"
    Useful Resources & Links

    Update Operations
    Updating Fields with "updateOne()", "updateMany()" and "$set"
    Updating Multiple Fields with "$set"
    Incrementing & Decrementing Values
    Using "$min", "$max" and "$mul"
    Getting Rid of Fields
    Renaming Fields
    Understanding "upsert()"
    Updating Matched Array Elements
    Updating All Array Elements
    Finding & Updating Specific Fields
    Adding Elements to Arrays
    Removing Elements from Arrays
    Understanding "$addToSet"

    Understanding Delete Operations
    Understanding "deleteOne()" & "deleteMany()"
    Deleting All Entries in a Collection

    Working with Indexes
    What Are Indexes & Why Do We Use Them?
    Adding a Single Field Index
    Indexes Behind the Scenes
    Understanding Index Restrictions
    Creating Compound Indexes
    Using Indexes for Sorting
    Understanding the Default Index
    Configuring Indexes
    Understanding Partial Filters
    Applying the Partial Index
    Understanding the Time-To-Live (TTL) Index
    Query Diagnosis & Query Planning
    Understanding Covered Queries
    How MongoDB Rejects a Plan
    Using Multi-Key Indexes
    Understanding Text Indexes
    Text Indexes & Sorting
    Creating Combined Text Indexes
    Using Text Indexes to Exclude Words
    Setting the Default Language & Using Weights

    Working with Geospatial Data
    Module Introduction
    Adding GeoJSON Data
    Running Geo Queries
    Adding a Geospatial Index to Track the Distance
    Adding Additional Locations
    Finding Places Inside a Certain Area
    Finding Out If a User Is Inside a Specific Area
    Finding Places Within a Certain Radius
    Time to Practice - Geospatial Data

    Understanding the Aggregation Framework
    What is the Aggregation Framework?
    Getting Started with the Aggregation Pipeline
    Using the Aggregation Framework
    Understanding the Group Stage
    Diving Deeper Into the Group Stage
    Time to Practice - The Aggregation Framework
    Working with $project
    Turning the Location Into a geoJSON Object
    Transforming the Birthdate
    Using Shortcuts for Transformations
    Understanding the $isoWeekYear Operator
    $group vs $project
    Pushing Elements Into Newly Created Arrays
    Understanding the $unwind Stage
    Eliminating Duplicate Values
    Using Projection with Arrays
    Getting the Length of an Array
    Using the $filter Operator
    Applying Multiple Operations to our Array
    Understanding $bucket
    Diving Into Additional Stages
    How MongoDB Optimizes Your Aggregation Pipelines
    Writing Pipeline Results Into a New Collection
    Working with the $geoNear Stage

    Working with Numeric Data
    Number Types - An Overview
    MongoDB Shell & Data Types
    Understanding Programming Language Defaults
    Working with int
    Working with int
    Doing Maths with Floats ints & ints
    What's Wrong with Normal Doubles?
    Working with Decimal bit

    MongoDB & Security
    Module Introduction
    Understanding Role Based Access Control
    Creating a User
    Assigning Roles to Users & Databases
    Updating & Extending Roles to Other Databases
    Time to Practice - Security
    Adding SSL Transport Encryption
    Encryption at REST

    Performance, Fault Tolerancy & Deployment
    What Influences Performance?
    Understanding Capped Collections
    What are Replica Sets?
    Understanding Sharding
    Deploying a MongoDB Server
    Using MongoDB Atlas
    Backups & Setting Alerts in MongoDB Atlas
    Connecting to our Cluster

    Transactions
    What are Transactions?
    A Typical Usecase
    How Does a Transaction Work?

    From Shell to Driver
    Splitting Work Between the Driver & the Shell
    Preparing our Project
    Installing Visual Studio Code
    Installing the Node.js Driver
    Connecting Node.js & the MongoDB Cluster
    Storing Products in the Database
    Storing the Price as bit Decimal
    Fetching Data From the Database
    Creating a More Realistic Setup
    Getting a Single Product
    Editing & Deleting Products
    Implementing Pagination
    Adding an Index
    Signing Users Up
    Adding an Index to Make the Email Unique
    Adding User Sign In

    Introducing Stitch
    Module Introduction
    Stitch & MongoDB Realm
    What is Stitch?
    Preparations
    Start Using Stitch
    Adding Stitch to our App & Initializing It
    Adding Authentication
    Sending Data Access Rules
    Fetching & Converting Data
    Deleting Products
    Finding a Single Product
    Adding Products
    Updating Products
    Switching to User Email & Password Authentication
    Adding User Sign Up & Confirmation
    Adding User Login
    Rules & Real Users
    The Current State of Authentication
    Functions & Triggers

    Trainer IBM Cognos Analytics - Hery Purnama

    Hery Purnama 081223344506 is a Corporate IT trainer for training IBM Cognos Analytics in jakarta bandung surabaya yogya.

    What is IBM Cognos Analytics ?
    Most of Indonesia Banking Industries are use  IBM Cognos Analytics for their business intelegence and data analytics tool.



    IBM Cognos Business Intelligence is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company. IBM Cognos has components such as IBM Cognos Framework Manager, IBM Cognos Cube Designer, IBM Cognos Transformer.

    SYLLABUS


    Durations : 4 Days (09.00 – 16.00)

    Description
    The latest version of IBM Cognos Business Intelligence is Cognos Analytics and it brings IBM right back into the game against new-age competitors such as QlikView and Tableau. This sleek, next-generation, unified tool provides you with a fast, intent-driven dashboard and report-authoring interface on top of the strong foundation that IBM Cognos has provided over decades.
    The highlights of this Learning Path are
    Explore Cognos and it’s high level architecture
    Augment enterprise data with your offline data to produce stunning dashboards and presentations without IT costs
    Learn to secure your data with advanced filters


    What you'll learn
    Learn to build stunning Dashboards with Cognos Analytics
    Learn how and when to use visualization
    Create tabbed dashboards and stories using the new Dashboard tool of Cognos
    Master the full-fledged Report Authoring tool
    Understand how a dashboard is different from a report, and when to use both
    Understand the Reporting Interface
    Implement crosstabs and SQL queries

    Requirements
    Basic knowledge of data and relationship between variety of data

    Who this course is for
    This Learning Path is targeted at
    Accountants, managers, controllers, sales heads, and so on will find this Learning Path useful for their day to day work and career progression
    Developers, business analysts, testers, product owners of reporting system / data warehouse / MIS can use Cognos Analytics (Cognos) to author dashboards and stories within IT department

    Course content
    Using IBM Cognos Analytics
    ·         Introduction to Business Intelligence
    ·         Cognos and Its High-Level Architecture
    ·         Setting Up an Account for Cognos on the Cloud
    ·         Welcome Portal
    ·         Where’s Report Studio Gone?
    ·         Your First Dashboard
    Taking Data Modules to Next Level
    ·         On the Back Stage – Connecting to Databases
    ·         Creating Your Own Data Modules
    ·         Adding Your Own Data to Dashboards
    ·         Improving Module – Examining the Data Model
    ·         Refining Module – Filtering and Cleaning
    ·         Extending Module – Creating Custom Calculations
    ·         Generating Stitched Facts – How and Why?
    Dashboard Authoring in Detail

    ·         How to Change Visualization Properties?
    ·         Singletons, Static Texts, and Display Order
    ·         Changing Widget Connections
    ·         Navigation Group for Drill Down

    Creating a Story and Giving Finishing Touch
    ·         Creating a Story Using Pins
    ·         Changing the Theme and Background
    ·         Adding Multimedia and Info-Graphics
    ·         Sharing Story and Dashboard Using Custom URL
    ·         First Guide to Dashboards using IBM Cognos Analytics

    Going beyond Dashboards with IBM Cognos Analytics
    ·         Printability
    ·         Crosstabs
    ·         Detailed Properties of Visualizations
    ·         Drill-Through to Another Report
    ·         Master-Detail Relationship/Repeaters
    ·         Opening the Report Interface
    ·         Adding Data
    ·         Adding Report Pages and Prompt Pages
    ·         Toolbox
    ·         Crosstab in Detail
    ·         Nested Crosstab
    ·         Discontinuous Crosstab
    ·         Examining and Overriding SQL Queries
    ·         Populating Values in Prompt Control
    ·         Using Prompt Parameters
    ·         Mandatory and Optional Prompts
    ·         Cascading Prompt
    ·         Prompts on Report Page
    ·         Difference between Charts and Extensible Visualizations
    ·         Heatmap Visualization
    ·         Gauge Control
    ·         Sparkline
    ·         Container within Container
    ·         Drill-Through to Another Report (Drill-Through Links)
    ·         Finishing Touches
    ·         Going beyond Dashboards with IBM Cognos Analytics

    TRAINER IT ASSET MANAGEMENT

    HERY PURNAMA 081223344506 CORPORATE IT TRAINER FOR TRAINING SUBJECT IT ASSET MANAGEMENT IN JAKARTA BANDUNG YOGYA SURABAYA, FOR INQUIRY PLEASE CONTACT MY WHATSSAPP



    SYLLABUS IT ASSET MANAGEMENT


    IT ASSET MANAGEMENT (ITAM)



    Duration
    :
     3  Days (09.00 – 16.00)



    Desciptions
    :
    According to the International Association of IT Asset Managers (IAITAM), IT Asset Management (ITAM) is “a set of business practices that incorporates IT assets across the business units within the organization. It joins the financial, inventory, contractual and risk management responsibilities to manage the overall life cycle of these assets including tactical and strategic decision making”. Assets include all elements of software and hardware that are found in the business environment.
    IT asset management is sometimes referred to as IT inventory management because it typically involves gathering detailed hardware and software inventory information which is then used to make decisions about purchases and how assets are used. Having an accurate IT asset inventory helps companies use their assets more effectively and avoid unnecessary asset purchases by re-using existing resources. IT asset management also enables organizations to lower the risks costs of unknowingly building new IT projects on outdated (or unknown) infrastructure foundations.
    IT Asset management is made effective using metadata and electronic records to track and categorize the organization’s assets. Metadata is the description of the physical or digital asset and any supporting information that is needed to inform asset management decisions. The metadata depth can vary depending on the needs of the organization.




    Objectives
    :
    ·         Complete overview of IT Asset Management concepts
    ·         Successfully apply IT Asset Management best practices to build and maintain IT Assets
    ·         Identify the practices leading to sustainable IT Asset Management programs that maximize value to the organization and meet goals specified
    ·         Determine and execute next steps, and evaluate success within the organization’s unique culture, strengths and weaknesses
    ·         An practical approach towards ITAM



    Participants
    :
    -          IT Professionals
    -          IT Stakeholders
    -          Newbies to IT Industry




    Prerequisites
    :
    Anyone who wants learn about IT Asset Management

    Details



    :

    DAY 1
    ITAM Definition
    Benefit of ITAM
    Need of ITAM
    ITAM Life-cycle

    Day 2
    IT Asset Management Processes
    IT Asset Return Process
    Processing Lost and Stolen Assets
    IMACD (Install,Move,Add,Change,Disposal)

    Day 3
    KPI and Metrics
    Policy, Process, Procedure
    ITAM Maturity Model
    ITAM Tools Selection













    Trainer :
    Mr. Hery Purnama,
    MCP, PMP, ITILF, CISA, CDMP, CTFL