.::: 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

.::: How to Check Host ID, UUID on Solaris & Check Solaris Version :::.

1. Check Host ID Solaris

The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change this hostid for whatever purpose. For example, you current machine is down for hardware failure and you purchased a new machine.

However, all your current running software are based on this old hostid, and you must bring the new machine up within a very short time. The quick solution is to change the new machine’s hostid to be as same as the old one.

.::: How To Enable VNCserver on Solaris 10 :::.

Abstract:

Open Systems have traditionally been accessed via Command Line. MIT create a fully object oriented, multi-tiered, open source windowing system called X Windows, which was quickly adopted by nearly all computing industry players. While X Windows is well suited for local area network technology, the need for wide area network technology was addressed through several different attempts, such as X11R6 "Broadway" and proxies leveraging compression. A lighter WAN suitable screen display protocol, referred to as Virtual Network Computing (VNC) is also commonly used for X displays.

bagaimana cara mensetting vncserver di solaris 10

Procedure:

.::: How To Setting NTP Server & Client In Solaris 10 :::.

Setting NTP ( Network Time Protocol) on Solaris 10

Example add the IP NTP Server (example 10.10.10.10) of the "server" and comment out `fudge 127.127.XType.0 stratum 0`

A. Configuring an NTP Server

1. Go to Directory # cd /etc/inet
Log :
root@teguht # cd /etc/inet
root@teguht # ls

.::: How To Setting SNMP On Solaris 10 :::.

Simple Network Management Protocol (SNMP) is an "Internet-standard protocol for managing devices on IP networks." Devices that typically support SNMP include routers, switches, servers, workstations, printers, modem racks, and more. It is used mostly in network management systems to monitor network-attached devices for conditions that warrant administrative attention. SNMP is a component of the Internet Protocol Suite as defined by the Internet Engineering Task Force (IETF). It consists of a set of standards for network management, including an application layer protocol, a database schema, and a set of data objects

Study Case change Snmp community from "public" to "teguht" on server root@teguht
Download SNMP Tester

A. Step by step setting & change SNMP on Solaris 10

1.    Login to Server Using "root"
Log :
root@teguht # id
uid=0(root) gid=0(root)
root@teguht #

:: How to Change the Hostid In Solaris :::.

bagaimana cara mengubah hostid di Solaris

The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change this hostid for whatever purpose. For example, you current machine is down for hardware failure and you purchased a new machine. However, all your current running software or License are based on this old hostid, and you must bring the new machine up within a very short time. The quick solution is to change the new machine’s hostid to be as same as the old one.

There are several ways to do so, including using a program to flush NVRAM which will change the hostid permanently. I did following experiment to change the Hostid in a Solaris 10 machine temperately. It adds several lines in the /etc/rc2.d/S20sysetup file. If you want to restore the original hostid, you just need to remove these lines and reboot the machine.

Example Change hostid from c93256a to 850168ae

No	Item	Hostid	Decimal	Hex Value	Remak
1	Host ID Original	c93256a	210969962	32 31 30 39 36 39 39 36 32	-
2	New Host ID	850168ae	2231462062	32 32 33 31 34 36 32 30 36 32	-