MySQL Workshop

How to use MySQL to better manage your Database?

MySQL is an open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL) to add, access and manage your database content. As you may already aware, MySQL noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application such as Joomla, WordPress, Moodle, Mahara, Drupal, osCommerce, etc.

At this workshop, you’ll find out how to use mySQL to get a head start on managing your online databases.

PHP/mySQL Tutorial includes:-

  1. Introduction to PHP
  2. Introduction to mySQL and it’s benefits
  3. Learn how to create mySQL database and user
  4. Learn how to remove existing mySQL database and user from your hosting account
  5. Learn how to manage mySQL databases with phpMyAdmin or through Remote Connection
  6. Learn how to connect PHP scripts with mySQL data
  7. learn how to use PHP/mySQL script on your website
  8. Learn how to execute SQL commands on the server
  9. Learn how to perform Database Backup and Restore
  10. Learn how to perform mySQL basic operations: –
  • create a database and add tables – manual and scripting
  • Connect to the database
  • Querying the database
  • Displaying table data in HTML
  • Selecting individual records

Add-on (for Database Administrator):

  • How to install mySQL on Windows Server (step-by-step)?

    Workshop Details

    Type: Tailored and one-to-one training
    Duration: Minimum 4 hours
    Level : All levels

    Tuition:

    1. £50/MYR 250 (online via eLearning portal and web conferencing)
    2. £100/MYR 500 (face-to-face)

    Available Dates: on going


    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: