SQL:Table Transformation in codecademy.com, Belajar PHP di malasngoding.com & Belajar Mysql di jagocoding.com

         Subqueries
1.Table Transformation
2.non-correlated subqueries I
3.non-correlated subqueries II
4.non-correlated subqueries III
5.correlated subqueries I
6.correlated subqueries II
7.generalization

       Set Operations
1.set operations
2.union
3.union All
4.intersect
5.except
6.generalizations

    Aggregate Functions
1.aggregate functions revisited
2.null
3.case when
4.count(case when)
5.sum(case when)
6.combining aggregates
7.combining aggregates II
8.generalizations

     Date,Number, and String Functions
1.date,time and string functions
2.dates
3.dates II
4.dates III
5.numbers
6.numbers II
7.strings
8.strings II
9.generalizations

      PHP
1.instalasi web server di windows
2.manipulasi pada string
3.mengulang belajar if/else
4.function pada PHP
5.koneksi database dengan PHP
6.mengenal include dan require pada PHP

     MYSQL
1.fungsi aggregate pada sql