Database-driven content creation in SEO Fundamentals - Mini Project: Build & Apply

Database-driven content creation

📖 Scenario: You are managing a website that shows product information. Instead of writing each product page by hand, you want to use a database to store product details and then create pages automatically from that data.

🎯 Goal: Build a simple example of database-driven content creation by setting up product data, configuring a filter, selecting products based on that filter, and completing the content structure for display.

📋 What You'll Learn

Create a dictionary called products with exact product names and prices

Add a variable called max_price to set a price limit

Use a dictionary comprehension called affordable_products to select products priced below max_price

Complete the content by adding a content_title string describing the filtered products

💡 Why This Matters

🌍 Real World

Websites often use databases to store product or article information and generate pages automatically based on user preferences or filters.

💼 Career

Understanding how to filter and generate content from data is essential for roles in web development, content management, and SEO optimization.

1

DATA SETUP: Create the product data dictionary

Create a dictionary called products with these exact entries: 'Laptop': 1200, 'Smartphone': 800, 'Tablet': 400, 'Headphones': 150, and 'Smartwatch': 200.

SEO Fundamentals

# Create the products dictionary with exact entries
# Your code here

Need a hint?

Use curly braces {} to create a dictionary with keys as product names and values as prices.

2

CONFIGURATION: Set the maximum price filter

Add a variable called max_price and set it to 500 to filter products by price.

SEO Fundamentals

products = {
    'Laptop': 1200,
    'Smartphone': 800,
    'Tablet': 400,
    'Headphones': 150,
    'Smartwatch': 200
}
# Set max_price to 500
# Your code here

Need a hint?

Just assign the number 500 to the variable max_price.

3

CORE LOGIC: Select affordable products using dictionary comprehension

Create a dictionary comprehension called affordable_products that includes only products from products with prices less than max_price.

SEO Fundamentals

products = {
    'Laptop': 1200,
    'Smartphone': 800,
    'Tablet': 400,
    'Headphones': 150,
    'Smartwatch': 200
}
max_price = 500
# Create affordable_products dictionary comprehension
# Your code here

Need a hint?

Use {key: value for key, value in dict.items() if condition} to filter the dictionary.

4

COMPLETION: Add a content title describing the filtered products

Add a string variable called content_title with the exact value 'Products under $500' to complete the content structure.

SEO Fundamentals

products = {
    'Laptop': 1200,
    'Smartphone': 800,
    'Tablet': 400,
    'Headphones': 150,
    'Smartwatch': 200
}
max_price = 500
affordable_products = {product: price for product, price in products.items() if price < max_price}
# Add content_title string
# Your code here

Need a hint?

Assign the exact string to content_title to describe the filtered list.