Structured query language sql
Download
1 / 12

Structured Query Language (SQL) - PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on

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

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 'Structured Query Language (SQL)' - warren


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)


Instalasi mysql
InstalasiMySQL

Cara termudahmendapatkanMySQLadalahdenganmenggunakan XAMPP.


Ide mysql
IDE MySQL

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


Ddl data definition language
DDL (Data Definition Language)

DDL (Data Definition Language) meliputipembuatan Data Base ataupunpembuatantabel.

Ex. Buatlah database barudengannama “mahasiswa”


Ddl data definition language1
DDL (Data Definition Language)


Ddl data definition language2
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)

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


Dml data manipulation language1
DML (Data Manipulation Language)

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

  • Manipulasi Data : INSERT


Dml data manipulation language2
DML (Data Manipulation Language)

UPDATEtb_nilai

SETnilai='B'

WHEREnim='STI201300666'

  • Manipulasi Data : UPDATE


Dml data manipulation language3
DML (Data Manipulation Language)

DELETEFROMtb_nilai

WHEREnilai='C'

  • Manipulasi Data : DELETE


Dml data manipulation language4
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