Selasa, 31 Oktober 2023

Basic Color In English


These following list are basic color in English:

Black

Blue

Brown

Gray / Grey

Green

Orange

Pink

Purple

Red

White

Yellow

Bibliography:

https://www.busuu.com/

https://www.miratone.id/

University of Oxford

University of Cambridge

Berkeley Global Access

English Language Institute (ELI)

Related Post:

UML Diagram List

UML Diagram Hierarchy:

  • Structure Diagrams:
    • Class Diagram
    • Component (Structure) Diagram
    • Deployment Diagram
    • Object Diagram
    • Package Diagram
    • Profile Diagram
    • Composite Structure Diagram
  • Behavioral Diagrams:
    • Use Case Diagram
    • Activity Diagram
    • State Machine Diagram
    • Interaction Diagram:
      • Sequence Diagram,  to learn more click Sequence Diagram ( UML ) >
      • Communication Diagram
      • Interaction Overview Diagram:
      • Timing Diagram

Bibliography:

https://www.ibm.com/
https://www.visual-paradigm.com/
https://www.researchgate.net/
https://www.uu.se/ ( university )

Unified Modelling Language ( UML ), uml modelling, uml diagram, uml chart, program design, software design, application design

RGB And CYMK Color Palette

Color combination of Primary Colors:

CYMK ( Cyan Yellow Magenta Black)

Color combination of Secondary Colors:

Magenta 100 + Yellow 100 = Red

Magenta 80 + Cyan 20 + Black 20 = Purple

Cyan 100 + Yellow 100 = Green

Magenta 60 + Yellow 100 = Orange

Magenta 40 + Yellow 20 = Pink

Magenta 20 + Yellow 40 + Black 40 = Brown

Color combination of Primary Colors:

RGB ( Red Green Blue )

Color combination of Secondary Colors:

Red 255 + Green 255= Yellow

Green 255 + Blue 255 = Cyan

Red 255 + Green 102 = Orange

Red 153 + Blue 204 = Purple

Red 255 + Blue 255 = Magenta

Red 255 + Green 153 + Blue 204 = Pink

Red 153 + Green 102 + Blue 51 = Brown

Bibliography:

https://paperheartdesign.com/

https://colorhunt.co/

https://www.shutterstock.com/

Rabu, 25 Oktober 2023

DDL, DQL, DML, DCL and TCL Commands

Structured Query Language(SQL) is the database language to perform certain operations on the database.

These SQL commands are mainly categorized into five categories: 

DDL – Data Definition Language

DQL – Data Query Language

DML – Data Manipulation Language

DCL – Data Control Language

TCL – Transaction Control Language

DDL (Data Definition Language)

DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. DDL is a set of SQL commands used to create, modify, and delete database structures but not data.

List of DDL commands: 

CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).

DROP: This command is used to delete objects from the database.

ALTER: This is used to alter the structure of the database.

TRUNCATE: This is used to remove all records from a table, including all spaces allocated for the records are removed.

COMMENT: This is used to add comments to the data dictionary.

RENAME: This is used to rename an object existing in the database.

DQL (Data Query Language)

DQL statements are used for performing queries on the data within schema objects.

SELECT: It is used to retrieve data from the database.

DML (Data Manipulation Language)

The SQL commands that deal with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements.

List of DML commands: 

INSERT: It is used to insert data into a table.

UPDATE: It is used to update existing data within a table.

DELETE: It is used to delete records from a database table.

LOCK: Table control concurrency.

CALL: Call a PL/SQL or JAVA subprogram.

EXPLAIN PLAN: It describes the access path to data.

DCL (Data Control Language)

DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.

List of  DCL commands: 

GRANT: This command gives users access privileges to the database.

REVOKE: This command withdraws the user’s access privileges given by using the GRANT command.

TCL (Transaction Control Language)

Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully complete. If any of the tasks fail, the transaction fails. Therefore, a transaction has only two results: success or failure.

List of TCL commands:

BEGIN: Opens a Transaction.

COMMIT: Commits a Transaction.

ROLLBACK: Rollbacks a transaction in case of any error occurs.

SAVEPOINT: Sets a save point within a transaction.

Bibliography:

https://www.geeksforgeeks.org/
https://www.mygreatlearning.com/
https://www.scaler.com/

PHP Bind Param

PHP MySQLi Statement Bind Parameter Type Specification Chars (placeholder / marker):

Character=Description

i=corresponding variable has type int

d=corresponding variable has type float

s=corresponding variable has type string

b=corresponding variable is a blob and will be sent in packets

Using in PHP MySQLi, PDO (PHP Data Objects), PHP current version.
mysqli_stmt_prepare, mysqli_prepare, mysqli_stmt_init(), mysqli_stmt_init(), mysqli_stmt_execute(), mysqli_stmt_fetch(), mysqli_stmt_bind_param(), mysqli_stmt_bind_result(), mysqli_stmt_get_result(), mysqli_stmt_close(), call_user_func_array()

Selasa, 24 Oktober 2023

Symbol And Syntax 2


U+2027Hyphenation Point
#U+0023Pound Symbol / Number Sign / Hash Tag Sign
&U+0026Ampersand
*U+002AAsterisk
@U+0040At Symbol
^­­U+005ECaret Symbol / Circumflex symbol
`­­U+0060BackTick / Backquote / Grave Accent.
|U+007CPipe Symbol / Vertical Bar
~U+007ETilde
U+2219Bullet Operator
<U+003CLeft Angle Bracket / Less Than Sign
=U+003DEquals Sign
>U+003ERight Angle Bracket / Greater Than Sign
U+22C5Multiplication Dot / Dot Operator / Space Dot
·U+00B7Interpunct / Interpoint / Centered Dot / Middle Dot
U+2022Bullet Point

Punctuation, Symbol, Notation, Syntax, Math Symbol, special characters, symbols, reserved symbol, entity

Related Post:

Symbol And Syntax

'U+0027Apostrophe
-U+002DHyphen Minus
-U+2010Hyphen
U+2012Figure Dash
U+2013En Dash
U+2014Em Dash
U+2015Horizontal Bar
!U+0021Exclamation Point Or Exclamation Mark
"U+0022Quotation Marks
(U+0028Left Parentheses
)U+0029Right Parentheses
,U+002CComma
.U+002EPeriod Or Full Stop
/U+002FSolidus / Slash
:U+003AColon
;U+003BSemi Colon
?U+003FQuestion Mark
[U+005BLeft Square Bracket
\U+005CReverse Solidus / BackSlash
]U+005DRight Square Bracket
_U+005FLow Line / Underscore
{U+007BLeft Curly Bracket Or Left Braces
}U+007DRight Curly Bracket Or Right Braces
U+201CLeft Double Quotation Mark
U+201DRight Double Quotation Mark
U+2044Fraction Slash
U+2026Ellipsis

Punctuation, Symbol, Notation, Syntax

Related Post:

Symbol And Syntax 2

Jumat, 20 Oktober 2023

Check PlantUML Installation

How To Check Software Requirement And Other Support Tools:

  1. Click this How To Check Your Java Version link to know is your java has installed.
  2. Check your GraphViz installation, type this command in Command Prompt:
    dot -V

How To Check PlantUML Installation

  1. Open your Command Prompt.
  2. Go to your PlantUML installation, e.g. if your PlantUML installation path D:\plantuml\, type :
    D:
    then press enter.
  3. type this:
    cd plantuml
    then press enter.
  4. type this:
    java -jar plantuml.jar -version
  5. press Enter on keyboard.
plant uml, unified modelling language, system analyst and design

Kamis, 19 Oktober 2023

MikTex Command Prompt

MiKTeX Package Manager ( mpm )

command ; description

Typing this following command in Command Prompt Line:

mpm -?, --help ; Show this help message

mpm --install=PACKAGE ; Install the specified package.

mpm --install-some=FILE ; Install packages listed (line-by-line) in the specified file.

mpm --list ; List the contents of the package database: for each package, print the installation status, the number of files, the size, and the name.

mpm --list-package-names ; List the package names.

mpm --print-package-info=PACKAGE

mpm --verify[=PACKAGE] ; Verify the integrity of the installed packages.

mpm --version ; Show version information of mpm and exit.

Bibliography

http://latexref.xyz/
https://wayne.edu/ ( university )

Datagrid Visual Basic Classic 1

Deklarasi variable

Dim cnn As ADODB.Connection

Dim rst As ADODB.Recordset

Configure a connection

Set cnn = New ADODB.Connection

cnn.CursorLocation = adUseClient

Tampilkan data dari ADODB recordset ke datagrid

Set DataGrid1.DataSource = rst

Atur tampilan datagrid (caption & width)

With DataGrid1

    .Caption = "Tabel Kategori"

    .Columns(0).Caption = "Kode Kategori"

    .Columns(1).Caption = "Nama Kategori"

    .Columns(0).Width = 2000

    .Columns(1).Width = 3000

End With

Mendapatkan Data Dari Cell DataGrid Yang Aktif / Di Klik

Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)

Msgbox DataGrid1.Columns(DataGrid1.Col).Text

End Sub


To read data binding, click on Microsoft Visual Basic 6 Data Binding Object reference link.

Bibliography:

http://www.vb-helper.com/
https://www.vbforums.com/
https://learn.microsoft.com/en-us/
https://rani-irsan.blogspot.com/
Beginning Database Design Solutions;Rod Stephens
Visual Basic Programmer's Reference;Rod Stephens

Grid, Microsoft DataGrid Control Snippet Code, database connection, data grid cell

DataGrid Properties

DataGrid Properties In Microsoft Visual Basic


AddNewMode
Align
AllowAddNew
AllowArrows
AllowDelete
AllowRowSizing
AllowUpdate
ApproxCount
Bookmark
Caption
Col
ColumnHeaders
Columns
CurrentCellModified
CurrentCellVisible
DataBindings
DataChanged
DataFormats
DataField
DefColWidth
EditActive
ErrorText
FirstRow
HeadFont
HeadLines
hWndEditor
LeftCol
MarqueeStyle
Negotiate
RecordSelectors
Row
RowDividerStyle
RowHeight
ScrollBars
SelBookMarks
SelEndCol
SelLength
SelStart
SelStartCol
SelText
Split 
Splits
TabAcrossSplits
TabAction
VisibleCols
VisibleRows
WrapCellPointer

grid, microsoft datagrid 

Bibliography:

https://github.com/
https://www.vbforums.com/
https://stackoverflow.com/

Favicon Di Website


  1. Menyiapkan favicon dengan http://www.genfavicon.com/, http://www.favicon-generator.org/http://www.favicongenerator.com/, dan https://realfavicongenerator.net/.
  2. Upload favicon di folder utama pada hosting server.
  3. Menambahkan code di bawah ini, ke dalam tag<head></head>.
    <link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png">

Bibliography:

https://www.domainesia.com/, http://www.genfavicon.com/, http://www.favicon-generator.org/,  http://www.favicongenerator.com/, dan https://realfavicongenerator.net/.

Related Post:

Rabu, 18 Oktober 2023

Encoding Base64 JavaScript

Encoding And Decoding Strings With Base64 Using JavaScript

btoa() and atob() are two Base64 JavaScript functions that are a core part of the HTML specification and available in all modern browsers.

btoa() JavaScript Function

Type this code in  browser’s web developer console log:

// Define the string

var decodedStringBtoA = 'Hello World!';

// Encode the String

var encodedStringBtoA = btoa(decodedStringBtoA);

console.log(encodedStringBtoA);

Output:

SGVsbG8gV29ybGQh

atob() JavaScript Function

Type this code in  browser’s web developer console log:

// Define the string

var encodedStringAtoB = 'SGVsbG8gV29ybGQh';

// Decode the String

var decodedStringAtoB = atob(encodedStringAtoB);

console.log(decodedStringAtoB);

Output:

Hello World!

Bibliography:

Eloquent JavaScript;Marijn Haverbeke;No Starch Press
Effective JavaScript;David Herman;Addison Wesley
JavaScript: The Definitive Guide;David Flanagan;O'Reilly
https://www.instagram.com/thecodecrumbs/

Related Post:

Math Plugin For JavaScript Web Framework or Library

Memasang CKEditor

Browser Cookie Problem

Topic about JavaScript

Disable Excel Configuration With VBA

'To disable screen updating, events and display alerts

Application.ScreenUpdating = False

Application.EnableEvents = False

Application.DisplayAlerts = False

Visual Basic Application Microsoft Office Macro

Related Post:

Hello World PHP XAMPP

  1. Buka aplikasi notepad.
  2. Ketikan kode berikut:
    <?php
    echo "hello world";
    ?>
  3. Kemudian simpan (CTRL+S) dengan nama file Hello.php, pada lokasi XAMPP diinstall, contoh: C:/xampp/htdocs, dan pilih All Files (*.*) pada kotak pilihan Save as type. Tekan tombol Save.
  4. Buka server lokal, contoh: XAMPP Control Panel.
  5. Klik tombol Start di sebelah modul Apache.
  6. Buka browser, navigasikan ke http://localhost/hello.php.

Bibliography

https://www.hostinger.com 

Related Post

PHP Requirements

How To Check PHP Version

The MySQLi Extension Function Summary 1

URL Address PHP MySQL Local Server 1
URL Address PHP MySQL Local Server 2
Topic About PHP
Topic About MySQL

Senin, 16 Oktober 2023

Java Runtime Environment fonts

If you want to run Java application, but the fonts look ugly, there is also an environment variable to configure anti-aliasing:

_JAVA_OPTIONS='-Dawt.useSystemAAFontSettings=setting'

Where setting is one of the values:

Setting=Description

off or  false, default=No anti-aliasing

on=Full anti-aliasing

Other Options:

_JAVA_OPTIONS='-Dswing.plaf.metal.controlFont=Tahoma-15 -Dswing.plaf.metal.userFont=Tahoma-15 -Dswing.aatext=true' 

Related Post:

How To Check Your Java Version

How To Compile Java 1

Java Font Style

Java Version Notes 1

Topic about Java

Three Classes Regex In Java.Util. Package

Memelihara Kesehatan Lingkungan

Fungsi Menu Pada Microsoft Office Excel 1

Aktivitas Kebugaran Jasmani


Declare Variables As Excel Object 1

This following Visual Basic 6 / VBA in Visual Studio 6 IDE or Microsoft Visual Basic Editor (Microsoft Office):
'To declare variables as Excel Worksheet
Dim Appws As Worksheet

Bibliography:

https://www.instagram.com/kelasexcel/
https://www.instagram.com/kelvintham27/
https://www.instagram.com/shortcuts.xlsx/
https://www.instagram.com/thecheatsheets/
Excel For Dummies by Greg Harvey
Advanced Excel Formulas by Alan Murray
Microsoft Excel VBA and Macros by Tracy Syrstad, Bill Jelen

Microsoft Word Equations 1

Relational Symbols

Spaces And Ellipses

Embellishments

Operator Symbols

Arrow Symbols

Logical Symbols

Set Theory Symbols

Miscellaneous Symbols

Greek Characters (Lowercase)

Greek Characters (Uppercase)

Fence Templates

Fraction And Radical Templates

Subscript And Superscript Templates

Summation Templates

Integral Templates

Underbar And Overbar Templates

Labeled Arrow Templates

Products And Set Theory Templates

Matrix Templates

Related Post

Microsoft Office Equation Field


People At School

Accounting Teacher

Art Teacher

Cafeteria Worker

Career Adviser

Chemistry Teacher

Class Mates

Coach / Gym Teacher / Physical Exercise Teacher / Physical Education Teacher / Physical Development Teacher

College Student

Computer Science Teacher

Crossing Patrol

Dean

Design And Technology Teacher

Economics Teacher

English Teacher, Language Teacher

Ethics Teacher

French Language Teacher

Geography Teacher

History Teacher

Information And Computer Technology

Information Technology Teacher

Instructor

Junior High School Student

Lab Assistant

Lecture

Librarian

Little Kid Student

Lunch Vendor

Lunch Vendor / Lunch Lady / Canteen Server

Math Teacher

Music Teacher

Nursery School Teacher

Parent

Physics Teacher

Primary School Student

Proctor

Religion Education Teacher

School Accountant

School Administrator

School Bus Driver

School Cashier

School Cooker

School Counselor

School Day Taker

School Friend

School Guard / School Security Guard

School Janitor / School Cleaner / School Custodian

School Nurse

School Principal / Head Master / Head Teacher

School Secretaries

School Supervisor

School Teller

School Vice Principal / Vice Head Master / Vice Head Teacher

Science Teacher

Senior High School Student

Spanish Language Teacher

Special Education Teacher

Special Needs Assistant / School Aides

Student / Pupil

Student Advisor

Superintendent

Teacher

pelajaran sekolah, pelajaran bahasa inggris, ilmu sekolah, school lesson, english lesson, school course

Bibliography:

https://du.lv/en/home/ ( university )

English for Everyone by DK

The Blue Book of Grammar and Punctuation by Lester Kaufman and Jane Straus

English Grammar in Use by Raymond Murphy

Related Post:

Jumat, 13 Oktober 2023

Font Size In Latex


Text Formatting In Latex.The following commands should be used like this: {\command ...}

\tiny

\scriptsize

\footnotesize

\small

\normalsize ( default )

\large

\Large (capital "l")

\LARGE (all caps)

\huge

\Huge (capital "h")

Change ... elipsis in LaTeX code with your text.




Senin, 09 Oktober 2023

Line Break In Equation Using Latex



Remember to \usepackage{amsmath}.

Using Align Environment

If you want to separated between equations by a linebreak \\. You can use the align environment.

For example:

\begin{align*}

1 + 2 &= 3\\

1 &= 3 - 2

\end{align*}

Result:


Notes:

  • The command \\ signifies a line break and within the correct math mode environment, it can start a new equation line.
  • In the align environment, the equations will align at the ampersand &.
  • The asterisk (e.g. equation*) only indicates, that I don’t want the equations to be numbered.

Using Equation And Split Environment

For example:

\begin{equation}

\begin{split}

    1 + 2 & = 3 \\

    1 & = 3 - 2

\end{split}

\end{equation}

Notes:

  • You have to wrap your equation in the equation environment if you want it to be numbered, or you can use equation* (with an asterisk) if you want the equation without number. Inside the equation environment, use the split environment to split the equations into smaller pieces, these smaller pieces will be aligned accordingly.
  • The double backslash (\\) works as a newline character.
  • Use the ampersand character &, to set the points where the equations are vertically aligned.

Using Equation And Aligned Environment

For example:

\begin{equation}

\begin{aligned}

    1 + 2 & = 3 \\

    1 & = 3 - 2

\end{aligned}

\end{equation}

Notes:

  • You have to wrap your equation in the equation environment if you want it to be numbered, or you can use equation* (with an asterisk) if you want the equation without number. Inside the equation environment, use the aligned environment to split the equations into smaller pieces, these smaller pieces will be aligned accordingly.
  • The double backslash (\\) works as a newline character.
  • Use the ampersand character &, to set the points where the equations are vertically aligned.

Bibliography

https://www.overleaf.com/
https://latex-tutorial.com/

Related Post

Microsoft Office Equation Field

Overstrike In Fraction Equation



  1. Go to Insert > Quick Parts > Field


  2. In the "Field names" list, select Eq 
  3. Click "Fields Codes" button.
  4. In then "Fields codes:" box, type this:
  5. {EQ \f(18,12) = \f(\o(18,\\) : 6,\o(12,\\) : 6) = \f(3,2)}
  6. And then select OK button.

Minggu, 08 Oktober 2023

Write A Line In Geogebra

Type this in "Graphing Calculator", Geometry View / Graphics View, Algebra View:

C = (15,15)

D = (15, 0)

a = Segment(C, D)


Latex Package To Handle Math And Science Equation

These are latex ordinary Package list To Handle Math And Science Equation:

amsbsy package.*
amsmath package.
amssymb package.*
amstext package.*
amsthm package.*
bm package.*
breqn package.
cancel package.
chemmacros package.
eucal package.*
esint package.
fourier package.
gensymb package.
latexsym package.*
mathptmx package.*
mathrsfs package.*
mathtools package.
mhchem package.
physics package.
showkeys package.*
siunitx package.
texcomp package.*
theorem package.*

* not available on all latex Miktex or TexLive version. You must to installed separated.
** obsolete package

Bibliography

https://latex.org/
https://www.overleaf.com/
https://www.latex4technics.com

latex math, learn latex, latex document formatting, latex mathematics formula

Related Post

Latex Package To Handle Table:

These are ordinary latex Package list To Handle Table:
array package.
booktabs package.
caption package.
dcolumn package.
float package.
longtable package.
makecell package.
multirow package.
rotating package.
subcaption package.
tabu package.
tabularray package.

latex document formatting, latex table package, \usepackage{package_name}

Related Post

State Diagram ( UML )

State (Chart/Machine) Diagram

Purpose

It is used to model dynamic nature of the system.

State diagram is used to describe the life time of an object.

By the use of state diagram the state machine is defined to model states of an object.

Unified Modelling Language

Related Post:

DDL, DQL, DML, DCL and TCL Commands

Aktivitas Kebugaran Jasmani

Datagrid Visual Basic Classic 1

ListView Properties

Microsoft Visual Basic 6 Data Binding Object

Fungsi File Dalam Visual Basic 6

Three Dimensional Shape

Vertices = titik sudut / noktah sudut.

Faces = sisi.

Edges = rusuk.

3D Shape In Mathematics

These shapes are three dimension shape in mathematics:

Cube = kubus.

Cuboid = balok.

Cylinder = tabung.

Triangular Prism = prisma segitiga.

Pyramid = limas segi empat.

Cone = kerucut.

Sphere = bola.

Tetrahedron = limas segitiga.

Bibliography:

https://www.splashlearn.com/

https://byjus.com/

https://www.cuemath.com/

https://www.twinkl.com/

https://www.mathsisfun.com/

https://www.jagoanbahasainggris.com/

http://ruangguru.com/

Related Post:

Two Dimensional Shape

Dua Segitiga Kongruen

Istilah-istilah matematika dalam bahasa inggris 1

Jumat, 06 Oktober 2023

Bentuk Aljabar 1 Dalam Bentuk Latex

Ketik perintah LaTex berikut untuk menulis bentuk aljabar:

\[
\text{Bentuk \quad Aljabar 1}:\\ \left(\text{a}+\text{b}\right)^{2}=\text{a}^2+2\text{ab}+\text{b}^2
\]

Hasilnya, klik link berikut: 

Bentuk Aljabar 1

Untuk mengetik rumus tanpa penomoran dalam Latex, klik Turn Off The Latex Equation Auto Numbering

Untuk mengetik teorema dalam Latex, klik Theorem and Proof In Latex 1

Untuk mengetik rumus lain dalam Latex, klik Latex Math Symbol And Equations 2


<< Back to Learn About Latex List 1


Bibliography:

https://www.ung.ac.id/ ( university )

https://binus.ac.id/ ( university )

https://ugm.ac.id/ ( university )

https://www.colorado.edu/ ( university )

https://uwaterloo.ca/ ( university )

algebra equation, latex, latex math, latex equation, latex mathematics

Related Post:


Various Other Posts