AWS Databases

Database Options in AWS

Exercise: Create a Database

Task: Create and connect to an RDS database.

1. Go to RDS and click "Create database"
2. Choose MySQL or PostgreSQL
3. Select Free Tier template
4. Set master username and password
5. Create the database (takes 5-10 minutes)
6. Note the endpoint URL
7. Connect using MySQL Workbench or a Lambda function
8. Create a table and insert data

# Python Lambda function to connect to RDS
import pymysql
import json

def lambda_handler(event, context):
    connection = pymysql.connect(
        host='your-database-endpoint',
        user='your-username',
        password='your-password',
        database='your-database'
    )
    
    cursor = connection.cursor()
    cursor.execute("CREATE TABLE IF NOT EXISTS users (id INT, name VARCHAR(100))")
    cursor.execute("INSERT INTO users VALUES (1, 'John Doe')")
    connection.commit()
    
    return {
        'statusCode': 200,
        'body': json.dumps('Database created and data inserted!')
    }