Manipulation SQL:
1.introduction
2.relational databases
3.statements
4.create
5.insert
6.select
7.update
8.alter
9.delete
10.generalizations
Queries
1.queries
2.select-II
3.select distinct
4.where
5.like-I
6,like-II
7.between
8.and
9.or
10.order by
11.limit
12.generalizations
Aggregate functions
1.aggregate functions
2.count
3.group by
4.sum
5.max
6.min
7.average
8.round
9.generalizations
Multiple Tables
1.multiple tables
2.primary key
3.foreign key
4.cross join
5.inner join
6.left outer join
7.aliases
8.generalizations
MYSQL
1.tanda persen dalam perintah sql
2.menghapus tabel pada phpmyadmin
3.menampilkan record database dengan while
4.type data mysql string numerik dan date and time
5.fungsi not in
6.DDL dan DML
Tidak ada komentar:
Posting Komentar