Silabus Training ASP.Net

Silabus/ Syllabuss Training ASP.NET

Web and Application programming
with ASP.NET

 

 

 

Deskripsi

:

ASP.Net merupakan salah satu teknologi Aplikasi server berbasis framework dari Microsoft, Kemunculan ASP.Net 4.0 dalam paket Software Visual Studio memberikan kemampuan yang lebih terutama dalam hal penanganan object control yang disediakan, terlebih lagi dengan penggunaan bahasa C# yang memungkinkan efisiensi coding hingga 70%

 

 

 

Tujuan Training

:

Peserta memahami pemograman ASP.Net dengan C# dalam pembuatan Web atau Application

 

 

 

 

Target Peserta

:

          Web Programmer

          Aplication Programmer

          Umum , Mahasiswa

 

 

 

Prasyarat

:

          Disarankan telah memahami konsep dasar pemograman

          Mengerti database

 

 

 

Materi Training

:

·         Introduction of Microsoft .NET Framework and ASP.NET

·         Create a component in Visual Basic .NET or C#.

·         Create an ASP.NET Web application project by using Visual Studio .NET.

·         Add server controls to an ASP.NET Web Form.

·         Create and populate ASP.NET Web Forms.

·         Add functionality to server controls that are on an ASP.NET Web Form.

·         Use the Trace and Debug objects with Visual Studio .NET.

·         Use validation controls to validate user input.

·         Create a user control.

·         Access data by using the built-in data access tools that available in Visual

·         Studio .NET.

·         Use Microsoft ADO.NET to access data in an ASP.NET Web application.

·         Accomplish complex data access tasks from an ASP.NET Web application.

·         Access Extensible Markup Language (XML) data and read it into a DataSet.

·         Call an XML Web service from an ASP.NET Web application and incorporate the

·         returned data into a Web application.

·         Store application and session data by using a variety of methods.

·         Configure and deploy an ASP.NET Web application.

·         Secure an ASP.NET Web application by using a variety of technologies.

 

 

 

HERY PURNAMA – 081.223344.506 Freelance trainer untuk traning ASP.NET . Aktif di beberapa training center di Jakarta ,Bandung ,Surabaya ataupun diundang sebagai Inhouse Trainer di beberapa perusahaan baik bidang industri, pertambangan, finansial, asuransi, perbankan di seluruh indonesia

Hery adalah Inhouse trainer ASP.NET  di bandung, Jakarta, bekasi, bogor, sukabumi, semarang, yogya, Surabaya, bali, Lombok, ntb, ambon, jayapura, makasar, menado, Banjarmasin, Pontianak, palangkaraya, Balikpapan, samarinda, batam, lampung, Palembang, Riau, Padang, Medan, Aceh, Malaysia, Singapore , sisindotek training center dan wilayah Indonesia , Undangan Inhouse training bisa menghubungi  Hery – 081.223344.506 atau inhousetrainer@yahoo.com

Topik training lain yang diberikan Hery : sencha-extjs, excel-vba-macro, itil-cobit-cisa-uml, codigniter-yii,oracle-dba, sqlserver-dba, asp-net, vb-net, google-map-api, google-sketchup-3d, excel-advance-accounting, project-management, ms-project-ASP.NET, SEO-Internet-Marketing, php-mysql-jquery, android-phonegap-jquery-mobile, ms-access-vba, visual-foxpro, Ubuntu-server, facebook-api-developer, python-programming, adobe-ASP.net, corel-draw, adobe-indesign, adobe-flash, cms-ASP.net, 3d-studio, autocad, mobile-apps-development, sms-gateway, spss-matlab, dan lainnya silahkan konsultasikan

Untuk informasi/konsultasi atau undangan sebagai inhouse trainer silahkan menghubungi :

HERY PURNAMA
OCA., CIW., ITILF.

Hometown  : Bandung – Indonesia
Call/SMS/WA : 081.223344.506
EM :
inhousetrainer@yahoo.com
BB : 7DC633AA
FB : inhousetrainer , TW : @inhousetrainer , INS : inhousetrainer

Blog : http://freelance-it-trainer.blogspot.com

 

[tags  trainer freelance ASP.NET , pengajar lepas ASP.NET , trainer bersertifikasi ASP.NET, cari trainer ASP.NET, butuh trainer ASP.NET, trainer ASP.NET di bandung , trainer ASP.NET di jakarta, trainer ASP.NET di bogor, trainer ASP.NET di bekasi, trainer ASP.NET di semarang, trainer ASP.NET di yogya, cari freelance trainer ASP.NET, butuh freelance trainer ASP.NET , trainer ASP.NET di Surabaya, lowongan trainer ASP.NET , kursus ASP.NET , trainer ASP.NET di bali, trainer ASP.NET di lombok, trainer ASP.NET di ambon, trainer ASP.NET di makasar, trainer ASP.NET di menado, trainer ASP.NET di Banjarmasin, trainer ASP.NET di samarinda , trainer ASP.NET di Pontianak, trainer ASP.NET dipalangkaraya, trainer ASP.NET di batam, trainer ASP.NET di Palembang, trainer ASP.NET di lampung, trainer ASP.NET di tangerang, trainer ASP.NET di padang, trainer ASP.NET di medan, trainer ASP.NET di aceh, trainer ASP.NET di Malaysia, trainer ASP.NET di Singapore, certified trainer ASP.NET , download ASP.NET , tutorial ASP.NET, ebook ASP.NET, tips trik ASP.NET, belajar ASP.NET, tempat training ASP.NET, inhouse training ASP.NET , sertifikasi ASP.NET, training ASP.NET di tambang , training ASP.NET di bank , training ASP.NET di universitas, training ASP.NET di hotel, training ASP.NET di perusahaan asuransi , sertifikasi ASP.NET, ujian ASP.NET, hery trainer ASP.NET , syllabuss ASP.NET , sisindotek training ASP.net, hubungi trainer ASP.NET , profesi trainer ASP.NET  , profile trainer ASP.NET , solusi ASP.NET, konsultasi ASP.NET, download ebook  ASP.NET gratis, download  gratis software ASP.NET ]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Silabus Training PHP Ajax Jquery

Silabus/ Syllabuss Training PHP Jquery

Building PHP MySQL-AJAX web application
with jQuery

 

 

 

Deskripsi

:

Bahasa PHP adalah  bahasa pemograman web yang popular saat ini, kemampuan PHP sudah tidak bias dipandang sebelah mata, dan saat ini PHP pun sudah jauh berkembang dengan munculnya PHP framework yang memudahkan pengembangan aplikasi berbasis web. Ditengah perkembangan kemampuan PHP MySQL , kehadiran JQuery menjadi sangat dibutuhkan untuk pengambangan aplikasi web yang interaktif dan dinamis sesuai standar web 2.0

 

 

 

Tujuan Training

:

1.      Peserta mampu membuat aplikasi atau web berbasis teknologi PHP serta menguasai dasar dasar pemograman PHP secara sistematis

2.      Mengetahui RDBMS concept dan perancangan database yang baik dengan MySQL

3.      Mengetahui pemanfaatan AJAX  untuk pengembangan Aplikasi yang interaktif sesuai standar web 2.0

 

 

 

Target Peserta

:

          Web Developer

          Web Designer

          Application Developer

          Umum/ Mahasiswa

 

 

 

Prasyarat

:

          Semua pengguna computer dapat mengikuti training ini

 

 

 

Materi Training

:

MySQL  Topics

          Introduction of MySQL

          Relational Databases.

          Data Types.

          Database Creation.

          NULL's.

          Dropping a table.

          SQL-DML commands (Insert, Select, Update, Delete).

          Describing a table.

          Running SQL commands from a file (Scripting)

          Object View

PHP Topics

          HTML overview

          Installing Apache, PHP, and MySQL

          PHP Basic Constructs

          Variables and data types

          Expressions and operators

          Conditional statements

          Iteration statements

          Functions

          Arrays and Objects

          Forms

          Cookies and Sessions

          Files and Directories

          Interacting with MySQL using PHP

AJAX and JQuery Topics

          jQuery fundamentals

          Selecting the elements upon which to act

          Generating new HTML

          Managing the wrapped element set

          Bringing pages to life with jQuery

          Working with element properties and attributes

          Changing element styling

          Setting element content

          Dealing with form element values

          Other event-related methods

          Putting events (and more) to work

          Energizing pages with animations and effects

          Showing and hiding elements

          Animating the display state of elements

          Creating custom animations

          A custom puff animation

          Animations and Queuing

          Beyond the DOM with jQuery utility functions

          Disabling animations  

          Detecting user agent support

          Using other libraries with jQuery

          Manipulating JavaScript objects and collections

          Miscellaneous utility functions

          Expand your reach by extending jQuery

          Why extend jQuery?

          The jQuery plugin authoring guidelines

          Writing custom utility functions

          Adding new wrapper methods

          Applying multiple operations in a wrapper method

          Retaining state within a wrapper method

 

 

HERY PURNAMA – 081.223344.506 Freelance trainer untuk traning PHP JQUERY . Aktif di beberapa training center di Jakarta ,Bandung ,Surabaya ataupun diundang sebagai Inhouse Trainer di beberapa perusahaan baik bidang industri, pertambangan, finansial, asuransi, perbankan di seluruh indonesia

Hery adalah Inhouse trainer PHP JQUERY  di bandung, Jakarta, bekasi, bogor, sukabumi, semarang, yogya, Surabaya, bali, Lombok, ntb, ambon, jayapura, makasar, menado, Banjarmasin, Pontianak, palangkaraya, Balikpapan, samarinda, batam, lampung, Palembang, Riau, Padang, Medan, Aceh, Malaysia, Singapore , sisindotek training center dan wilayah Indonesia , Undangan Inhouse training bisa menghubungi  Hery – 081.223344.506 atau inhousetrainer@yahoo.com

Topik training lain yang diberikan Hery : sencha-extjs, excel-vba-macro, itil-cobit-cisa-uml, codigniter-yii,oracle-dba, sqlserver-dba, asp-net, vb-net, google-map-api, google-sketchup-3d, excel-advance-accounting, project-management, ms-project-PHP JQUERY, SEO-Internet-Marketing, php-mysql-jquery, android-phonegap-jquery-mobile, ms-access-vba, visual-foxpro, Ubuntu-server, facebook-api-developer, python-programming, adobe-photoshop, corel-draw, adobe-indesign, adobe-flash, cms-wordpress, 3d-studio, autocad, mobile-apps-development, sms-gateway, spss-matlab, dan lainnya silahkan konsultasikan

Untuk informasi/konsultasi atau undangan sebagai inhouse trainer silahkan menghubungi :

HERY PURNAMA
OCA., CIW., ITILF.

Hometown  : Bandung – Indonesia
Call/SMS/WA : 081.223344.506
EM :
inhousetrainer@yahoo.com
BB : 7DC633AA
FB : inhousetrainer , TW : @inhousetrainer , INS : inhousetrainer

Blog : http://freelance-it-trainer.blogspot.com

 

[tags  trainer freelance PHP JQUERY , pengajar lepas PHP JQUERY , trainer bersertifikasi PHP JQUERY, cari trainer PHP JQUERY, butuh trainer PHP JQUERY, trainer PHP JQUERY di bandung , trainer PHP JQUERY di jakarta, trainer PHP JQUERY di bogor, trainer PHP JQUERY di bekasi, trainer PHP JQUERY di semarang, trainer PHP JQUERY di yogya, cari freelance trainer PHP JQUERY, butuh freelance trainer PHP JQUERY , trainer PHP JQUERY di Surabaya, lowongan trainer PHP JQUERY , kursus PHP JQUERY , trainer PHP JQUERY di bali, trainer PHP JQUERY di lombok, trainer PHP JQUERY di ambon, trainer PHP JQUERY di makasar, trainer PHP JQUERY di menado, trainer PHP JQUERY di Banjarmasin, trainer PHP JQUERY di samarinda , trainer PHP JQUERY di Pontianak, trainer PHP JQUERY dipalangkaraya, trainer PHP JQUERY di batam, trainer PHP JQUERY di Palembang, trainer PHP JQUERY di lampung, trainer PHP JQUERY di tangerang, trainer PHP JQUERY di padang, trainer PHP JQUERY di medan, trainer PHP JQUERY di aceh, trainer PHP JQUERY di Malaysia, trainer PHP JQUERY di Singapore, certified trainer PHP JQUERY , download PHP JQUERY , tutorial PHP JQUERY, ebook PHP JQUERY, tips trik PHP JQUERY, belajar PHP JQUERY, tempat training PHP JQUERY, inhouse training PHP JQUERY , sertifikasi PHP JQUERY, training PHP JQUERY di tambang , training PHP JQUERY di bank , training PHP JQUERY di universitas, training PHP JQUERY di hotel, training PHP JQUERY di perusahaan asuransi , sertifikasi PHP JQUERY, ujian PHP JQUERY, hery trainer PHP JQUERY , syllabuss PHP JQUERY , sisindotek training PHP Jquery, hubungi trainer PHP JQUERY , profesi trainer PHP JQUERY  , profile trainer PHP JQUERY , solusi PHP JQUERY, konsultasi PHP JQUERY, download ebook  PHP JQUERY gratis, download  gratis software PHP JQUERY ]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Inhouse Trainer CodeIgniter, Yii, ExtJS, Excel macro, MS Project, ITIL

HERY PURNAMA – 081.223344.506, Certified trainer di beberapa Training center ataupun sebagai freelance INHOUSE  trainer untuk topik ITIL, COBIT, CISA, SQA, UML, PM, Excel VBA macro, Sencha ExtJS / Touch, CodeIgniter, Yii, Android, Google MAP API , Google Sketchup 3D, Android Phonegap, Oracle DBA, SQL Server DBA, MS Project, Primavera P6, PHP Ajax Jquery, SMS gateway, MS. Access VBA, CMS WordPress, SEO Internet Marketing, Ubuntu Server, ASP.Net, VB.Net, Visual Foxpro , Excel Advanced for Business, Accounting and finance , android studio, Photoshop, CorelDraw, Indesign, Adobe Director, Ilustrator, 3D Studio, Autocad, dll.

Hery adalah Inhouse trainer excel vba macro, Extjs, android, oracle, ITIL di wilayah bandung, Jakarta, bekasi, bogor, sukabumi, semarang, yogya, Surabaya, bali, Lombok, ntb, ambon, jayapura, makasar, menado, Banjarmasin, Pontianak, palangkaraya, Balikpapan, samarinda, batam, lampung, Palembang, Riau, Padang, Medan, Aceh, Malaysia, Singapore dan wilayah Indonesia , Undangan Inhouse training bisa menghubungi  Hery – 081.223344.506 atau inhousetrainer@yahoo.com

Beberapa client inhouse training antara lain : Pertamina Geothermal Energy (Excel VBA Macro), Icon Plus PLN (Google Map API), Sampoerna Tbk., Bank BJB, AXA Insurance,  Kayan Putra Utama Coal , Komatsu  Remanufacturing Asia (Android), Wavin Duta Jaya (CodeIgniter with SQL Server) , Coresolutions Indonesia (CMS WordPress), Ebiz (ITIL & COBIT), Rumah Sakit Awalbros, Inalum – Medan (Project Management with MS Project) , Freeport Indonesia, ITB , ITENAS (Sencha ExtJS) dan puluhan lainnya silahkan visit http://freelance-it-trainer.blogspot.com atau hubungi 081.223344.506

Untuk informasi/konsultasi atau undangan sebagai freelance inhouse trainer silahkan menghubungi :

HERY PURNAMA
OCA., CIW., ITILF.

Hometown  : Bandung – Indonesia
Call/SMS/WA : +62-81.223344.506
EM : inhousetrainer@yahoo.com
BB : 7DC633AA
FB : inhousetrainer , TW : @inhousetrainer , INS : inhousetrainer

Blog : http://freelance-it-trainer.blogspot.com

 

[tags  trainer ITIL, trainer COBIT, trainer CISA, hery trainer, trainer SQA, trainer UML, trainer PM, trainer Excel VBA macro, trainer Sencha ExtJS , trainer sencha Touch, trainer CodeIgniter, trainer Yii, trainer Android, trainer Google MAP API , trainer Google Sketchup 3D, trainer Android Phonegap, trainer Oracle DBA, trainer SQL Server DBA, trainer MS Project, trainer Primavera P6, trainer PHP Ajax, trainer Jquery, trainer SMS gateway, trainer MS Access VBA, trainer CMS WordPress, trainer SEO Internet Marketing, trainer Ubuntu Server, trainer ASP Net, trainer VB Net, trainer Visual Foxpro , trainer Excel Advanced for Business, trainer android studio, trainer Photoshop, trainer CorelDraw, trainer Indesign, trainer Adobe Director, trainer Ilustrator, trainer 3D Studio, trainer Autocad , inhouse training, freelance trainer, it trainer di , training di bandung, training di Jakarta, training di bekasi, training di bogor, training di sukabumi, training di semarang, training di yogya, training di Surabaya, training di bali, training di Lombok, training di ntb, training di ambon, training di jayapura, training di makasar, training di menado, training di Banjarmasin, training di Pontianak, training di palangkaraya, training di Balikpapan, training di samarinda, training di batam, training di lampung, training di Palembang, training di Riau, training di Padang, training di Medan, training di Aceh, training di Malaysia, training di Singapore , training di Indonesia , Training di Pertamina Geothermal,  Training di Icon Plus PLN, Training di Sampoerna Tbk, Training di Bank BJB, Training di AXA Insurance,  Training di Kayan Putra Utama Coal , Training di Komatsu  Remanufacturing Asia, Training di Wavin Duta Jaya , Training di Coresolutions Indonesia, Training di Rumah Sakit Awalbros, Training di Inalum Medan , Training di Freeport Indonesia ]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Foto dan Sejarah Konferensi Asia Afrika 1955 Bandung

Konferensi Tingkat Tinggi Asia–Afrika (disingkat KTT Asia Afrika atau KAA; kadang juga disebut Konferensi Bandung) adalah sebuah konferensi antara negara-negara Asia dan Afrika, yang kebanyakan baru saja memperoleh kemerdekaan. KAA diselenggarakan oleh Indonesia, Myanmar (dahulu Burma), Sri Lanka (dahulu Ceylon), India dan Pakistan dan dikoordinasi oleh Menteri Luar Negeri Indonesia Sunario. Pertemuan ini berlangsung antara 18 April-24 April 1955, di Gedung Merdeka, Bandung, Indonesia dengan tujuan mempromosikan kerjasama ekonomi dan kebudayaan Asia-Afrika dan melawan kolonialisme atau neokolonialisme Amerika Serikat, Uni Soviet, atau negara imperialis lainnya.

Sebanyak 29 negara yang mewakili lebih dari setengah total penduduk dunia pada saat itu mengirimkan wakilnya. Konferensi ini merefleksikan apa yang mereka pandang sebagai ketidakinginan kekuatan-kekuatan Barat untuk mengkonsultasikan dengan mereka tentang keputusan-keputusan yang memengaruhi Asia pada masa Perang Dingin; kekhawatiran mereka mengenai ketegangan antara Republik Rakyat Tiongkok dan Amerika Serikat; keinginan mereka untuk membentangkan fondasi bagi hubungan yang damai antara Tiongkok dengan mereka dan pihak Barat; penentangan mereka terhadap kolonialisme, khususnya pengaruh Perancis di Afrika Utara dan kekuasaan kolonial perancis di Aljazair; dan keinginan Indonesia untuk mempromosikan hak mereka dalam pertentangan dengan Belanda mengenai Irian Barat.

Sepuluh poin hasil pertemuan ini kemudian tertuang dalam apa yang disebut Dasasila Bandung, yang berisi tentang "pernyataan mengenai dukungan bagi kerusuhan dan kerjasama dunia". Dasasila Bandung ini memasukkan prinsip-prinsip dalam Piagam PBB dan prinsip-prinsip Nehru.

Konferensi ini akhirnya membawa kepada terbentuknya Gerakan Non-Blok pada 1961.

Sumber http://id.wikipedia.org/wiki/Konferensi_Asia-Afrika
dikutip ulang oleh : Hery Purnama , http://freelance-it-trainer.blogspot.com

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Layanan Internet Gratis di Indonesia

Google telah meluncurkan layanan Internet Wifi Gratis di ibukota Jakarta Indonesia , yang memungkinkan pengguna untuk konek menggunakan hotspot Wi-Fi secara gratis atau dengan harga terjangkau. Layanan yang disebut Wi-Fi Pasport, adalah khusus untuk pengguna Android melalui sebuah aplikasi.
"Layanan ini lebih cepat daripada koneksi 3G , dan tidak perlu terus menerus mengisikan password atau mendaftarkan ulang web yang akan diakses," menurut  Google melalui situsnya. Pengguna diizinkan menggunakan hingga 3GB data dalam satu hari, atau 7GB untuk  tujuh hari, dan 10GB untuk  30 hari.

Kode voucher Gratis saat ini memungkinkan digunakan hanya untuk 10 hari pertama . setelahnya dikenakan  biaya 20.000 rupiah selama 20 hari atau 50.000 rupiah ( selama 50 hari , pembelian kode voucher setelah 10hari  hanya bisa dilakukan melalui mitra Google MOGPlay.

Dapatkan akses internet murah di Jakarta via Paspor Wi-Fi Google. Tidak ada kabar tentang apakah layanan akan diperluas di daerah lain (Selain jakarta).

Layanan ini membutuhkan application yang harus diinstall di android Anda, anda bisa mendownloadnya melalui google playstore

Layanan ini juga sebagai bagian dari misi Google untuk mendapatkan "miliar pengguna google baru" yang akan menggunakan layanannya, berbagai inisiatif inisiatif google juga telah  diluncurkan sejauh ini termasuk Free Zone yang memulai debutnya di Filipina, yang memungkinkan akses Web di featurephones gratis selama mereka mengunjungi situs melalui Google Search . Selain itu google juga meluncurkan layanan di India melalui tie-up dengan telco Airtel.

Selain Google, Facebook juga bekerjasama dengan Indosat dengan layanan internet gratis berbatas melalui internet.org , layanan ini hanya bisa dinikmati dengan kartu simcard indosat saja dan dengan cakupan area tertentu dan konten tertentu , terbalik dengan google , layanan ini justru hanya bisa dinikmati user dengan koneksi internet lemah seperti di pedesaan atau lebih spesifik diluar area Jawa

Re-quoted by :
http://freelance-it-trainer.blogspot.com

Hery Purnama 081.223344.506 , IT trainer , Excel / access VBA Macro, MS Project, Primavera,

PHP Ajax Jquery, Google Map API, Google Sketchup3D, Ubuntu, Sencha ExtJS, YII, Code Igniter,
Oracle, SQL Server,
Bandung, Jakarta, Bali, Medan, Surabaya, Yogya, Indonesia

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Excel VBA : How to open Protected VBA Project Password

Open Password Protected VBA Projects

A few days ago, I had to pull out one of my old tricks to hack into a password protected VBA module. The file I was working on was protected by a former (evil) employee who, for some reason, did not leave the VBA password.

.

I'm notoriously lazy, so there is no way I'm retyping code that's already there. I'd rather hack into the workbook.

.

Today, I'll walk you through the steps I use to crack VBA passwords. I learned this trick a while back from one of my Excel Boot Camp students. I can't remember who. Sorry…whoever you are. Even though I can't remember your name, I value our friendship greatly.

.

Step 1: Download a Hex Editor

You'll need a Hex Editor. I use one called XVI32. Why this one? Because it's the one my mysterious friend showed me. I'm not really into Hex Editors, so I couldn't tell you if it's good or bad. I just know it does the trick. Download the XVI32 Hex Editor and have it ready to go.

.

Step 2: Save your Workbook as XLS and MAKE A BACKUP COPY

If you're working with an XLSM file, you'll need to save it as an XLS. Be sure you make a backup of your workbook before you start. Because you're diddling the insides of the workbook, there is always a chance you could royally screw up. You'll want a backup.

.

Step 3: Open Your Workbook in the Hex Editor

Fire up the Hex Editor you downloaded and then (within the editor) select and open your workbook. In the XVI32 editor, my workbook looks like this:

.

Step 4: Find and Replace the DPB Keyword

In your Hex Editor, look for the text string DPB.

.

This text string apparently indicates Excel's tag for the VBA Password.


..

In order to confuse Excel and get around the VBA Password prompt, you just need to muddle the tag a little. You can do this by simply changing the DPB to something like DPX (replace the B with an X).


..

Step 5: Save Your Changes

Close the Hex Editor and be sure to save your changes

.

Step 6: Open your Newly Diddled Workbook

Open the workbook you just finished molesting. You will get a few messages.

First this one, which you will say Yes to:


.

Then you'll see this one (a few times). Don't panic, and keep clicking OK.

.

Step 7: Remove the VBA Protection

When Excel stops its bitching and moaning, go to the Visual Basic Editor (Alt+F11) and then select View>>Project Explorer.

Right click on the VBAProject for your workbook and select VBAProject Properties.

.

In the Properties dialog box, go to the Protection tab and clear any selections and text you see there.

.

Step 8: Save a Close your Newly Unprotected Workbook.

Save and close the workbook. At this point, you'll have full reign over the VBA in the workbook.

.

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Training

Hery Purnama 081.223344.506 , Trainer for Excel VBA Macro, COBIT, ITIL, CISA, PM, MS Project, Sencha ExtJS , Codeigniter please call/sms/WA

Trainer ,Inhouse training di Jakarta, Bandung, Bali, Medan, Semarang, Surabaya, Medan, Palembang, Balikpapan, Samarinda, Makasar, Indonesia

Other topics : Excel VBA Macro, PHP Jquery, Codeigniter, Yii, MS. Project, Primavera, PM, ITIL, COBIT, CISA, Oracle, SQL Server, ASP/VB.net, Android, Google Map API, Sketchup 3D , etc.

15 years experience as Certified ITTrainer – Learn from the expert
Please  visit : http://freelance-it-trainer.blogspot.com

[tags Trainer Sencha Extjs Jakarta, Freelance trainer, ExtJS, Bandung, COBIT, CISA, ITIL, Excel Macro, Hery, Oracle, SQL, Net, Training]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Inhouse Trainer untuk inhouse training perusahaan Anda

Hery 081.223344.506 – Freelance Certified IT inhouse Trainer , Excel VBA Macro , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Primavera, MS Project, Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com/2014/12/freelance-certified-it-trainer-bandung.html

INHOUSE TRAINING

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Sencha ExtJS 5.0 MVVM free Tutorial


Hery Purnama 081.223344.506 , IT trainer , Excel / access VBA Macro, MS Project, Primavera,

PHP Ajax Jquery, Google Map API, Google Sketchup3D, Ubuntu, Sencha ExtJS, YII, Code Igniter,
Oracle, SQL Server,
Bandung, Jakarta, Bali, Medan, Surabaya, Yogya, Indonesia

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Freelance IT Trainer Excel VBA ExtJS WordPress Jquery Android Oracle Jakarta Bandung Kalimantan Sulawesi

Hery 081.223344.506 – Freelance Certified IT Trainer , Excel VBA Macro , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Primavera, MS Project, Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCDBA, MOS , Visit : http://freelance-it-trainer.blogspot.com/2014/12/freelance-certified-it-trainer-bandung.html

Freelance IT Trainer Jakarta, Bandung, Bogor, Bekasi, Karawang , Sukabumi , Cianjur , Medan, Aceh, Palembang, Lampung, Riau, Samarinda, Balikpapan, Pontianak, Banjarmasin, Palangkaraya Makasar, Menado, Palu, Ambon, Sorong, Jayapura, Bali, Lombok, NTT, Yogya, Semarang, Surabaya, Malang, Indonesia

Inhouse Trainer di Pertambangan, Telekomunikasi, Pabrik, Training Center, Retail, Konsultan


Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Training excel vba macro di kpuc samarinda

Terima kasih kepada direksi, manajemen dan semua peserta dari pt. Kayan putra utama coal samarinda – kpuc atas undangan mengajar excel vba macro , semoga bermanfaat,

Regards,

Hery Purnama
Freelance inhouse trainer

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Integrating HTML5, CSS and PHP to Create a Very Basic Contact Form

HTML5 has been helping webmasters to clean up their code by utilising newly introduced features of the same. It won’t be possible for me to touch base with every HTML5 feature, but I will be listing down some of those during the course of this tutorial.

Forms are an integral part of any website that wants its visitors to get in touch with the owner of that website. They bridge the gap virtually between the webmaster and the website visitor.

Here, we will implement a very basic combination of HTML5 with CSS and PHP in order to create a contact form. You might have created a lot of contact forms but our purpose here is to do the same using the appreciable features of HTML5. Let’s do it!

Note: The code below will work with most of the Internet browsers that are being widely used as of today.

Our Goal

For starters, you must have an idea of what we are going to create. It will be a simple contact form as shown below:

Catching up with HTML5

Without further discussions, let’s create our first index.php file. Please be aware that you will require a web server to test index.php file. Explaining the setup of same is out of the scope of this tutorial.

The very initial index.php will look like this:

<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>My Contact Form</title>
</head>
<body>
    <header class="main">
        <h1>My Contact Form</h1>
    </header>
    <section class="main">
        [Form code goes here]
    </section>
</body>
</html>

See any differences from your regular html code?

Well, there are few. Let me explain each of them:

    The cleanest ever DOCTYPE -In case you haven’t noticed, the above HTML5 code boasts of a very clean DOCTYPE tag. If you have worked with earlier versions of HTML5 then you will understand what I mean and why am I emphasizing on it. If you haven’t seen the DOCTYPE tag before then ignore this and move on.
    The <header> and <section> tags – Ever used these tags in earlier versions of HTML? Well, now you can and avoid the usage of div tags. Both the tags have been assigned a class “main” so that I am comfortable styling them as I want using my style.css. HTML5 also has a <footer> tag which will be used (obviously) for footer of your webpage.

The Form:

Now, lets talk about the code that will shape our form (the very purpose of this tutorial). The below code will be placed in our section tag (unless you are planning to push your form to the header or footer section of your webpage.)

<form>
       <label>Your Name:</label>
       <input name="name" placeholder="Goes Here">
       <label>Your Email:</label>
       <input name="email" type="email" placeholder="Goes Here">
       <label>Your Message:</label>
       <textarea name="message" placeholder="Goes Here"></textarea>
       <input id="submit" name="submit" type="submit" value="Submit">
</form>

Again, you will notice differences between the above HTML5 code and our old versions. Let me throw some light:

    <input> tag need not be closed – Older versions of HTML wanted <input/> while HTML5 is satisfied with <input>. Quiet clean, right?
    type = “email” enhances iPhone experience – Although browsers that do not understand type=”email” in above code will assume it to be type=”text” yet iPhone makes your life a bit easier. It adds a @ symbol button in its keypad when the type=”email” field is active. Cute?
    placeholder makes life easy – If you noticed the image of our upcoming form above, then you will see the text “Goes Here” in every field. I remember spending hours with JavaScript so as to make this possible. HTML5 makes this a cakewalk!

Now, our very own CSS

That was it! Our HTML5 tutorial is over and we move on to CSS to style our HTML5 form. For starters, place the below code just above your <body> tag so as to tell your index.php that someone out their is ready to make her beautiful.

<link type="text/css" rel="stylesheet" href="style.css">

Now create a style.css in the same folder and paste the below code into it.

label {
    display:block;
    margin-top:50px;
    letter-spacing:1px;
}

/* This section centers our complete page */
.main {
    display:block;
    margin:0 auto;
    width:500px;
}

/* This section centers the form inside our web page*/
form {
    margin:0 auto;
    width:420px;
}

/* Applying styles to our text boxes */
input, textarea {
    width:400px;
    height:27px;
    background:#666666;
    border:2px solid #f6f6f6;
    padding:10px;
    margin-top:10px;
    font-size:0.7em;
    color:#ffffff;
}

textarea {
    height:200px;
    font-family:Arial;
}

#submit {
    width:85px;
    height:35px;
    background:url(submit.png);
    text-indent:-9999px;
    border:none;
    margin-top:20px;
    cursor:pointer;
}

Let me deconstruct the important parts of above code:

    The display:block property for label converts the <label> tags into block level elements. This pushes them to next line henceforth cleaning up the HTML5 form and pushing every thing to a new line.
    The text-indent:-9999px; property for #submit hides the actual “Submit” text so as to make room for the Submit Button (which I quickly created using Cool Text).
    I am assuming that rest of the code is self explanatory even if you are least familiar with CSS. Leave comments in case of confusions and I will be more than happy to get back to you.

PHP Integration

First, we edit the <form> tag in your code to what you see below:

<form method="post" action="index.php">

Now, insert the below code just above your <form> tag:

    <?php
       $name = $_POST['name'];
       $email = $_POST['email'];
       $message = $_POST['message'];
       $from = 'From: My Contact Form';
       $to = 'salman@mywebsite.com';
       $subject = 'Wassup?';

       $body = "From: $namen E-Mail: $emailn Message:n $message";

       if ($_POST['submit']) {
           if (mail ($to, $subject, $body, $from)) {
           echo '<p>Message Sent Successfully!</p>';
           } else {
           echo '<p>Ah! Try again, please?</p>';
           }
       }
    ?>

Once you save the above changes then your contact form should work as expected. It will send emails to your email address

Hery Purnama 081.223344.506 , IT trainer , Excel / access VBA Macro, MS Project, Primavera,

PHP Ajax Jquery, Google Map API, Google Sketchup3D, Ubuntu, Sencha ExtJS, YII, Code Igniter,
Oracle, SQL Server,
Bandung, Jakarta, Bali, Medan, Surabaya, Yogya, Indonesia

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Connecting PHP CodeIgniter to SQL Server 2008/2012

7 Steps to make SQL Server and Codeigniter Works

Who are tried to connect Codeigniter with SQL Servers knows the suffering and the time invested to achieve this goal (or at least for me). Here is the steps that I follow, I hope that works for you!

  1. Download and execute the Microsoft Drivers 3.0 for PHP for SQL Server (http://www.microsoft.com/en-us/download/details.aspx?id=20098). These is not a installer, just a EXE utility to uncompress the drivers for PHP.
  2. Download and install the SQL Client for SQL Server 2012 (for 64 bits here: http://go.microsoft.com/fwlink/?LinkID=239648, for 32 bits here: http://go.microsoft.com/fwlink/?LinkID=239647)
  3. Verify what is your version of PHP (Thread Safe or Non – Thread Safe). How to do that? Create a new PHP file with the following content:
    1
    2
    <?php
    phpinfo();

    Execute the script and verify the row with the name Thread Safety. If says “enabled” your PHP Installation is Thread Safe (TS), if have other value is Non Thread Safe (NTS).
    thread-safe

  4. Go to the folder where uncompress the Drivers 3.0, and select the version corresponding to. In my case, is PHP 5.4 Thread Safe TS, but this choice varies according to your PHP version.
    select-sqlsrv-version
    Copy these file and put on the folder of the extensions of PHP (generally is in PHP_INSTALLATION_FOLDER/ext)
  5. Modify the php.ini file (generally located in PHP_INSTALLATION_FOLDER), and find the following word: extension=. Here you will find all the extensions enabled by default in PHP, and you only need to add the namefile of the extension you previously put on ext folder.
    configure_php_ini
    Close and save changes, and restart the Apache / PHP service.
  6. Enable the SQL Server to listen on specific ports. Go to the machine where SQL Server is installed, press keys Win + R, and typing the following: SQLServerManager10.msc (this could change, if you have SQL Server 2012 type “SQLServerManager11.msc”). These command open the SQL Configuration Manager. Go to SQL Server Network Configuration option, Protocols for ‘instance name’, and double click on TCP/IP option.

    On the Protocol tab, row Enabled, select yes option, and in IP Address tab go to IPALL option, and in the row TCP Dynamic Ports make it blank and in the row TCP Port inputs whenever port you like (the standard is 1433)

    habilitar-puerto

    Click on Ok, and restart the SQL Server service.

  7. Go to Codeigniter, and in the database.php file do the following:
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    <?php
    /* EXTRACT OF database.php */
    $db['default']['hostname'] = "127.0.0.1"; // or put the IP of your SQL Server Instance
    $db['default']['port'] = 1433; // or the port you configured on step 6
    $db['default']['username'] = 'test2';
    $db['default']['password'] = 'test2';
    $db['default']['database'] = 'contactos';
    $db['default']['dbdriver'] = 'sqlsrv';
    $db['default']['dbprefix'] = '';
    $db['default']['pconnect'] = FALSE; // Pay attention to this, codeigniter makes true for default
    $db['default']['db_debug'] = TRUE;
    $db['default']['cache_on'] = FALSE;
    $db['default']['cachedir'] = '';
    $db['default']['char_set'] = 'utf8';
    $db['default']['dbcollat'] = 'utf8_general_ci';
    $db['default']['swap_pre'] = '';
    $db['default']['autoinit'] = TRUE;
    $db['default']['stricton'] = FALSE;
  8. Congratulations! Now you can make any models and querys, and it should work

Source from : https://futbolsalas15.wordpress.com/2014/02/23/7-steps-to-make-sql-server-and-codeigniter-works/

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT