Training di Bidang
Teknologi Informasi

stockily070821131604-6195

MICROSOFT WORD, EXCEL DAN POWERPOINT

Program Objective

Setelah mengikuti program ini, maka peserta:

  • Level Basic dapat memahami dan mampu membuat dokumen sederhana menggunakan MS Word, Excel, dan Powerpoint.
  • Level Intermediate dapat memahami dan mampu membuat dokumen menggunakan MS Word, Excel, dan Powerpoint sesuai kebutuhan dengan cepat.
  • Level Advanced mampu membuat dokumen menggunakan MS Word, Excel, dan Powerpoint dengan cepat dan mampu mengembangkannya dengan kreatifitas.

Program Duration

Durasi Program per Tema Microsoft (Word / Excel / Powerpoint) = 1 Hari

Program Coverage

  • MENGOPERASIKAN MS WORD : Motivasi dan Wawasan Microsoft Word | Windows, Explorer, File Directory,.. | Pengenalan Tools ( file control (save, print, export), Clipboard, Font, Paragraph, Style, Editing, Pages, Tables, Illutration, chart, media, link, comment, header footer, text, symbol, theme, page background, page setup, arrange, referensces, Mailings, view,.. | Latihan membuat dokumen gabungan tools (surat menyurat, design,..) | Latihan membuat Project sesuai kebutuhan.
  • MENGOPERASIKAN MS EXCEL : Motivasi Wawasan Microsoft Excell | Pengenalan Tools (clipboard, font, alignment, number, style, cells, editing, table, pivot table, illustration, chart, sparklines, filter, link, symbol, page layout, page setup, scale, option sheet, cells, colums, rows, arrange, time setting, formula, data filter, sort, Developer, … | Formula (date time, math, statistical, lookup, logical) | Latihan membuat data laporan excell menggunakan gabungan fungsi | Latihan membuat Project sesuai kebutuhan.
  • MENGOPERASIKAN MS POWERPOINT : Motivasi Wawasan Microsoft Powerpoint | Pengenalan Tools (Clipboard, Slide, font, paragraph, drawing, editing, tables, images, illustration, link, comments, text, symbol, media, themes, customize, transition, timing, animation, slide show, view, macro,..) | Download video, Audio, Images untuk seni design powerpoint | Latihan membuat design presentasi yang menarik | Latihan membuat Project sesuai kebutuhan.

Bila anda memiliki pertanyaan atau ingin menjalin kerjasama dalam pelatihan ini, silakan hubungi kami.

Contact us

DATABASE MICROSOFT ACCESS, MICROSOFT SQL SERVER, ORACLE, POSTGRESQL, MYSQL, SYBASE SQL ANYWHERE

Program Objective

Setelah mengikuti program ini, maka peserta:

  • Level Basic Database Administrator dapat memahami tools dan mampu membuat struktur tabel query design database.
  • Level Intermediate Database Administrator dapat memahami dan mampu mengelola database menggunakan fungsi, sintax sql, dan user security.
  • Level Advanced Database Administrator mampu memilih dan membuat database dengan berbagai jenis database untuk saling terintegrasi.

Program Duration

Durasi Program per Tema Database = 1 Hari

Program Coverage

  • MICROSOFT ACCESS : Motivasi dan Wawasan Microsoft Access | Pengenalan Tools ( file control, Views, Clipboard, Sort & Filter, Records, Find, Text Formating, Aplication Templates, Tables, Queries, Forms, Reports, Macros & Code, Export Import, Links, Relationship, Analyze, Move Data, Properties, SQL Language,..) | Latihan Database Access Terintegrasi | Latihan membuat Project Database Access.
  • MICROSOFT SQL SERVER : Motivasi Wawasan Microsoft Sql Server | Materi Umum: Instalation, Services, Connection and ODBC, Relational Database Systems, SQL Server Management Studio (SSMS), Transact SQL language, Data Definition Language, Relationships and Data Integrity, Queries and Views, Stored Procedures and User-Defined Functions, Database Design Fundamentals, Creating Schemas, Tables and Diagrams, Data Definition Language (DDL) Fundamentals, SQL Server Objects and Simple Data Types, Defining Constraints and Relationships, Working with SQL Server Diagrams, Fundamentals of Data Manipulation Language (DML), Selecting, Inserting, Updating and Deleting Data from tables, Working with related tables, Creating Views and Stored Procedures, Creating User-Defined Functions, Exception-handling in Transact SQL, Working with Transactions, Securing the database | Latihan database sql server terintegrasi | Latihan membuat Project Database Sql Server.
  • ORACLE : Motivasi Wawasan Oracle | Materi Umum: Installation and Connection, Creating an Oracle Database, Managing the Oracle Instance, Managing Database Storage Structures, Administering User Security, Retrieving Data Using the SQL SELECT Statement, Restricting and Sorting Data, Using Single-Row Functions to Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using the Group Functions, Displaying Data from Multiple Tables, Using Subqueries to Solve Queries, Using the Set Operators, Manipulating Data, Using DDL Statements to Create and Manage Tables, Creating Other Schema Objects | Latihan database Oracle terintegrasi | Latihan membuat Project Database Oracle.
  • POSTGRESQL : Motivasi Wawasan Postgresql | Materi Umum: Installation and Connection, Intoduction database, DDL and DML, Tabel Relations, Join Table and Query, Function Aggregate, Sub Query, VIEW, TRIGGER, STORE PROCEDURE, User Management, Backup and Restore, tools PgAdmin | Latihan database Postgresql terintegrasi | Latihan membuat Project Database Postgresql.
  • MYSQL : Motivasi Wawasan Mysql | Materi Umum: Introducing the MySQL Relational, Installing MySQL, Working with MySQL, Designing a Relational Database, Managing Databases, Tables, and Indexes, Manipulating Data in a MySQL Database, Retrieving Data from a MySQL Database, Using Operators in Your SQL Statements, Using Functions in Your SQL Statements, Accessing Data in Multiple Tables, Exporting, Copying, and Importing Data, Managing Transactions, Administering MySQL, Managing MySQL Security, Optimizing Performance, Managing Backup, Recovery, and Replication | Latihan database Mysql terintegrasi | Latihan membuat Project Database Mysql.
  • SYBASE SQL ANYWHERE : Motivasi Wawasan Sql Anywhere | Materi Umum: Installation and Connection, Create Database, Table, Views, Join Table and Query, Manipulating Data, Indexes, Trigger, Procedures and Functions, Events, Users and Groups, Login Policies, DBSpaces, Diagram, Backup and Restore | Latihan database Sql Anywhere terintegrasi | Latihan membuat Project Database Sql Anywhere.

Bila anda memiliki pertanyaan atau ingin menjalin kerjasama dalam pelatihan ini, silakan hubungi kami.

Contact us
Contact Us
Contact Us