Praktik database

 1. Membuat tabel

2. Menambahkan unique

3. Menambah index

4. Edit data type

5. Insert data 

Dengan menggunakan perintah:

INSERT INTO tb_pengguna (`userid`, `nama`, `email`, `no_telp`) VALUES (1, `agus`, `agus.tus@gmail.com`, 08134678);

Hasil insert:

6. Membuat table team

7. Membuat table koordinator

8. Menambahkan foreign key

9. Insert tb_team dan tb_koordinator

Insert tb_team:

hasil insert tb_team:

Insert tb_koordinator:

hasil insert tb_koordinator:

10. Get data for each table created for all fields

11. Get data for each table created for some field

12. Get data for each table created using filter

13. Using inner join

14. Using left join

15. Right join

16. Rename tabel

17. Add column

18. Add relation between

19. Truncate all tables

20. Insert data into tb_koordinator

21. Insert data into tb_team

22. Insert data into table, 60 data

23. Get data with null from tb_koordinator

24. Get data without null from tb_koordinator

25. Get data only field fullname without null

26. Get data only field with null

27. Get data from all tables alphabetically

28. Count the number of  members

29. Count The Number Of Members Based On Fullname On Tb_koordinator That Has Members More Than Or Equal To 5.

30. Create View From Data On Point 26

31. Create Temporary Table From Data On Point 26

32. Truncate Table Temporary

33. Insert Data Into Table Temporary From View Using Query Insert Data Using Select

34. Add Column Captain Using Data Type Boolean

35. Update Data tb_anggota For Rach Team Have 1 Captain

36. Add Column jenis_kelamin Using Data Type Enum

37.  Update Data tb_anggota For Column jenis_kelamin

38. Get Data From 3 All Table Sort By Fullname From Tb_anggota Alphabetically