Reader small image

You're reading from  AWS Certified Database – Specialty (DBS-C01) Certification Guide

Product typeBook
Published inMay 2022
PublisherPackt
ISBN-139781803243108
Edition1st Edition
Right arrow
Author (1)
Kate Gawron
Kate Gawron
author image
Kate Gawron

Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
Read more about Kate Gawron

Right arrow

Working with DynamoDB records

DynamoDB uses an application programming interface (API) to control how you access it. We've used the AWS API before in previous chapters to create and work with other databases, but unlike an RDS instance, you can also use the API to run queries and to create and modify data within a DynamoDB table.

DynamoDB has seven main API methods for data manipulation and retrieval:

  • PutItem
  • GetItem
  • UpdateItem
  • DeleteItem
  • ExecuteStatement
  • Query
  • Scan

PutItem

The PutItem API allows you to load records into the database. You can use the following syntax:

aws dynamodb put-item \
    --table-name GameScores \
    --item '{
      "PlayerID": {"S": "KateG"}
    }' \

The first line tells DynamoDB what action you will be taking: put-item. The next line identifies the table you will be writing...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
AWS Certified Database – Specialty (DBS-C01) Certification Guide
Published in: May 2022Publisher: PacktISBN-13: 9781803243108

Author (1)

author image
Kate Gawron

Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
Read more about Kate Gawron