Praktikum SQL dalam Database
Praktikum 1. CREATE TABLE tb_pengguna
Praktikum 6. CREATE TABLE tb_team
Praktikum 7. CREATE TABLE tb_koordinator
Praktikum 8. ADD CONSTRAINT FOREIGN KEY
Praktikum 9. INSERT DATA INTO TABLE tb_team dan tb_koordinator

Praktikum 13. Get Data From Table tb_team And tb_koordinator Using Inner Join
Praktikum 14. Get Data From Table tb_team And tb_koordinator Using Left Join
Praktikum 15. Get Data From Table tb_team And tb_koordinator Using Right Join
Praktikum 16. Rename Tb_pengguna To Tb_anggota
Praktikum 17. Add Column Team On Tb_anggota
Praktikum 18. Add Relation Between Tb_anggota And Tb_team
Praktikum 19. Truncate All Tables
Praktikum 20. Insert Data Into Table tb_koordinator
Praktikum 21. Insert Data Into Table tb_team
Praktikum 22. Insert Data Into Table tb_anggota
Praktikum 23. Get Data From All Tables With Null Data From Table Tb_koordinator
Praktikum 24. Get Data From All Tables Without Null Data From Table Tb_koordinator
Praktikum 25. Get Data only field fullname from tb_koordinator and fullname from tb_anggota without null data
Praktikum 26. Get Data only field fullname from tb_koordinator and fullname from tb_anggota with null data
Praktikum 27. Get Data From All Tables Sort By Fullname From Tb_anggota Alphabetically
Praktikum 28. Count The Number Of Members Based On The Team
Praktikum 29. Count The Number Of Members Based On Fullname On Tb_koordinator That Has Members More Than Or Equal To 5.
Praktikum 30. Create View From Data On Point 26
Praktikum 31. Create Temporary Table From Data On Point 26
Praktikum 32. Truncate Table Temporary
Praktikum 33. Insert Data Into Table Temporary From View Using Query Insert Data Using Select
Praktikum 34. Add Column Captain Using Data Type Boolean
Praktikum 35. Update Data tb_anggota For Rach Team Have 1 Captain
Praktikum 36. Add Column jenis_kelamin Using Data Type Enum
Praktikum 37. Update Data tb_anggota For Column jenis_kelamin
Praktikum 38. Get Data From 3 All Table Sort By Fullname From Tb_anggota Alphabetically
Komentar
Posting Komentar