In code, you use conditional expressions to make decisions and determine which tasks to run. SQL gives you this same ability. You use the keyword WHERE like you would when using an if in PHP. Let’s talk about how you filter to grab the content you want.
This episode is very important. Make sure you get it! Let’s explore the relationship between WordPress and its database. You’ll look at where the content comes from in the database that populates the back-end interface for a post. You’ll explore each of the columns in wp_posts, fields in the wp_postmeta, featured thumbnail image and where it resides, and the author (which relates to the wp_users and wp_usermeta tables. You’ll learn about the glue that binds pieces of information together, such as post metadata and how these are glued to the associated record in the posts database table. The primary database […]
Let’s query the posts database table by writing some SQL within your favorite GUI, i.e. phpMyAdmin or Sequel Pro. We’ll walk through the SQL commands and how to grab information that is conditional upon some value. Your query will be: Then you’ll adapt the query to grab more information.
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
Let’s talk about what a database is, what one WordPress uses, and what this lab will do for you.
This hands-on lab teaches you more advanced SQL including table relationship types, how to join multiple tables together, and how to write SQL queries that are faster and more scalable for your WordPress projects. You will use a practical example plugin to test two different approaches to solving the problem of fetching posts that are grouped by each term. You’ll test these approaches, explore the actual SQL queries, and learn about the impact of processing speed, performance, and scalability.
Dynamic content requires a storage system to retain the content, settings, and information. WordPress uses MySQL as its relational database. In this hands-on lab, you will dig into the WordPress database structure, do basic raw SQL queries, and learn about the relationship between WordPress and its database.
Have you ever opened up your database? Have you poked around in there to understand the layout and different buckets of content and information? In today’s quick tip, you’ll look at the wp_posts database table. You’ll learn about basic database terminology, such as record, row, primary key, and columns. You’ll see how the columns within a record relate to the content you see in the WordPress back-end.
In this episode, you will learn about what a “post type” is within WordPress. You’ll look in the wp_posts database table to see the column named post_type. You’ll see how this column relates to the buckets of content.