101 – Konfigurasi MySQL

  1. Instalasi MySQL
  2. Instalasi MySQL GUI Tools
  3. Penjelasan MySQL Connector/J
  4. Dump & Restore
  5. Integrasi dengan Netbeans

102 – JDBC Fundamental

  1. Konsep JDBC & Driver
  2. Connect/Disconnect
  3. Statement
  4. ResultSet
  5. PreparedStatement

 


103 – JDBC AdvancedConnection Pooling

  1. Batch Operation
  2. Binary Data
  3. Date, Time, Timestamp

 


104 – Transaction

  1. Local Transaction
  2. Managed Transaction

    1. Programmatic Transaction
    2. Declarative Transaction
  3. Transaction Isolation (ACID)
  4. Transaction Propagation
  5. XA Transaction

    1. 2 Phase Commit
    2. Problems with XA Transaction
    3. Alternative to XA
  6. Transaction Pattern

    1. Client Managed Transaction
    2. Service Facade Transaction
    3. Server Delegate Transaction