Structured query language sql
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Structured Query Language (SQL) PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on
  • Presentation posted in: General

Structured Query Language (SQL). SQL adalah bahasa standar untuk query yang difungsikan untuk memanipulasi suatu data pada Basis Data. Contoh Database SQL : MySQL , PostgreSQL , ORACLE , MSSQL, dll . Perintah SQL meliputi : DDL (Data Definition Language ) , dan

Download Presentation

Structured Query Language (SQL)

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


Structured Query Language(SQL)


SQL adalahbahasastandaruntuk query yang difungsikanuntukmemanipulasisuatu data pada Basis Data.

Contoh Database SQL : MySQL, PostgreSQL, ORACLE, MSSQL, dll.

Perintah SQL meliputi :

  • DDL (Data Definition Language), dan

  • DML (Data Manipulation Language)


InstalasiMySQL

Cara termudahmendapatkanMySQLadalahdenganmenggunakan XAMPP.


IDE MySQL

Untukmemanipulasi Database MySQLdapatmenggunakanaplikasibawaan XAMPP yaitu PHPMYADMIN, ataumenggunakan IDE lain berbasis desktop sepertiMySQLFront, HeidiSQL, dll.


DDL (Data Definition Language)

DDL (Data Definition Language) meliputipembuatan Data Base ataupunpembuatantabel.

Ex. Buatlah database barudengannama “mahasiswa”


DDL (Data Definition Language)


DDL (Data Definition Language)

CREATETABLE `tb_nilai` (

`id` INT(11) NOTNULLAUTO_INCREMENT,

`nim` VARCHAR(15) NOTNULL,

`nama` VARCHAR(20) NOTNULL,

`nilai` VARCHAR(2) NOTNULL,

PRIMARYKEY (`id`)

)


DML (Data Manipulation Language)

  • DML (Data Manipulation Language) meliputiperintah - perintahstandar query sepertperintahuntukmenambah data, mengubah data, menghapus data, dll.


DML (Data Manipulation Language)

INSERTINTOtb_nilai (id,nim,nama,nilai) VALUES(‘1’,’STI201300666','Hilma Anna','C')

  • Manipulasi Data : INSERT


DML (Data Manipulation Language)

UPDATEtb_nilai

SETnilai='B'

WHEREnim='STI201300666'

  • Manipulasi Data : UPDATE


DML (Data Manipulation Language)

DELETEFROMtb_nilai

WHEREnilai='C'

  • Manipulasi Data : DELETE


DML (Data Manipulation Language)

SELECT * FROMtb_nilai

SELECT * FROMtb_nilaiWHEREnilai='B'

SELECT * FROMtb_nilaiWHEREnilai='B' ORDER BYnim

SELECT * FROMtb_nilaiWHEREnilai='B' ORDER BYnimASC

  • Menampilkan Data : SELECT


  • Login