Unlock your potential with a Pro Membership
Here is where you propel your career forward. Come join us today. Learn more.
The Big Picture
Lab: Introduction to Databases
Video Runtime: 14:35
In this episode, you will be introduced to databases and SQL. You’ll use either phpMyAdmin or Sequel Pro to explore the actual WordPress database tables. You’ll learn about:
- What a relational database is
- Columns
- Rows and records
- Schema
- Primary keys
- and more
Keep It Simple, Stupid (KISS) - the best kiss you'll get in code.
Episodes
Total Lab Runtime: 02:08:59
- 1 Lab Introductionfree 05:17
- 2 The Big Picturepro 14:35
- 3 Your First SQL Querypro 12:21
- 4 WordPress to Database Relationshippro 20:20
- 5 Filter Content with WHEREpro 08:24
- 6 Table Alias with ASpro 05:08
- 7 Defining Table Structure (Schema)pro 12:17
- 8 Create a New Database Tablepro 10:23
- 9 WordPress Schemapro 05:11
- 10 Exploring WordPress Queries with Query Monitorpro 07:14
- 11 SQL to Get a Custom Fieldpro 16:41
- 12 SQL to Update Custom Fieldpro 05:14
- 13 Wrap it Upfree 05:54