MY SQL

MySQL adalah sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh dunia. MySQL AB membuat MySQL tersedia sebagai perangkat lunak gratis dibawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus dimana penggunaannya tidak cocok dengan penggunaan GPL.

•Tidak sama dengan proyek-proyek seperti Apache, dimana perangkat lunak dikembangkan oleh komunitas umum, dan hak cipta untuk kode sumber dimiliki oleh penulisnya masing-masing, MySQL dimiliki dan disponsori oleh sebuah perusahaan komersial Swedia MySQL AB, dimana memegang hak cipta hampir atas semua kode sumbernya. Kedua orang Swedia dan satu orang Finlandia yang mendirikan MySQL AB adalah: David Axmark, Allan Larsson, dan Michael "Monty" Widenius.


Contoh Create Database di MySQL



Create & Decribe tabel Siswa


Create & Decribe tabel kursus


Create & Decribe tabel instruktur


Insert & Select tabel Siswa


Insert & Select tabel Kursus


Insert & Select tabel Instruktur

SPEED HACKING INTERNET

CATATAN PENTING!:

1. Registry adalah penentu cara kerja OS Windows XP, oleh karenanya utak-atik registry berarti mengutak-atik cara kerja Windows XP anda.
2. Agar terhindar dari trouble, sebelum mengutak-atik Registry, ada baiknya melakukan backup terlebih dahulu.



Thread ini adalah Kumpulan-kumpulan Trick untuk menTweak Internet Connection pada window dengan mengubah Registry.

Mengubah Open Connection dari 10 menjadi 70000 (SynPacket)

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\]
"TcpNumConnections"=dword:00011170


Setting up Provider Priority

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Serv ices\Tcpip\ServiceProvider.
Change this parameter:
Class - 1 (8)
DnsPriority - 1 (2000)
HostsPriority - 1 (500)
LocalPriority - 1 (499)
NetbtPriority – 1 (2001)

Matikan Negative Cache Time

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Dnscache\Parameters DWORD NegativeCacheTime=0

Configure Internet Download

Start/Run/Regedit HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Curr
entVersion\Explorer\RemoteComputer\NameSpace

Delete Subkey
{D6277990-4C6A-11CF-8D87-00AA0060F5BF}

Setting Up HTTP Request

HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\
"MaxConnectionsPer1_0Server"=Dword:0000000a
"MaxConnectionsPerServer"=Dword:0000000a

Increasing Global Max TCP Window Size

Only Work for Cable/DSL
tidak direkomendasikan untuk Dial Up

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters]"GlobalMaxTcpWindowSize"=dword:0000ffff

Default Value nya

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters]"GlobalMaxTcpWindowSize"=dword:00007fff

Disable QoS Packet Scheduler (Repost ?) - Ini Penting

Secara default Xp melimit Bandwith menjadi 20%
limitnya bisa diubah menjadi 0% di

start> run > gpedit.msc > local computer policy > Administrative tempaltes
> network > QoS Packet Scheduler

pada bagian kiri double click limit reservable bandwidth, check enable pada bagian Bandwidth limit %, ubah menjadi 0

lalu reboot

Browse Network Lebih cepat

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Explorer
\RemoteComputer\NameSpace

Delete subkeys
{2227A280-3AEA-1069-A2DE-08002B30309D} dan {D6277990-4C6A-11CF-8D87-00AA0060F5BF}

[Tutorial] Step By Step Tweaking Your Window

For pemula

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\]
"TcpNumConnections"=dword:00011170

artinya

buka regedit Run>Regedit
lalu browse pada [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\] di bagian kiri
Valuenya bernama TcpNumConnections, kalo sudah ada tinggal diedit
Kalo belum, Klik kanan>New>DWORD Value lalu masukkan namanya
klik dua kali untuk memasukkan value datanya (hex) yaitu 00011170

GREEN DAY LYRICS

"She"

She...
She screams in silence
A sullen riot penetrating through her mind
Waiting for a sign
To smash the silence with the brick of self-control

[Chorus:]
Are you locked up in a world
That's been planned out for you?
Are you feeling like a social tool without a use?
Scream at me until my ears bleed
I'm taking heed just for you

She...
She's figured out
All her doubts were someone else's point of view
Waking up this time
To smash the silence with the brick of self-control



"Stuck With Me"

I'm not part of your elite
I'm just alright
Class structure waving colors
Bleeding from my throat
Not subservient to you I'm just alright
Down classed by the powers that be
Give me loss of hope

Cast out... Buried in a hole
Struck down... forcing me to fall
Destroyed... giving up the fight
Well, I know I'm not alright

What's my price and will you pay it if it's alright?
Take it from my dignity
waste it until it's dead
Throw me back into the gutter
'Cause it's alright
Find another pleasure fucker
Drag them down to hell

Cast out... Buried in a hole
Struck down... forcing me to fall
Destroyed... giving up the fight
Well, I know I'm not alright

Cast out... Buried in a hole
Struck down... forcing me to fall
Destroyed... giving up the fight
Well, I know I'm not alright




"Warning"

[Verse 1:]
This is a public service anouncement, this is only a test
Emergency evacuation protest
May Impair your ability to operate machinery
Can't quite tell just what it means to me
Keep out of reach of children, don't you talk to strangers
Get your philosophy from a bumper sticker

[Chorus:]
Warning. Live without warning
Say warning. Live without warning
Without. Alright.

[Verse 2:]
Better homes and safety-sealed communities
Did you remember to pay the utility?
Caution: Police line, you better not cross.
Is it the cop, or am I the one thats really dangerous?
Sanitation, expiration date, question everything.
Or shut up and be a victim of authority

[Chorus:]
Warning. Live without warning
Say warning. Live without warning
Say warning. Live without warning
Say warning. Live without warning
Without. Alright.

[Verse 3:]
Better homes and safety-sealed communities
Did you remember to pay the utility?
Caution: Police line, you better not cross.
Is it the cop, or am I the one that's really dangerous
Sanitation, expiration date, question everything.
Or shut up and be a victim of authority

[Chorus:]
Warning. Live without warning
Say warning. Live without warning
Say warning. Live without warning
Say warning. Live without warning
This is a public service anouncement, this is only a test




"Castaway"

I'm on a sentimental journey
Into sight and sound
Of no return and no looking back or down
A consciences objector to the
War that's in my mind
Leaving in the lurch and I'm
Taking back what's mine

I'm on a mission
In the destination unknown
An expedition
In the desolation road
Where I'm a...

Castaway - going at it alone
Castaway - now I'm on my own
Castaway - going at it alone
Castaway - now I'm on my own
Lost and found, trouble bound
Castaway

I'm riding on the night train and
Driving stolen cars
Testing my nerves out of the blvd.
Spontaneous combustion on the
Corners of my mind
Leaving in the lurch
And I'm taking back what's mine

I'm on a mission
In the destination unknown
An expedition
In the desolation road
Where I'm a...

Castaway - going at it alone
Castaway - now I'm on my own
Castaway - going at it alone
Castaway - now I'm on my own
Lost and found, trouble bound
Castaway



"Waiting"

I've been waiting a long time
For this moment to come
I'm destined
For anything...at all
Downtown lights will be shining
On me like a new diamond
Ring out under the midnight hour
No one can touch me now
And I can't turn my back
It's too late ready or not at all

Well, I'm so much closer than
I have ever known...
Wake up

Dawning of a new era
Calling...don't let it catch you falling
Ready or not at all
So close enough to taste it
Almost...I can embrace this
Feeling....on the tip of my tongue

Well, I'm so much closer than
I have ever known...
Wake up
Better thank your lucky stars....
(Shey hey hey)

I've been waiting for a life time
For this moment to come
I'm destined for anything at all

Dumbstruck
Colour me stupid
Good luck
You're gonna need it
Where I'm going if I get there...
At all....

Wake up
Better thank your lucky stars... .




"She's A Rebel"

She's a rebel
She's a saint
She's salt of the earth
And she's dangerous

She's a rebel
Vigilante
Missing link on the brink
Of destruction

From Chicago to Toronto
She's the one that they
Call old whatsername

She's the symbol
of resistance
and she's holding on my
heart like a hand grenade

Is she dreaming
what I'm thinking
Is she the mother of all bombs
gonna detonate

Is she trouble
like I'm trouble
make it a double
twist of fate
or a melody that

She sings the revolution
the dawning of our lives
she brings this liberation
that I just can't define
nothing comes to mind
[x2]

She's a rebel
She's a saint
She's salt of the earth
And she's dangerous

She's a rebel
Vigilante
Missing link on the brink
Of destruction

She's a rebel
She's a saint
She's salt of the earth
And she's dangerous

She's a rebel
Vigilante
Missing link on the brink
Of destruction

She's a rebel, She's a rebel, She's a rebel, And she's dangerous
[x2]

ENTERPRISE PERPUSTAKAAN

ER-MODEL




SEMANTIC MODEL

Semantic model menjelaskan bagaimana proses berjalan lebih rinci agar kita bisa memahami arus yang ada dalam model data tersebut.

Imam sebagai penyewa buku, sebagai penyewa dia harus memiliki kartu anggota yang dilengkapi dengan "No. anggota, Kode buku, Tgl pinjam, dan Tgl Kembali". Imam harus menyertakan syarat "No. anggota, Nama anggota, Alamat"