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

Structured Query Language (SQL) PowerPoint PPT Presentation


  • 66 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

Structured Query Language(SQL)


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


  • Login