1 / 12

Structured Query Language (SQL)

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

warren
Télécharger la présentation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Structured Query Language(SQL)

  2. 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)

  3. InstalasiMySQL Cara termudahmendapatkanMySQLadalahdenganmenggunakan XAMPP.

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

  5. DDL (Data Definition Language) DDL (Data Definition Language) meliputipembuatan Data Base ataupunpembuatantabel. Ex. Buatlah database barudengannama “mahasiswa”

  6. DDL (Data Definition Language)

  7. 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`) )

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

  9. DML (Data Manipulation Language) INSERTINTOtb_nilai (id,nim,nama,nilai) VALUES(‘1’,’STI201300666','Hilma Anna','C') • Manipulasi Data : INSERT

  10. DML (Data Manipulation Language) UPDATEtb_nilai SETnilai='B' WHEREnim='STI201300666' • Manipulasi Data : UPDATE

  11. DML (Data Manipulation Language) DELETEFROMtb_nilai WHEREnilai='C' • Manipulasi Data : DELETE

  12. 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

More Related