Page 3 - E-Modul Basis Data

STRUCTURED QUERY
LANGUAGE

DAFTAR ISI

HALAMAN

KATA PENGANTAR .................................................................................................................................. i
DAFTAR ISI ............................................................................................................................................. ii
PETUNJUK PENGGUNAAN MODUL ................................................................................................ iii
PETA KONSEP MODUL ........................................................................................................................ iv
MODUL 1 ................................................................................................................................................... 1
Basis Data : DDL, DML, DCL............................................................................................................... 1
A. Data Definiton Language (DDL) ..................................................................................................................... 3
1. CREATE ................................................................................................................................................................ 3
2. RENAME .............................................................................................................................................................. 4

3. ALTER ................................................................................................................................................................... 5
4. DROP ..................................................................................................................................................................... 6
B. Data Manipulation Language (DML) ............................................................................................................ 7
1. SELECT ................................................................................................................................................................. 7

2. INSERT................................................................................................................................................................. 8
3. UPDATE................................................................................................................................................................ 8
4. DELETE ................................................................................................................................................................. 9

C. Data Control Language (DCL) .......................................................................................................................... 9
1. GRANT .................................................................................................................................................................. 9
2. REVOKE ............................................................................................................................................................ 10

TES FORMATIF .................................................................................................................................................................. 15
MODUL 2 ................................................................................................................................................. 16
Basis Data : TIPE DATA ..................................................................................................................... 16
A. NUMERIC .................................................................................................................................................................. 18

B. STRING ...................................................................................................................................................................... 21
C. DATE AND TIME .................................................................................................................................................... 24
TES FORMATIF .................................................................................................................................................................. 30

MODUL 3 ................................................................................................................................................. 31
Basis Data : Table, Record, Field ................................................................................................... 31
TES FORMATIF .................................................................................................................................................................. 37

DAFTAR PUSTAKA ............................................................................................................................... 38
TIM PENGEMBANG .............................................................................................................................. 39

DAFTAR ISI
STRUCTURED QUERY
LANGUAGE ii

PETU

NJUK