MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Up and Running with phpMyAdmin

Course Summary

Learn to administer MySQL databases, design tables, and insert, update, and delete data with phpMyAdmin.       


  • +

    Course Syllabus

    Introduction
       Welcome
       What you should know before watching this course
       Using the exercise files
       Configuring phpMyAdmin on MAMP for OS X
    1. Why Use phpMyAdmin?
       MySQL isn't a database, but a database management system
       What phpMyAdmin does
       Limitations of phpMyAdmin in hosted environments
    2. Setting Up phpMyAdmin Locally
       Creating a database
       Setting up a user account
    3. Creating Tables
       Choosing the right column types
       Defining a table
       Amending the table structure
       Inserting data manually
       Updating and deleting data
    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
    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
    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
    7. Checking Performance
       Inspecting server performance
       Using Advisor to tune performance
    Conclusion
       Goodbye
     


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

3 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top