OPTIMIZING RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS) IMPLEMENTATION USING MICROSOFT ACCESS 2007 AND SQL METHOD

Applications, Databases, Jakarta / By

OPTIMIZING  RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS) IMPLEMENTATION USING MICROSOFT ACCESS 2007 AND SQL METHOD

Menara Peninsula Hotel, Jakarta | 24 – 25 April 2013 | Rp. 3.500.000,-

 

 

Outline :

  1. Konsep  Database, Table, Record dan Field.
  2. Fungsi Database, Table, Record dan Field.
  3.  Syarat-syarat penulisan nama file database, file table dan field name.
  4. Database, Table, Record dan Field.
  5. Field Name dengan type-type datanya
  6. Field Index Primary Key.
  7. Memasukkan data ke dalam Database dengan metode standard.
  8. Memasukkan data ke dalam Database dengan metode import dari file Excel.
  9. Memasukkan data ke dalam Database dengan metode import dari file Text.
  10. Konsep Normalisasi Database.
  11. Fungsi Normalisasi Database.
  12. Kelebihan dan Kelemahan dari Database yang belum dinormalisasi dengan Database yangsudah dinormalisasi.
  13. Langkah-langkah dalam pembuatan Normalisasi Database.
  14. Konsep table master dan transaction.
  15. Fungsi  table master dan transaction.
  16. Table master dengan menggunakan SQL –  Distinct.
  17. Table transaction dengan menggunakan SQL –  Distinct.
  18. Memahami konsep pembuatan Relational Table.
  19. Memahami fungsi Relational Table.
  20. Memahami persyaratan-persyaratan dalam pembuatan Relational Table.
  21. Standard Query Design.
  22. Memodifikasi & menjalankan Standard Query Design.
  23. Standard Query dengan kriteria tertentu
  24. Updated Query
  25. Updated Query dengan Arithmetic Function dan Logic Function.
  26. Form database processing.
  27. Form graphic display.
  28. Report database processing with  Report Designer
  29. Database processing application dengan tampilan disain menu utama.
  30. Proteksi aplikasi pengolahan database management system.

 

Date & Venue :

24 -25 April 2013

At Menara Peninsula Hotel – Jakarta

 

Facilitator :

Erawan Supriyatna, S.Kom

 

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training
  1. INFORMATION OPTIONS
  2. (required)
  4. (required)
  5. PERSONAL DATA
  6. (required)
  7. (required)
  8. (required)
  10. (valid email required)
  11. (required)
  12. (required)
  16. PRE REGISTRATION DATA (Tidak Mengikat)
  20. (required)
  23. MESSAGE FOR TRAINING PROVIDER
  26. Captcha
 

cforms contact form by delicious:days

 

 

Related Training:

  1. RDBMS IMPLEMENTATION WITH ACCESS 2007 AND SQL METHOD FOR IT & NON IT OPTIMIZATION OF RDBMS IMPLEMENTATION WITH ACCESS 2007 AND SQL METHOD FOR IT & NON IT Estubizi Business Center, Jakarta selatan | 4 – 5 September 2013  | Rp 3.500.000,- A.   ...
  2. RDBMS IMPLEMENTATION WITH ACCESS 2010 AND SQL METHOD FOR IT & NON IT OPTIMIZATION OF RDBMS IMPLEMENTATION WITH ACCESS 2010 AND SQL METHOD FOR IT & NON IT Estubizi Business Center, Jakarta selatan | 3 – 4 Oktober 2013 | Rp 3.500.000,-  ...
  3. POS APPLICATION DEVELOPMENT WITH INVENTORY CONTROL USING ACCESS 2007 FOR IT & NON IT POS APPLICATION DEVELOPMENT WITH INVENTORY CONTROL USING ACCESS 2007 FOR IT & NON IT Estubizi Business Center, Jakarta selatan | 28 – 29 Maret 2014 | 09.00 – 16.30 WIB | Rp...
  4. POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007 POWERFUL DATABASE ANALYSIS AND DASHBOARD REPORTING WITH EXCEL 2007 Hotel Fave Melawai, Jakarta | 17 – 18 Juni 2016 | RP 3.500.000 Hotel Fave Melawai, Jakarta | 24 – 25 Juli 2016 |...
  5. Optimalisasi Metode Penganggaran dengan Ms. Excel Optimalisasi Metode Penganggaran dengan Ms. Excel Jakarta | 24 – 25 November 2015 | Rp. 4.250.000     Pendahuluan Pelatihan Optimizing Budgeting With Excel Spreadsheet ini akan memberikan pengetahuan dan...
  6. POWERFUL DATA ANALYSIS & REPORTING WITH EXCEL 2007 POWERFUL DATA ANALYSIS & REPORTING  WITH EXCEL 2007 Estubizi Business Center,  Jakarta | 10 – 11 Juni 2013 | 08.30 – 16.30 WIB | Rp 3.500.000,-     BACKGROUND Masih sering...
  7. 40 Jurus Rahasia Ms.Excel – AVAILABLE ONLINE TRAINING 40 JURUSAN RAHASIA MS.EXCEL UNTUK REPORTING AND ANALISA | Available Online...
  8. MASTERING MICROSOFT PROJECT 2007 MASTERING MICROSOFT PROJECT 2007 (Concept and Application) Fave Hotel Melawai, Jakarta | 23 – 24 Mei 2019 | Rp. 4.000.000,- Fave Hotel Melawai, Jakarta | 12 – 13 Juni 2019...
  9. MASTERING EXCEL 2010 BEYOND FOR OFFICE DATA PROCESSING SYSTEM MASTERING EXCEL 2010 BEYOND FOR OFFICE DATA PROCESSING SYSTEM Estubizi Business Center, Jakarta selatan | 22 – 23 Juli 2014 | 09.00 – 16.30 WIB |  Rp 3.500.000,- BACKGROUND Microsoft Excel...
  10. Filing System Soft and Hard Document with Excel 2007 & VBA for Management Filing System Soft and Hard Document with Excel 2007 & VBA for Management Estubizi Business Center, Jakarta | 17 – 18 Maret 2014 | Rp. 3.500.000,-   Tingginya tingkat persaingan organisasi...