Course Duration: 1 day
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.
Course Highlights
– 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
Pre-requisite
This is a beginner course. No prior knowledge on database is required
Target Audience
– Web administrator that want to to acquire the basic knowledge of phpmyadmin
– Website owners who use phpmyadmin to manage the mysql
Course Outline
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
Module 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
