Download - Sekilas Tentang MySQL
![Page 2: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/2.jpg)
Outline
Pengenalan Database, DBMS, dan RDBMS
Beberapa Istilah Database Hierarki Database Pengenalan Database MySQL
![Page 3: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/3.jpg)
Database
Adalah kumpulan informasi yang disimpan di dalam komputer secara sistematik sehingga dapat diperiksa menggunakan suatu program komputer untuk memperoleh informasi dari basis data tersebut (http://id.wikipedia.org/wiki/Database)
![Page 4: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/4.jpg)
DBMS dan RDBMS
Database Management System merupakan suatu sistem perangkat lunak
yang memungkinkan user (pengguna) untuk membuat, memelihara, mengontrol, dan mengakses database secara praktis dan efisien.
RDBMS = DBMS yang mendukung Relationship
![Page 5: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/5.jpg)
Contoh RDBMS
DB2 - http://www-306.ibm.com/software/data/db2/ Microsoft SQL Server - http://www.microsoft.com/sql/ Oracle - http://www.oracle.com Sybase - http://www.sybase.com/ Interbase - http://www.borland.com/interbase Teradata - http://www.teradata.com/ Firebird - http://www.firebirdsql.org/ MySQL – http://www.mysql.com PostgreSQL - http://www.postgresql.org/
![Page 6: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/6.jpg)
Istilah dalam Database
Table KODE NAMA ALAMAT
0001 BUDI JAKARTA
0002 AMIN BANDUNG
0003 UJANG JAKARTA
![Page 7: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/7.jpg)
Istilah dalam Database
Table Field
KODE NAMA ALAMAT
0001 BUDI JAKARTA
0002 AMIN BANDUNG
0003 UJANG JAKARTA
![Page 8: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/8.jpg)
Istilah dalam Database
Table Field Record
KODE NAMA ALAMAT
0001 BUDI JAKARTA
0002 AMIN BANDUNG
0003 UJANG JAKARTA
![Page 9: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/9.jpg)
Istilah dalam Database
Table Field Record Key
KODE NAMA ALAMAT
0001 BUDI JAKARTA
0002 AMIN BANDUNG
0003 UJANG JAKARTA
![Page 10: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/10.jpg)
Istilah dalam Database
Table Field Record Key SQL
KODE NAMA ALAMAT
0001 BUDI JAKARTA
0002 AMIN BANDUNG
0003 UJANG JAKARTA
SELECT * FROM TABLE
![Page 11: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/11.jpg)
Hierarki Database
![Page 12: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/12.jpg)
MySQL
adalah sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh dunia
http://www.mysql.com
![Page 13: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/13.jpg)
Fitur-fitur MySQL
Termasuk RDBMS Client-Server Mengenal SQL Standar SubSELECT Views dan Trigers Function dan Stored Procedure. Replication Free, Aman, dan Stabil Dukungan dari komunitas
![Page 14: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/14.jpg)
Next …
![Page 15: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/15.jpg)
Instalasi MySQL
Download source dihttp://www.mysql.com/downloads/
![Page 16: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/16.jpg)
Instalasi MySQL
Just Next… next… and Finish!
Video Instalasi
![Page 17: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/17.jpg)
MySQL Client
MySQL Command Line Client
![Page 18: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/18.jpg)
MySQL Client
MySQL-Front.
![Page 19: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/19.jpg)
MySQL Client
PHPMyAdmin
![Page 20: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/20.jpg)
MySQL Client
SQLYog
![Page 21: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/21.jpg)
MySQL Client
MySQL Administrator dan MySQL Control Center
![Page 22: Sekilas Tentang MySQL](https://reader035.vdokumen.com/reader035/viewer/2022062220/5560cb76d8b42a19088b4b9e/html5/thumbnails/22.jpg)
Achmad SolichinFak. Teknologi Informasi, Univ. Budi Luhurhttp://[email protected], [email protected]