Databases are an important part of all websites as it allows you to store all types of data. PHP and MySQL are basic skills every web developer needs to know. This course teaches you the basics of SQL, how to use the very popular PHPMyAdmin to manage your databases, as well as using MySQL with PHP.

  • Prereqs: Beginners HTML, CSS and PHP
  • Estimated Class Time: 4-5 hours
  • Number of Lessons: 13
  • Quiz Questions: 8 multiple choice, 11 code challenges, and 1 chapter review

Course Outline:

Chapter 1: Introduction to MySQL

  • MySQL Introduction

Chapter 2: Basic PHPMyAdmin

  • PHPMyAdmin and Basic MySQL: Part 1
  • PHPMyAdmin and Basic MySQL: Part 2

Chapter 3: Database Basics

  • SQL: The Language of Databases
  • The Insert Statement
  • The Update Statement
  • The Delete Statement
  • The Select Statement

Chapter 4: MySQL and PHP

  • Connecting to MySQL with PHP: Part 1
  • Connecting to MySQL with PHP: Part 2
  • Connecting to MySQL with PHP: Part 3
  • Connecting to MySQL with PHP: Part 4
  • SQL Select Statements with PHP: Part 1
  • SQL Select Statements with PHP: Part 2

Chapter 5: Conclusion

  • Conclusion
To Top