Save for later
Learning phpMyAdmin
Heads up! This course may be archived and/or unavailable.
MySQL is one of the most widely used database systems for dynamic websites and content management systems. And phpMyAdmin is the most common method of administering a MySQL database, included in many CMSs as well as the XAMPP and MAMP testing environments.Updated for phpMyAdmin 4.5, this introductory course shows designers and developers how to set up local user accounts, create a database, and design tables. Author David Powers also explains how to import data from CSV files, spreadsheets, and SQL dump files, and how to export data for backup or to transfer to another database. You'll also learn how to run database queries within its intuitive form-based interface, and monitor server performance. Topics include:
- Why use phpMyAdmin?
- Setting up a user account
- Creating a database
- Choosing the right column types for tables
- Inserting data manually
- Importing and exporting data
- Dealing with foreign keys
- Building and running queries
- Creating views
- Creating stored procedures and functions
- Checking performance
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 5h 26m |
Starts | On Demand (Start anytime) |
Cost | $0/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | David Powers |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming Data Science |
Tags | Developer Web PHP Databases Web Development MySQL phpMyAdmin |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Associate New and Used Car Sales $20k
used car dealer $40k
New/Used Equipment Sales and Leasing $43k
Used Equipment Sales Rep $51k
Used Parts Sales $53k
New and Used Truck Sales Representative $60k
New and Used Truck Sales Rep $62k
used jet sales $71k
Regional used jet sales $90k
National Manager, Used Vehicle Marketing $101k
Regional used jet sales Manager $129k
Regional New & Used Truck Sales Manager $136k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 5h 26m |
Starts | On Demand (Start anytime) |
Cost | $0/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | David Powers |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming Data Science |
Tags | Developer Web PHP Databases Web Development MySQL phpMyAdmin |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course