Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

PhpMyAdmin Essential Training

This phpmyadmin course will show designers and developers how to create a database, design tables, and insert, update, and delete data either on a local computer or a remote server. Plus, you'll learn how to use phpMyAdmin to export data to a text file that can be used as a backup or to transfer the data to another server. You'll also learn how to run database queries within its intuitive form-based interface, and monitor server performance.

Topics include:

  • What is phpMyAdmin?
  • Setting up a user account
  • Choosing the right column types for tables
  • Inserting data manually
  • Updating and deleting data
  • Importing and exporting data
  • Dealing with foreign keys
  • Building queries
  • Using Advisor to tune server performance
Course Code: CRS-N-0033897

Course Booking

$298.00

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

Module 1. Why Use phpMyAdmin?

  • What phpMyAdmin does 
  • Limitations of phpMyAdmin in hosted environments

Module 2. Setting Up phpMyAdmin Locally

  • Creating a database 
  • Setting up a user account

Module 3. Creating Tables

  • Choosing the right column types 
  • Defining a table
  • Amending the table structure
  • Inserting data manually 
  • Updating and deleting data

Module 4. Importing and Exporting Data

  • Importing data from a CSV file
  • Importing data from a .sql file
  • Exporting a database the quick way
  • Creating a custom export 
  • Exporting partial data

Moidule 5. Dealing with Foreign Keys

  • Understanding foreign key constraints 
  • Converting from MyISAM to InnoDB 
  • Setting up a foreign key constraint 
  • Removing a foreign key constraint

Module 6. Running Queries

  • Performing a simple search 
  • Building a simple query by example on an individual table 
  • Using a query by example to set multiple conditions in a WHERE clause 
  • Building a query by example on multiple tables 
  • Building queries manually on a single table 
  • Building a query manually on multiple tables 
  • Saving frequently used queries with bookmarks 
  • Using a variable with a bookmarked query

Module 7. Checking Performance

  • Inspecting server performance 
  • Using Advisor to tune performance

Who Should Attend

  • Web administrator that want to to acquire the basic knowledge of phpmyadmin
  • Website owners who use phpmyadmin to manage the mysql

Prerequisite

Prerequisite

This is a beginner course. No prior knowledge on database is required

Software Requirement

Trainers

PhpmyAdmin TrainerTruman Ng graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project.

Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States.

Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philipines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.
As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.
Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc.

PhpmyAdmin TrainerDzung used to be a technical geek in the university with the solely hobby in full-time coding. A hungry learner who liked analysing the programming language theories and turned those into practices to make the real application that can help solve the society problems. His passion nowadays lies in bringing the innovation and passing his passion to adults of next generation with the aim of empowering today’s technology to enable them to become inventors of tomorrow’s reality.

PhpmyAdmin Trainer in Tertiary CoursesDr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 1997 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

PhpmyAdmin TrainerShu Wei has 14 years experience working in the semiconductor industry holding different roles in IC Design, layout verification and mask data preparation. He has a keen interest in scripting and has extensive knowledge in PERL, PHP, MySQL among others. Aptly applied to his area of work, he had simplified many work methodologies leading to much productivity and quality improvements for his various undertakings.

Shu Wei holds a Master of Science (Electrical Engineering) from National University of Singapore. He is also a PMP certified project manager and a Six Sigma Black Belt practitioner.

PhpmyAdmin TrainerAriff is a recent Graduate from Murdoch University in BSc in Business Information System and Management (Double Major). He is a MOE Registered Instructor teaching in most of the Information Technology and Multimedia aspects such as Web programmer, Mobile App Developer, Video director and editor, and game development and design (PC and Mobile). Besides Information Technology and Multimedia, he is also giving entrepreneurship, leadership workshops and motivation speech training.

He has a strong passion in IT and gaming design been since 2005. He is currently doing games design for his own project and continues to teach and share his knoweledge. He still hungers for new skills to keep himself up to date as technology continues to change.

Customer Reviews (1)

Will RecommendReview by Charmaine
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The resolution on the certificate can be improve (Posted on 3/5/2018)

Write Your Own Review

You're reviewing: PhpMyAdmin Essential Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Other people marked this product with these Subjects:

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses