Two-Day MySql Course

You will learn in this two-day course:

Day 1

• Download and install MySQL
• Start and run MySQL server
• Building Database and tables
• Retrieving Information from a Database
• Using Select statement
• The LIKE statement and wildcard patterns
• Use the WHERE clause to specify a criteria for the selection
• Use AND and OR to join two or more conditions in a WHERE clause.
• Use BETWEEN....AND to find data in a range.
• use the DISTINCT keyword to return only different values in a column.
• Use ORDER BY to return rows in ascending or descending order.
• Using the INSERT statement to insert new rows into a table
• Using the UPDATE statement to update or change rows in a table.
• Using the built-in COUNT function
• Using other SQL built-in functions
• Use the GROUP BY function
• Using the HAVING statement
• Use aliases for column names and table names
• Delete records using SQL
• Using join, inner join, left join and right join statements
• Use the ALTER TABLE, CREATE TABLE & DROP TABLE statements
• Create Tables with Table constraints
• Getting information from more than one table
• Compound Conditions
• Logical Operators
• Aggregate Operators
• Fields manipulation
• Using Unions
• The IN Operator

Day 2

• Understand PHP
• Advantages of PHP
• Using variables and comments
• Single quoted string
• Double-quoted String
• String functions
• Arithmetic Operators
• Assignment Operator
• Comparison Operators
• IF Statements
• WHILE Loop
• For loop
• Defining Constants
• Using prefined constants
• Arrays and Associative Array
• Array Functions and Predefined Constants
• Using foreach
• CGI (Common Gateway Interface) and PHP Predefined variables
• CGI ENVIRONMENT VARIABLES
• Form Data Processing
• Forms and action pages
• Using date and time functions
• Using heredoc syntax
• String manipulation
• Using str_replace, strstr
• Using HTTP_USER_AGENT, HTTP_POST VARS and HTTP_GET_VARS
• Find out about your user's browser, domain name, IP address, port number etc
• Obtain information form your users
• Define and use your own functions
• Function with input parameters
• Php built-in functions
• Accessing MYSQL Databases from PHP pages
• Select records from a MySQL Database from a PHP page
• Insert records in a MySQL database from a PHP page
• Update records of a MySQL database from a PHP page
• Edit data of your MySQL database from a PHP page
• Obtain information from your users
• Migrate Access databases to MySQL
• Create new user login names and passwords in MySQL

Date: Monday 10 April and Tuesday 11 April 2006

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk