phpMyAdmin Fundamentals
phpMyAdmin is a free and open source tool for the administration of MySQL.
What you'll learn
phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.
Table of contents
- Introduction 1m
- Prerequisite Software 1m
- Prerequisite Software for This Course 1m
- Demo Setup 1m
- Demo: Installing Apache Server 1m
- Demo: Installing PHP Server 1m
- Demo: Installing MySQL Server 2m
- Demo: Installing phpMyAdmin 2m
- Demo: Getting Started With phpMyAdmin 2m
- Demo: Removing Warnings and Error From phpMyAdmin 4m
- Summary 1m
- Introduction 1m
- Scenario Setup 2m
- Scenario 1: Reports 1m
- Demo 1: Reports 4m
- Scenario 2: Variables 1m
- Demo: Variables 2m
- Scenario 3: Monitor 1m
- Demo 3: Monitor 2m
- Scenario 4: Database Operations 1m
- Demo 4: Database Operations 1m
- Scenario 5: Create User 1m
- Demo 5: Create User 2m
- Scenario 6: Export and Import 1m
- Demo 6: Export and Import 3m
- Summary 1m
- Introduction 1m
- Scenario Setup 2m
- Scenario 1: Browse and Edit 1m
- Demo: Delete Rows 5m
- Demo: Edit Rows 3m
- Demo: Profiling Query and Print Table 3m
- Scenario 2: Data Structure 1m
- Demo: Change Data Structure 5m
- Scenario 3: Create, Read, Update, and Delete 1m
- Demo: Execute SQL Scripts 2m
- Scenario 4: Advanced Search 1m
- Demo: Advanced Search and Replace 4m
- Scenario 5: Table Maintenance 1m
- Demo: Table Maintenance 4m
- Scenario 6: Table Options 1m
- Demo: Table Options 2m
- Scenario 7: Export and Import 1m
- Demo: Export Table in Excel Format 1m
- Scenario 8: Tracking 1m
- Demo: Tracking 3m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.