Fauzia - IT Trainer - Kuala Lumpur, Malaysia

Lily Fauzia

Kuala Lumpur, Malaysia

Services

IT Trainer

Summary:

Train people in IT Application softwares.

Work History

FREELANCE IT TRAINER

INOVASI INSAN ENTERPRISE

February 2009 - November 2012

CORPORATE TRAINER

FUTUREKIDS TECHNOLOGY SOLUTION SDN BHD

June 2006 - January 2009

IT TRAINER

WARISAN TERNAMA SDN BHD

March 2005 - May 2006

IT TEACHER

SEKOLAH SRI INAI

March 2003 - February 2005

IT TUTOR CUM WEB DESIGNER

NORTH WESTERN ALLIANCE (M) SDN BHD

September 2001 - June 2002

Projects

PHP MySQL : Connecting To The Database

Connecting To The Database

The first thing you must do before you can do any work at all is to connect to the MySQL database. This is an extremely important step as, if you are not connected, your commands to the database will fail.

Good practice for using databases is to specify the username, password and database name first so that if you change any of them at a later date you will only have to change one line:

$username="username";
$password="password";
$database="your_database";

At this point you may be wondering if it is a security risk, keeping your password in the file. You don't need to worry, though, because the PHP scource code is processed aby the server before being sent to the browser so it is impossible for the user to see the script's source.

Next, you will need to issue the command to start a database connection:

mysql_connect(localhost,$username,$password);

This line tells PHP to connect to the MySQL database server at 'localhost' (localhost means the server that the site is running one. Unless you web host tells you otherwise you should use localhost. If you are given a server address (such as sql.myserver.com you should replace localhost with "sql.myserver.com" (including the quotes)) using the username stored in $username and the password in $password.

Before I show you how to work with the database, I will show you one more command:

mysql_close();

This is a very important command as it closes the connection to the database server. Your script will still run if you do not include this command but too many open MySQL connections can cause problems for a web host. It is good practice to always include this line once you have issued all your commands to the database, to keep the server running well.

Enhancing Data Analysis Using PivotTable

Grouping Data

In an Excel pivot table, you can group dates, number and text fields. For example, group order dates by year and month, or group test scores in bands of 10. You can manually select text items in a pivot table field, and group the selected items. This lets you quickly see subtotals for a specific set of items in your pivot table.

Freelance IT Trainer

Hi, everybody. As a freelance IT Trainer, I trained people on using word processing, spreadsheet, database, presentation, email, project management, visualized drawing, building a simple website, building database driven website, designing printing materials and many more. I have been in the industry since eight years ago.

Qualifications & Certifications

Adobe Certified Associates Photoshop CS4

Adobe Certified Associates Photoshop CS4

TRAIN THE TRAINER (HRDF certified)

TRAIN THE TRAINER (HRDF certified)

MOS Specialist 2007

MOS Specialist 2007

Master Degree in Education (Internet Computing)

Universiti Pendidikan Sultan Idris

Bachelor Degree in Computer Science (MIS)

University of Malaya

University of Malaya

smk padang tembak

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Lily Fauzia provides the following services:


Supported Countries
Choose your country

×