MultiCloud Classroom notes 30/Sep/2026

Aurora DSQL

• Serverless distributed SQL managed by aws
• it will supourt single and multi region
• update and mainatance will be managed by aws
• we can query directly from console

Amazon Document DB

• it will open source of mogodb
• it will suppourt for document data and json. Bson files

create database school

use school

db.school.insetone({id:22, name:deva, class: 2nd location: hyd})
db.school.insetMany([
{id:22, name:deva, class: 2nd location: hyd},
{id:23, name:kirshna, class: 10th location: hyd},
{id:25, name:deva, class: 5th location: hyd}
])

dynamodb

aws dynamodb create-table \
    --table-name Music \
    --attribute-definitions \
        AttributeName=Artist,AttributeType=S \
        AttributeName=SongTitle,AttributeType=S \
    --key-schema \
        AttributeName=Artist,KeyType=HASH \
        AttributeName=SongTitle,KeyType=RANGE \
    --billing-mode PAY_PER_REQUEST


aws dynamodb describe-table --table-name Music --query "Table.TableStatus"

aws dynamodb put-item \
    --table-name Music \
    --item '{
        "Artist": {"S": "No One You Know"},
        "SongTitle": {"S": "Call Me Today"},
        "AlbumTitle": {"S": "Somewhat Famous"}
    }'

# Insert Sample Item 2
aws dynamodb put-item \
    --table-name Music \
    --item '{
        "Artist": {"S": "Acme Band"},
        "SongTitle": {"S": "Happy Day"},
        "AlbumTitle": {"S": "Songs About Life"}
    }'

## option B 

aws dynamodb batch-write-item --request-items file://sample-data.json

{
    "Music": [
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S": "No One You Know"},
                    "SongTitle": {"S": "My Footsteps"},
                    "AlbumTitle": {"S": "Blue Sky"}
                }
            }
        },
        {
            "PutRequest": {
                "Item": {
                    "Artist": {"S": "Acme Band"},
                    "SongTitle": {"S": "Look Out"},
                    "AlbumTitle": {"S": "The Collection"}
                }
            }
        }
    ]
}

verify data

aws dynamodb scan --table-name Music