Rabu, 18 Mei 2016

Learn SQL in codecademy.com & Belajar MYSQL di dumetschool.com(3)

    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