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

Pulang di Rumah(Pusing)

Make An Interactive Website in codecademy.com

      Interactive Website:Flipboard
1.preview
2.program skeleton
3.dropdown menu
4.next slide 1
5.next slide 2
6.next dot 1
7.next dot 2
8.previous slide 1
9.previous slide 2
10.previous dot 1
11.previous dot 2
12.congrulations

    mengulang belajar PHP di codingku.com
1.php dasar dan menengah

make a interactive website in codecademy.com & belajar MYSQL diduniailkom.com

     interactive website:push menu
1.preview
2.program skeleton
3.select an element
4.respond to a click
5.open the menu
6.review
7.close the menu
8.congrulation

    interactive website:news reader
1.preview
2.program skeleton
3.show a description
4.hide other description
5.mark the current article
6.keyboard shortcuts
7.the o shortcuts
8.the n shortcuts 1
9.the n shortcuts 2
10.congrulations

    interactive website:status update
1.preview
2.program skeleton
3.create a new post
4.clear out the status box
5.count characters left
6.reset the counter
7.disable the botton 1
8.disable the botton 2
9.congrulations

    MYSQL
1.dasar penulisan query di mysql
2.membuat dan menghapus user mysql
3.mengubah case huruf besar dan kecil
4.menghapus baris dari tabel mysql

make a website in codecademy & dumetschool.com

     a closer look at CSS
1.why use CSS
2.link to a stylesheet
3.anatomy of a css rule
4.font-family
5.color
6.css class selectors
7.font-size
8.a background image
9.css id selectors
10.css review

   boundaries and space
1.the box model
2.create a border
3.working with padding
4.working with margin
5.more margins
6.understanding display
7.keep it inline
8.using float
9.display:flex
10.working with position
11.review

   Building with bootstrap
1.css frameworks
2.connecting to bootstarp
3.on the grid
4.header/navigation
5.the jumbotron
6.supporting content
7.footers
8.bootstrap generalization

    Dumetschool.com
1.perbedaan mysql_connect dengan mysql p_connect
2,menggunakan fungsi addlashes
3.fungsi AS pada mysql
4.berkenalan dengan scope operator php
5.perbedaan mysql fetch array dengan mysql fetch assoc
6.tipe data numerik pada mysql

sakit

sakit

SQL:Analyzing Business Metrics in codecademy & belajar PHP di dumetschool

       Advanced Aggregates
1.introduction
2,daily counts
3.daily count 2
4.daily revenue
5.daily sum conclusion
6.meal sums
7.product sums 2
8.product sum conclusion
9.grouping with case statements
10.product grouping conclusion
11.reorder rates
12.conclusion
    Common Metrics
1.introduction
2.daily revenue
3.daily revenue 2
4.daily active users
5.daily active users
6.daily average revenue per purchasing user
7.daily average revenue per user
8.ARPU 2
          23 may 2016
9.ARPU 3
10.ARPU 3
11.1 day retention
12.1 day retention 2
13.1 day retention 3
14.comon metrics conclusion

1.pengenalan codeigneter
2.melakukan looping while dengan dua variable
3.melakukan looping for dengan dua variable
4.menghitung jumlah kata
5.penggunaan fungsi break dan continue
6.cara mencari anggota array

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

Belajar PHP dan MYSQL di dumetschool.com (2)

                                MYSQL
1.mysql substring query
2.cara export dan import dalam database
3.perbedaan storage engine mylsam dan innodb
4.sql query: AVG(),MAX(),MIN(), dan SUM()
5.menampilkan data acak menggunakan rand()
6.fungsi sql length

                                 PHP
1.mengenal fitur namespace
2.membuat query mysqli dengan OOP
3.teknik mysql dengan OOP (XAMPP or MAMP)
4.cara menulis file
5.menganal tipe data boolean
6.looping do while dengan 2 variable

Belajar PHP dan MYSQL di dumetschool.com (1)

                                           MYSQL
1.pengertian dan penggunaan inner join,right join,dan left join
2.menghitung jumlah data menggunakan count
3.Sql NOW function
4.mereset nilai auto increment
5.membuat query urut
                                            PHP
1.perbedaan CONNECT_ERRNO dengan CONNECT_ERROR
2.perbedaan variabel dan konstanta
3.contoh penggunaan fungsi Die() pada
4.cara menampilkan waktu dengan
5.mengenal operator logika &&,xor,||
6.mengenal directory index pada.htaccess
7.membuat error pada .htaccess

introduction for loops in JS,introduction while loops in JS,dragonsleyer

6.how does it work?
7.practice counting down
8.last practice for loop
9.meet arrays
10.arrays positions
11.loops and arrays I
12.loops and arrays I
13.conclusion

1.what you'll building
2.declare your variabel
3.your first "for" loop
4.your "if" statement
5.your second "for" loop
6.log it!
7.victory!

1.while we're at it
2.while syntax
3.a fellow of infinite loops
4.brevity is the soul of programming
5.practice makes perfect
6.solo flight
7.mid-lesson breather
8.when to "while" and when to "for"
9.the "do"/"while" loop
10.to learn it, you gotta "do" it
11.review

1.what you'll building
2.declare your variables
3.the "while" loop
4.the first "if" statement
5.the secound "if" statement
6.well done!

getting started progaming JS,program your first game,introduction in JS,build rock.paper.scissors,for loops in JS

21.modulo and if/else
22.substrings
23.more substring practice
24.variables
25.more variable practice
26.change variable values
27.conclusion:part 1
28.conclusion:part 2

1.confirm
2.old enough to play
3.adding some story
4.first move
5.the story heats up
6.asking for feedback
7.next steps

1.introduction
2.introducing function
3.function syntax(greeting)
4.how does a function work?
5.trying it all together
6.Dont Repeat Yourself
7.return keyword
8.function return and if/else
9.functions with two parameters
10.global vs local variables
11.functions recap
12.functions & if/else
13.conclusion

1.the game
2.user choice
3.computer choice:part I
4.computer choice:part II
5.both choices are the same
6.what if choice1 is rock?
7.what if choice1 is paper?
8.what if choice1 is scissors?
9.next steps

1.why use for loops
2.first for loops
3.starting the for loop
4.ending the for loop
5.controlling the for loop

css positioning,projecting confidence&learning about javascript(geeting strated with programing)

1.see it to believe it
2.talking up space
3.inline-block
4.inline
5.none
6.sketching it out
7.margin
8.margin top,right,bottom right
9.borders
10.padding
11.negative values
12.review
13.to the right(float)
14.to the left(float)
15.float for two
16.clearing elements
17.static by default
18.absolute positioning
19.relative positioning
20.fixed positioning
21.the story so far
22..navigation bar,where are you
23.displaying it properly
24.floating right along
25.you've done it

1.what you'll be building
2.laying out your divs
3.sizing and color
4.fixing your header
5.floating right and left
6.clearing the footer
7.headings paragraphs and lists
8.victory
                                Java Script
1.what is your name
2.discofer the lenght
3.basic math
4.numbers and more
5.error:does not compute
6.editor and comments
7.what am i learning
8.interactive javascript(confrim)
9.what is programing(prompt)
10.data types I&II:numbers&string
11.data types III:booleans
12.using consolw.log
13.comparisons
14.decisions,decisions
15.computers are smart
16.more partice with  conditionals
17.computers aren't smart
18.mid-lesson breather
19.math
20.math and the module

HTML&CSS Design a Button for Your Website,CSS selectors,it's a class act

1.what you'll be building
2.drawing your button
3.shaping your button
4.positioning your button
5.Adding the link
6.it's alive

1.All Html elements are selectors
2.multiple selectors
3.one selector to rule them all
4.rock your selectors
5.brancing
6.parents,children and siblings
7.swinging from branch to branch
8.can you swing it
9.see it to believe it
10.beyond HTML elements
11.keeping it classy
12.id,please
13.putting it all together
14.even finer control
15.links
16.first child
17.nth child
18.snow it if you know it
19.final section breather
20.multiple selectors
21.class selectors
22.id selectors
23.pseudo selectors

1.what you'll be building
2.divide and conquer
3.style those divs!
4.classify
5.use classes to add class
6.no id, no entry
7.identify your IDs
8.you've done it

lerarning codecademy HTML Basics III & css An Overview

1.introduction html and css
2.what are tables
3.rows on information
4.a single column
5.adding a seccond column
6.head of the table
7.table heads
8.naming your table
9.style that head
10.recap
11.'Div'ide and conquer
12.link it!
13.spantastic
14.span is the man
15recap

1.seeing is believing
2.what css is
3.why sparate from from function?
4.if it's in,it's out
5.link it up
6.PSA:selfclosing tags
7.syntax for the wintax
8.one selector many properties
9.many selectors many properties
10.the impoertance of semicolons
11.color commentary
12.Check yourself before you wreck yourself
13.hexawhatnow
14.roses and red 
15.pixels and em
16.a font of knowledge
17.backup values
18.review
19.background color,height and width
20.bordering on insanity
21.links and text decoration
22.html+css=bffs
23.many selector many properties
24.fall back
25size and borders
26.links and text decoration

Learning Repeat HTML&CSS in CodeCademy

1.why learn HTML
2.HTML&CSS
3.Basic Terminology
4.Make The Head
5.Paragraphs in the body
6.paragraphs and headings
7.more about headings
8.using every heading
9.mid-lesson breather
10.you're going places
11.adding images
12.click that images
13.images and links
14.congrulation
15.what you'll be making
16.every house needs a frame
17.it's better with a header
18.tell us about your self in html
19.a pictures worth a thousand words
20.link me
21.introduction html
22.indentation is your friend
23.ordered list
24.one more ordered list
25.unordered lists
26.lists inside a list
27.making comments
28.font size
29.font color
30.font family
31.recap
32.background color
33.aligning the text
34.strong words
35.emphasize words
36.summary
37.here's what you're building
38.you have the power
39.a bit about you
40.profile sections
41.lists within lists
42.fancy up your font
43.bold! italic! bold!