EncartaLabs

PhpMyAdmin

( Duration: 2 Days )

This PhpMyAdmin training 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.

  • Web Administrators
  • Website Owners

COURSE AGENDA

1

Introduction

  • 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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top