Back to Catalog

Create Tables and Load Data in MySQL using phpMyAdmin

BeginnerGuided Project

In this project, you will learn how to create tables and load data in the MySQL database service using the phpMyAdmin graphical user interface (GUI) tool.

4.5 (133 Reviews)

Language

  • English

Topic

  • Computer Science & Information Technology

Enrollment Count

  • 2.39K

Offered By

  • IBM

Estimated Effort

  • 1 Hour

Platform

  • SkillsNetwork

Last Update

  • June 3, 2025
About this Guided Project

About This Guided Project

In this project, you will learn how to create tables and load data in the MySQL database service using the phpMyAdmin graphical user interface (GUI) tool.


Objectives

After completing this project, you will be able to use phpMyAdmin with MySQL to:
  • Create a database, 
  • Create tables
  • Load data into tables manually using the phpMyAdmin GUI
  • Load data into tables using a text/script file.

Requirements

To complete this project you will need the MySQL relational database service which will be available as part of the IBM Skills Network Labs (SN Labs) Cloud IDE. SN Labs is a virtual lab environment used in this project.


Frequently Asked Questions

Do I need to install any software to participate in this project?


Everything you need to complete this project will be provided to you via the Skills Network Labs and it will all be available via a standard web browser.



What web browser should I use?


The Skills Network Labs platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Instructors

David Pasternak

Skills Network Data Scientist Intern

As early as I could remember, I was obsessed with figuring out how things work. Unfortunately for my parents, this often meant taking things apart to see what was inside and not being able to put it back together again, or putting copper wires into electrical outlets to see what would happen (to spare you from trying it yourself, it turns out the result is very bright and loud). This sometimes dangerous curiosity would eventually turn into a passion for physics which I would go on to study at the University of Toronto. I loved the process of gathering data, analyzing it, looking for patterns, and coming to a conclusion. I soon discovered that much of the procedures used to understand our physical universe follow a similar pattern in other aspects and domains of our world. This led me into the path of data science, where we could leverage our curiosity, analytical skillset, and love of discovery to come up with solutions to real world problems. I was hooked and I knew this joy of discovery is best shared. This put me on a mission to make the wonders of data science available to anyone and everyone who wished to learn it, thankfully made all the more accessible with the meteoric rise of online learning.

Read more

Kathy An

Skills Network Data Scientist Intern

Skills Network Data Scientist Intern

Read more