Dasar-dasar SQL

insert into mahasiswa values (:nim,:nama,:jurusan,:alamat)
update manufaktur set NAMA=’Amey’  where  NO_MANU=1
SELECT * from mahasiswa order by nim
SELECT * from manufaktur where no_manu=1
delete from FRS where semester=:semester
Update MHS set nama=:amey where nama=Imoet

mahasiswa
insert into mahasiswa values (:nim,:nama,:alamat,kd_jurusan)
delete from mahasiswa where nim=:nim
update mahasiswa set nama=:nama, alamat=:alamat, where nim=:nim
SELECT * from mahasiswa

dosen
insert into mahasiswa  values (:nim,:nama,:jurusan,:alamat)
delete from mahasiswa where nim=:nim
update mahasiswa set nim=:nim where  nama=:nama
SELECT * from dosen

jurusan
insert into jurusan values (:kd_jurusan,:nama)
delete from jurusan  where :kd_jurusan
update jurusan set nama=:nama where kd_jurusan=:kd_jurusan
SELECT * from jurusanx

khs
insert into mahasiswa values (:nim,:nama,:jurusan,:alamat)
delete from mahasiswa where nim=:nim
update mahasiswa set nim=:nim where  nama=:nama
SELECT * from mahasiswa order by nim

Select * from MHS inner join FRS on MHS_nim=FRM_nim Where semester=2

NB: Inner Join Bisa Diganti:
1.    Left join
2.    Right join
3.    Cross join