Bahan-bahan material kuliah S2

Bahan material kuliah Binus S2 - Kelas 01MAM

1. Services Oriented Enterprise
SOA In Action

2. Business Strategic Development
BSD Slide

3. Managing Corporate Information System and Technology

4. Financial Management

Bahan material kuliah Binus S2 - Kelas 02MAM

1. M7103_Quality Assurance and Management

2. M7063_Project and Change Management
pertemuan 20091124 :
pertemuan 20091201 :

3. M7173_IS Research Methodology
pertemuan 20091202

4. M7083_IS Risk Management

5. Thesis Information
presentation 19.Dec.2009 – room 311

6. Seminar Information

=================================================’.: Semua Indah pada Waktu – Nya :.

1. 03_Corporate IT Strategy – 03MAM
Pertemuan ke-01
Pertemuan ke-02
Pertemuan ke-03
Pertemuan ke-04
Pertemuan ke-05
Pertemuan ke-06
Pertemuan ke-07
Pertemuan ke-08
Pertemuan ke-09
Pertemuan ke-10
Pertemuan ke-11
Pertemuan ke-12

2. 04_Strategic Knowledge Management – 03MBM
Pertemuan ke-01 s/d 09

3. 05_Internet Business Strategy and Management – 03MAM
Pertemuan ke-03
Pertemuan ke-04

Handphone Transparan Pertama

Vendor LG mengeluarkan handphone pertama yang bernuasakan transparan, menurut saya itu hal yang baru yang akan menjadi trend di masa depan.

 

Mau tahu spesifikasinya, ya kesini saja :
Link Spec01  
Link Spec02

How to use MonYog for MYSQL

To analysis your database, you can use MonYog application.

Go to this application:


This application will display several information:
Disk information – will display file capacity that already use for database

Process graphic, connection, cache hit and statement that use:

and it also handle monitor/advisor:

it handle statement also – with graphic support.

hope this tool can improve your skill on MySql.

How to use SQLYog for MySQL

When i ask to my friend – Fendy, is there anyway to execute SQL syntax on MySQL.

MySQL without command console (dos), and he answered “you can use SqlFront or SqlYog”, so i prefer SqlYog to to this:

ps: I use SQLYog Enterprise version 7.14 and MySQL 5.0.77
this application will help you to use MySQL GUI more friendly

Go to SqlYog application


And the application will show like this
 

use can write your sql syntax on right template, and result will appear on the bottom template


when you want to know the history of your sql syntax, you can use function history – like sql profiler:
 
when i want to create sp, i can do it, it because i use mysql version 4.12, to create sp or function you must install MySql database >= 5 ( MySQL version)

this is example to create sp:
 

and to call sp:


when i try to alter sp, on SqlYog, it will generate script to drop and create that sp again, the basic flow to alter sp.

The important point is to backup your database, where you can save data and structure on current database:

to Restore database, you only click Restore from SQL Dump and choose your backup file.

ok, have a nice Sql Script on MySql.

How to use MYSQL Database – command prompt

Today i want to test MySQL database

I use mysql-4.1.22-win32, setup and after install it,  i go to 
 

and it will display this window (need password) if you use it setting :
 
default window will appear like this:
 
after that we learn about command syntax on mysql

to know mysql version we can use this syntax:
mysql> select version();



to display database that exist:
mysql> show databases;


to create new database:
mysql> create database practise01;


to change to database that you want to choose:
mysql> use practise01;


to create new table:
mysql> create table tblTest01(id int);


to show table structures:
mysql> describe tbltest01;
or
mysql> show columns from tbltest01;


to show tables that exist:
mysql> show tables;


to alter table structure:
mysql> alter table tbltest01 add nama varchar(20);

to fill your data table:
mysql> insert into tbltest01(id,nama) values(1,"jimon");
point : insert into tablenm(col1,col2,…) values(datacol1,datacol2,…)
 

to display data from current table:
mysql> select * from tbltest01;
 

to update data from current table:
mysql> update tbltest01 set id=3,nama="cyntia" where nama="cintia";

to close window mysql command prompt:
mysql> exit;

ok have a nice try, hope this will help you to know mysql better.