Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Kusrini - DBMS - 8 - Data Manipulation Language. That video is uploaded by Kusrini Kusrini at 2020-05-28T08:12:13-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [BYpDrVS3uIo]
| Name | Kusrini - DBMS - 8 - Data Manipulation Language |
| Video Uploader | Video From Kusrini Kusrini |
| Upload Date | This Video Uploaded At 28-05-2020 15:12:13 |
| Video Discription | www. kusrini.com Video ini membahas tentang bagaimana menggunakan Data Manipulation Language untuk mengelola data dalam database. Video ini merupakan kelanjutan dari video tentang MySQL di https://www.youtube.com/watch?v=1SaI2cZcvdY. Script berikut diperlukan untuk memasukkan data ke dalam database yang diperlukan dalam latihan di akhir video: delete from krs; delete from mahasiswa; delete from kelas; delete from dosen; delete from matakuliah; insert into matakuliah (kode, matakuliah, sks) values ('P1', 'PEMROGRAMAN',2); insert into matakuliah (kode, matakuliah, sks) values ('B1', 'BAHASA INGGRIS',2); insert into matakuliah (kode, matakuliah, sks) values ('B2', 'BASIS DATA',4); insert into matakuliah (kode, matakuliah, sks) values ('S2', 'SISTEM PAKAR',2); insert into matakuliah (kode, matakuliah, sks) values ('S3', 'KALKULUS',Null); insert into dosen (nip, nama) values (1,'KUSRINI'); insert into dosen (nip, nama) values (2,'ANDI SUNYOTO'); insert into dosen (nip, nama) values (3,'HANIF AL FATTA'); insert into dosen (nip, nama) values (4,'DIAH'); insert into dosen (nip, nama) values (5,'EMA UTAMI'); insert into kelas (idkelas, kode, nip) values (1,'P1',2); insert into kelas (idkelas, kode, nip) values (2, 'P1',3); insert into kelas (idkelas, kode, nip) values (3, 'B2',1); insert into kelas (idkelas, kode, nip) values (4, 'B2',2); insert into kelas (idkelas, kode, nip) values (5, 'B1',4); insert into mahasiswa values (2001,1,'ANITA','MAGELANG','1-jan-1985'); insert into mahasiswa values (2001,2,'EKAWATI','YOGYA','2-aug-1988'); insert into mahasiswa values (2002,3,'FARIDA','MADIUN',null); insert into mahasiswa values (2002,4,'GALIH',null,null); insert into KRS values (1,1,4); insert into KRS values (1,3,3); insert into KRS values (2,1,2); insert into KRS values (2,2,3); insert into KRS values (3,1,null); insert into KRS values (4,1,1); Jika ada kesulitan dalam mengerjakan latihan, kita diskusikan dibagian komentar yuk... Selamat mencoba... BYpDrVS3uIo |
| Category | Entertainment |
| Tags | Kusrini | AMIKOM | DBMS | Database | SQL | DML | Mysql | Database Manipulation Language | Query |
