praktikum sistem basis data dosen : nahot … filefungsi string dan database relational mata kuliah...
TRANSCRIPT
![Page 1: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/1.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 2: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/2.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
1. Mysql>CREATE DATABASE ’fungsi_string’;
2. Buattabeldengannama “string”
![Page 3: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/3.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 4: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/4.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
3. Mysql> SELECTascii("%")nilai_asciinya
![Page 5: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/5.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
4. Mysql> SELECTchar(37,65,43,37,66)karakternya_adalah
![Page 6: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/6.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
5. Mysql> SELECTchar_length("akuinginpulang")Jumlah_karakternya
![Page 7: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/7.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
6. Mysql> SELECTencode("AuTo","CAD")Kodenya_adalah
![Page 8: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/8.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
7. Mysql> SELECTleft("Indonesia","3")3Digit_Dari_Kiri
![Page 9: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/9.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
8. Mysql> SELECTmid("Indonesia","4","3")3Digit_dari_huruf_O
![Page 10: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/10.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 11: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/11.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
9. Mysql> SELECTright("Indonesia","3")3Digit_Dari_Kanan
10. Mysql> SELECTlcase("KUMENANTI DALAM KESUNYIAN")Perubahannya_adal ah
![Page 12: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/12.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 13: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/13.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
11. Mysql> SELECTupper("kumenantidalamkesunyian")Perubahannya_adalah
12. Mysql> SELECTltrim(" Kugapaiharapan")Setelah_di_ltrim
![Page 14: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/14.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 15: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/15.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
13. Mysql> SELECTrtrim(" Kugapaiharapan ")Setelah_di_rtrim
14. Mysql> SELECTtrim(" Kugapaiharapan ")Setelah_di_trim
![Page 16: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/16.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 17: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/17.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
15. Mysql> SELECTpassword("rahasia")Di_password_menjadi
![Page 18: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/18.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 19: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/19.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
CREATE TABLE `mahasiswa`.`matakuliah` ( `Kode_matakuliah` CHAR( 10 ) NOT NULL , `sks` CHAR( 2 ) NOT NULL ) ENGINE = MYISAM ;
![Page 20: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/20.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 21: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/21.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 22: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/22.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
INSERT INTO `mahasiswa`.`matakuliah` ( `Kode-mtk` , `sks` ) VALUES ( 'MKB-B425', '2' ), (
![Page 23: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/23.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
'MKB-B426', '2' ), ( 'MKB-B427', '3' ), ( 'MKB-B428', '3' ), ( 'MKB-B429', '2' ), ( 'MKB-B430', '3' ), ( 'MKB-B431', '3' ), ( 'MKB-B432', '2' );
![Page 24: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/24.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 25: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/25.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 26: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/26.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 27: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/27.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 28: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/28.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
CREATE TABLE `mahasiswa`.`kuliah` ( `NPM` VARCHAR( 15 ) NOT NULL , `Kode-mtk` VARCHAR( 10 ) NOT NULL ) ENGINE = MYISAM
![Page 29: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/29.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 30: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/30.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 31: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/31.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 32: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/32.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
INSERT INTO `mahasiswa`.`kuliah` ( `NPM` , `Kode-mtk` ) VALUES ( '201043501066', 'MKB-B425' ), ( '201043501067', 'MKB-B426' ), ( '201043501068', 'MKB-B427' ), ( '201043501069', 'MKB-B428' ), ( '201043501070', 'MKB-B429' ), ( '201043501071', 'MKB-B430' ), ( '201043501072', 'MKB-B431' ), ( '201043501073', 'MKB-B432' );
![Page 33: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/33.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 34: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/34.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 35: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/35.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 36: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/36.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 37: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/37.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 38: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/38.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
CREATE TABLE `Mahasiswa`.`daftar_mahasiswa_matakuli ah` ( `nomor` INT( 2 ) NULL DEFAULT NULL , `NPM` VARCHAR( 15 ) NULL DEFAULT NULL , `Kode-mtk` VARCHAR( 10 ) NULL DEFAULT NULL , `sks` VARCHAR( 2 ) NULL DEFAULT NULL ) ENGINE = MYISAM ;
![Page 39: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/39.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 40: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/40.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 41: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/41.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
INSERT INTO `mahasiswa`.`daftar_mahasiswa_matakulia h` ( `nomor`, `NPM`, `Kode-mtk`, `sks` ) VALUES ( '1', '201043501066', 'MKB-B425', '2' ), ( '2', '201043501067', 'MKB-B426', '2' ), ( '3', '201043501068', 'MKB-B427', '3' ), ( '4', '201043501069', 'MKB-B428', '3' ), ( '5', '201043501070', 'MKB-B429', '2' ), ( '6', '201043501071', 'MKB-B430', '3' ), ( '7', '201043501072', 'MKB-B431', '3' ), ( '8', '201043501073', 'MKB-B432', '2' );
![Page 42: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/42.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 43: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/43.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 44: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/44.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 45: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/45.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 46: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/46.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 47: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/47.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
CREATE TABLE `mahasiswa`.`buku` ( `kobuk` VARCHAR( 10 ) NULL DEFAULT NULL , `judul` VARCHAR( 11 ) NULL DEFAULT NULL , `pengarang` VARCHAR( 11 ) NULL DEFAULT NULL , `rk1` INT( 10 ) NULL DEFAULT NULL , `rk2` INT( 10 ) NULL DEFAULT NULL , `rk3` INT( 10 ) NULL DEFAULT NULL ) ENGINE = MYISAM ;
![Page 48: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/48.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 49: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/49.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 50: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/50.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 51: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/51.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 52: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/52.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 53: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/53.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 54: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/54.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 55: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/55.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
CREATE TABLE `mahasiswa`.`rak_buku` ( `kobuk` VARCHAR( 10 ) NULL DEFAULT NULL ,
![Page 56: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/56.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
`judul` VARCHAR( 100 ) NULL DEFAULT NULL , `pengarang` VARCHAR( 100 ) NULL DEFAULT NULL , `kode_rk` INT( 10 ) NULL DEFAULT NULL ) ENGINE = MYISAM ;
![Page 57: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/57.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
INSERT INTO `mahasiswa`.`rak_buku` ( `kobuk` , `judul` , `pengarang` , `kode_rk` ) VALUES (
![Page 58: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/58.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
'101_K', 'SISTEM BASIS DATA', 'NAHOT FRASTIAN. S. K OM', '001' ), ( '102_K', 'STATISTIK LANJUTAN', 'NADUN. S. PD', '002 ' ), ( '103_K', 'MANAJEMEN PROYEK', 'SUKAMTO. M.M. M.PD', '003' ), ( '104_K', 'ARSITEKTUR KOMPUTER', 'AHMAD FAUZI S.KOM' , '004' ), ( '105_K', 'JARINGAN KOMPUTER', 'AHMAD FAIZAL S. KOM' , '005' ), ( '106_K', 'PPKN 2', 'LEO SOEMER S. S. Pd', '006' ), ( '107_K', 'PEND. AGAMA 2', 'NUR ALI M.A', '007' ), ( '108_K', 'BAHASA INGGRIS 2', 'ROSDIANA SIDIK S.PD', '008' );
![Page 59: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/59.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 60: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/60.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 61: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/61.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 62: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/62.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 63: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/63.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
SELECT* FROMMATAKULIAH LIMIT5
![Page 64: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/64.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 65: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/65.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
SELECT* FROMbuku LIMIT5
![Page 66: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/66.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
SELECT* FROMBUKU ORDERBYPENGARANG LIMIT3
![Page 67: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/67.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
![Page 68: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/68.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI
SELECTBUKU.JUDUL,BUKU.PENGARANG,KODE_RK FROMBUKU,RAK_BUKU WHERERAK_BUKU.KODE_RK=002 LIMIT0,30
![Page 69: PRAKTIKUM SISTEM BASIS DATA DOSEN : NAHOT … filefungsi string dan database relational mata kuliah praktikum sistem basis data / dosen : nahot frastian s.kom praktikum sistem basis](https://reader030.vdocuments.us/reader030/viewer/2022040703/5dd0af1ed6be591ccb623069/html5/thumbnails/69.jpg)
FUNGSI STRING DAN DATABASE RELATIONAL
MATA KULIAH PRAKTIKUM SISTEM BASIS DATA / DOSEN : NAHOT FRASTIAN S.KOM
PRAKTIKUM SISTEM BASIS DATA
DOSEN : NAHOT FRASTIAN, S.KOM
PROGRAM STUDI : TEKNIK INFORMATIKA
UNIVERSITAS INDRAPRASTA PGRI