.::: How To Configured Transaction IsolationLevel Level READ_COMMITED! on MySQL Server :::.

1. Get Error on log NMS

2015-06-15 12:06:57,158 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The MySQL Server must be configured for Transaction IsolationLevel Level READ_COMMITED!
2015-06-15 12:06:57,167 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The StableNet® Server will now exit due to this fatal error!
2015-06-15 12:06:57,174 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,178 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,184 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) If this problem occurs again at the same position please
2015-06-15 12:06:57,193 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) contact Infosim GmbH & Co. KG, support@infosim.net, +49 931 205 92 200

.::: Install OPManager NMS on Windows :::.

ManageEngine makes enterprise IT management software for IT administrators and IT managers working in small, medium, and large enterprises. It is a division of Zoho Corporation, a privately held company headquartered in Pleasanton, CA (USA) with offices in North America, Europe, and Asia.[1]

Formed in 1999, ManageEngine develops web-based software for Network management, Server and Application management, Active Directory management, Desktop Management, Mobile device management, IT help desk, and Security management.[2]

1. Install On Windows

.::: Simple Reset Password root MySQL on Windows, Solaris, Linux, Centos, Redhat, Freebsd, Ubuntu and another :::.

 MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ "My S-Q-L", and unofficially as /maɪ ˈsiːkwəl/ "My Sequel") is an open-source relational database management system (RDBMS); in July 2013, it was the world's second most[a] widely used RDBMS, and the most widely used open-source client–server model RDBMS. It is named after co-founder Michael Widenius's daughter, My. The SQL acronym stands for Structured Query Language. 

.::: Installation MySQL on Windows, Create User & Database on MySQL :::.

MySQL is a relational database management system (RDBMS), and ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools,^[21][22] or use MySQL "front-ends", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records.^{[23][24][25][26]} The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.^[27]

.::: Study Kasus Praktis belajar Query create & insert table MySQL / MariaDB (Create Data Warehouse) :::.

MariaDB merupakan versi pengembangan terbuka dan mandiri dari MySQL. Sejak diakuisisinya MySQL oleh Oracle pada September 2010, Monty Program sebagai penulis awal kode sumber MySQL memisahkan diri dari pengembangan dan membuat versi yang lebih mandiri yakni MariaDB. .


A. Management User
1. Loging Using root

create database teguht;
create user 'teguh' identified by 'triharto';
grant all privileges on teguht.* to 'teguh'@'%' identified by 'triharto' with grant option;
FLUSH PRIVILEGES;

c:\Program Files\MariaDB 10.1\bin>mysql -u root -p
Enter password: ****
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2752
Server version: 10.1.14-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database teguht;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> create user 'teguh' identified by 'triharto';

.::: Daftar Isi / Table Of Contents Teguh Triharto Learning Centre :::.

Lembar halaman yg menjadi petunjuk pokok isi buku beserta nomor halaman

A table of contents, usually headed simply "Contents" and abbreviated informally as TOC, is a list of the parts of a book or document organized in the order in which the parts appear. The contents usually includes the titles or descriptions of the first-level headers, such as chapter titles in longer works, and often includes second-level or section titles (A-heads) within the chapters as well, and occasionally even third-level titles (subsections or B-heads). The depth of detail in tables of contents depends on the length of the work, with longer works having less.

.::: Definition : Oracle Database SQL Certified Expert & ID Card & Syllabus :::.

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Retrieving Data Using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements  
• Execute a basic SELECT statement 
• Describe how schema objects work

.::: Study Kasus Praktis belajar SQL create & insert table Setelah Install Oracle Database (Create Data Warehouse):::.

SQL atau Structured Query Language) adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional. Bahasa ini secara de facto merupakan bahasa standar yang digunakan dalam manajemen basis data relasional. Saat ini hampir semua server basis data yang ada mendukung bahasa ini untuk melakukan manajemen datanya.

anda dapat juga download The Study Case & solution Lab Oracle & SQL Expert 

A. Management User
1. Loging Using system or sys as sysdba

C:\Users\teguh.triharto>sqlplus

.::: How To Using Aljabar(Algebra): union(gabungan), intersection(irisan), distinct (proyeksi), join/inner join/normal join/equal join(=),left outer join and right outer join In SQL :::.

Algebra (from Arabic al-jebr meaning "reunion of broken parts") is the branch of mathematics concerning the study of the rules of operations and relations, and the constructions and concepts arising from them, including terms, polynomials, equations and algebraic structures. Together with geometry, analysis, topology, combinatorics, and number theory, algebra is one of the main branches of pure mathematics. Algebra has numerous usages in daily life and is commonly taught in public schools.

.::: How To Using Query, Sub Query from one table or More in SQL :::.

=== 6. Query  and view ===
Query sebutan atau nama lain dari seleksi data yang merupakan bagian dari DML
Query as Selection data that one of DML


You can download The Study Case & solution Lab Oracle & SQL Expert

 == 6.1 seleksi satu tabel ==
== Selection from One Table ==
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT   field 1,...,field n, agregation function
FROM     table
WHERE      criteria
GROUP BY field 1,...,field n
HAVING      criteria_agregate_function
ORDER BY field
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

.::: How To Using min, max, avg, sum, count, Group by, order by, Having, where, comparison (=,<>,>,<,>= atau <=), Between, In, like / not like on Grouping, Sorting & Criteria Data In SQL Oracle :::.

=== Pengelompokan, pengurutan dan kriteria Data ===
=== How To Grouping, Sorting & Criteria Data ===

You can download The Study Case & solution Lab Oracle & SQL Expert 

== 5.1 pengelompokan data (group by) dan aggregation function ==
Sintak SQL
== 5.1.1 min() ==

 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT field 1,...,field n, MIN(name_field)
    FROM TABLE
    GROUP BY field 1,...,field m
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
== 5.1.2 max() ==
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT field 1,...,field n, MAX(name_field)
    FROM TABLE
    GROUP BY field 1,...,field m
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

.::: How To Insert, Update, Delete Data In DML(Data Manipulation language) SQL :::.

A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML

You can download The Study Case & solution Lab Oracle & SQL Expert 

=== 4.1 Memasukkan Data (Insert Data) ====
Sintak SQL
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
INSERT INTO name_table(field 1,...,Field n)
    VALUE(value_field 1,...,field n)
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

= Check Data Table =
select * from barang;
select * from suplier;
select * from customer;
select * from pasok;
select * from pembelian;

SQL> select * from barang;

.::: How To Create, Modify, Drop, Delete Table In DDL (Data Definition Language) SQL Oracle :::.

Cara Membuat, Memodifikasi, Menghapus Tabel dalam DDL

SQL adalah Structured Query Language. secara garis besar terdiri dari

1. DDL (Data Definition Language)

2. DML (Data Manipulating Language)

3. DCL (Data Control Language)

You can download The Study Case & solution Lab Oracle & SQL Expert 

1. Study Kasus = Inventory

Tabel Barang = Menggambarkan entitas barang dan terdiri atas atribut yang berkaitan dengan entitas barang. Atribut barang meliputi : kode_barang,nama_barang,satuan_barang dan stok barang

Tabel Suplier = Menggambarkan entitas suplier dan terdiri atas atribut atribut yang berkaitan dengan suplier. Atribut suplier meliputi : kode_suplier, nama_suplier, alamat_suplier, kota_suplier dan telepon_suplier