PHP + MySQL – Lesson 13: DB Intro

Introduction To MySQL Databases and phpMyAdmin

MySQL Structure and Queries

In the following slideshow you will learn the basics of how MySQL database structure works. It covers how databases are normalized through the use of relational tables, and it addresses how you can write basic queries. You can also download a pdf version of this slideshow here.



Additionally, you can also watch a video that explains how you can work with phpMyAdmin to manipulate the database from the slideshow above. To follow along, you can download both the “membership.sql” tables used in the slideshow above, as well as a pdf page of common MySQL query commands to work with. If you download the sql file, you will need to import it into an existing database on your localhost or other hosted server.