PRAKTEK MYSQL

Membuat tb_pengguna

Menambahkan UNIQUE pada field email

Membuat Index pada field nama dan no telp

Mengedit Data type pada field no_telp

Memasukan data ke dalam tabel tb_pengguna

Menampilkan semua data tb_pengguna

Membuat tabel tb_team

Membust tabel tb_koordinator 

Menambahkan PRIMARY KEY dan FOREIGN KEY pada tabel tb_team dan tb_koordinator

Memasukkan data pada tb_team dan tb_koordinator

Menampilkan semua data masing masing tabel

Menampilkan beberapa data pada masing masing tabel

Menampilkan data pada masing masing tabel menggunakan filter 

INNER JOIN

LEFT JOIN

RIGHT JOIN

Rename tb_pengguna tb_anggota

Add colum team into tb_anggota

Add relation between tb_anggota and tb_team

Truncate all table

tb_anggota

tb_koordinator

tb_team

Insert 5 data into tb_koordinator

insert 6 with 2 NULL data into tb_team

insert 60 data into tb_anggota with some NULL data on field team

Get Data From All Tables With Null Data From Table Tb_koordinator

Get Data From All Tables Without Null Data From Table Tb_koordinator

Get Data only field fullname from tb_koordinator and fullname from tb_anggota without null data 

Get Data only field fullname from tb_koordinator and fullname from tb_anggota with null data

Get Data From All Tables Sort By Fullname From Tb_anggota Alphabetically

Count the number of Members Based on fullname on tb_koordinator that has members more than or Equal To 5

Create View From Data On Point 26

Create Temporary Table From Data On Point 26 

Truncate Table Temporary 

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

Add Column Captain Using Data Type Boolean

Update Data tb_anggota For Rach Team Have 1 Captain

Add Column jenis_kelamin Using Data Type Enum

Update Data tb_anggota For Column jenis_kelamin

Get Data From 3 All Table Sort by fullname from tb_anggota alphabetically