Pembuatan database
Download
1 / 10

Pembuatan Database - PowerPoint PPT Presentation


  • 127 Views
  • Uploaded on

Pembuatan Database. Perintah SQL (Structure Query Language). Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL). Data Definition Language. untuk mendefinisikan struktur dari sebuah database Perintah DDL: Create : membuat tabel dan database

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Pembuatan Database' - cutter


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Pembuatan database

Pembuatan Database


Perintah sql structure query language
Perintah SQL (Structure Query Language)

  • Data Definition Language (DDL)

  • Data Manipulation Language (DML)

  • Data Control Language (DCL)


Data definition language
Data Definition Language

  • untukmendefinisikanstrukturdarisebuahdatabase

  • Perintah DDL:

    • Create : membuattabeldandatabase

    • Alter : mengubahstrukturtabel yang sudahdibuat

    • Drop : menghapustabelataudatabase

    • Truncate : menghapusseluruhisitabel


Data definition language1
Data Definition Language

  • Create

    • create database if not exist pegawai;

    • Create table pegawai (nip varchar (13) not null primary key, namavarchar (20), alamat text, telpnvarchar (13));


Data definition language2
Data Definition Language

  • Alter

    • Alter table pegawai add jabatanvarchar(10) not null;

  • Drop

    • Drop table pegawai;

    • Drop database pbw;

  • Truncate

    • Truncate table pegawai;


Data manipulation language
Data Manipulation Language

  • untukmenampilkan, mengubah, memasukkandanmenghapus data pada tabel ataupun skema pada sebuah database.

  • Perintah DML:

    • Select : menampilkan data darisebuahtabel

    • Insert : memasukkan data kedalamtabel

    • Update : mengedit data padasebuahtabel

    • Delete : menghapus data sebuahbarispadasebuahtabelmaupununtukmengosongkantabel


Data manipulation language1
Data Manipulation Language

  • Select:

    • Select * from pegawai;

    • Select * from pegawai where nip=123;

    • Select nip,nama from pegawai;

    • Select nip,nama from pegawai where nip=123;

    • Select * from pegawai, jabatan where pegawai.jabatan=jabatan.kode;


Data manipulation language2
Data Manipulation Language

  • Insert:

    • Insert into pegawai values (1,2,3,4);

    • Insert into pegawai (nip, nama) values (1,2)

  • Update

    • Update pegawai set nama=‘Budi’ where nip=‘123’;

  • Delete

    • Delete from pegawai;

    • Delete from pegawai where nip=‘123’;


Data control language
Data Control Language

  • untukmemberikanhakaksesatau pun mencabuthakakses

  • Perintah DCL :

    • Grant : membukaakses

    • Revoke : menutupakses


Data control language1
Data Control Language

  • Grant

    • GRANT SELECT ON TO pegawai razief;

  • Revoke

    • REVOKE SELECT ON TO pegawai razief;