Why CRUD operations are foundational in DynamoDB - Quick Recap

Recall & Review

beginner

What does CRUD stand for in database operations?

CRUD stands for Create, Read, Update, and Delete. These are the four basic actions you can perform on data in a database.

beginner

Why are CRUD operations considered foundational in databases?

Because they cover all the essential ways to manage data: adding new data, retrieving existing data, changing data, and removing data. Without these, you can't effectively use a database.

intermediate

How does the 'Create' operation work in DynamoDB?

In DynamoDB, 'Create' means adding a new item to a table using the PutItem or BatchWriteItem API. This inserts data that did not exist before.

beginner

What is the importance of the 'Read' operation in CRUD?

Reading data lets you retrieve and view information stored in the database. It is essential for displaying data to users or processing it in applications.

intermediate

How do 'Update' and 'Delete' operations help maintain data quality?

Update lets you fix or change existing data to keep it accurate. Delete removes data that is no longer needed, helping keep the database clean and efficient.

Which CRUD operation would you use to add a new record to a DynamoDB table?

A Read

B Create

C Update

D Delete

Create is used to add new data to the database.

What does the 'Read' operation do in CRUD?

A Retrieves data

B Changes data

C Deletes data

D Adds new data

Read retrieves or views existing data from the database.

Why is the 'Update' operation important?

A To change existing data

B To remove data

C To add new data

D To read data

Update changes existing data to keep it accurate.

Which CRUD operation helps keep the database clean by removing unnecessary data?

A Create

B Update

C Delete

D Read

Delete removes data that is no longer needed.

What is the main reason CRUD operations are foundational?

A They backup data automatically

B They improve database speed

C They secure the database

D They allow you to manage data fully

CRUD operations let you create, read, update, and delete data, covering all basic data management needs.

Explain why CRUD operations are essential for working with databases like DynamoDB.

Think about what you need to do with data in everyday apps.

Describe how each CRUD operation helps maintain data quality and usefulness.

Consider how data changes over time.

Practice

1. What does the CRUD acronym stand for in database operations?

easy

A. Calculate, Remove, Upload, Download

B. Create, Read, Update, Delete

C. Copy, Run, Undo, Drop

D. Connect, Retrieve, Use, Delete

Solution

1. Step 1: Understand each letter in CRUD

   CRUD stands for the four basic operations to manage data: Create, Read, Update, and Delete.

2. Step 2: Match the correct full form

   Among the options, only Create, Read, Update, Delete correctly lists these four operations.

3. Final Answer:

   Create, Read, Update, Delete -> Option B

4. Quick Check:

   CRUD = Create, Read, Update, Delete [OK]

Hint: Remember CRUD as the four main data actions [OK]

Common Mistakes:

• Confusing CRUD with unrelated terms
• Mixing up the order of operations
• Thinking CRUD includes 'Copy' or 'Calculate'

2. Which of the following is the correct syntax to add a new item in DynamoDB using the AWS SDK?

easy

A. dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } })

B. dynamodb.getItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

C. dynamodb.deleteItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

D. dynamodb.updateItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

Solution

1. Step 1: Identify the operation to add a new item

   Adding a new item uses the putItem method in DynamoDB.

2. Step 2: Match the correct syntax

   dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } }) uses putItem with the correct parameters to add an item.

3. Final Answer:

   dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } }) -> Option A

4. Quick Check:

   Adding item = putItem [OK]

Hint: Use putItem to create new data in DynamoDB [OK]

Common Mistakes:

• Using getItem or deleteItem to add data
• Confusing Key with Item in parameters
• Missing TableName or Item fields

3. Given the following DynamoDB operation, what will be the result?

const params = { TableName: 'Books', Key: { 'ISBN': { S: '978-1234567890' } } };
const data = await dynamodb.getItem(params).promise();
console.log(data.Item);

medium

A. It will cause a syntax error

B. It will delete the item with ISBN '978-1234567890'

C. It will update the item with ISBN '978-1234567890'

D. It will print the item with ISBN '978-1234567890' if it exists

Solution

1. Step 1: Understand the getItem operation

   The getItem method retrieves an item by its key from the table.

2. Step 2: Analyze the code output

   The code logs data.Item, which will be the item with the given ISBN if it exists, or undefined if not.

3. Final Answer:

   It will print the item with ISBN '978-1234567890' if it exists -> Option D

4. Quick Check:

   getItem returns item data [OK]

Hint: getItem fetches data; console.log prints it [OK]

Common Mistakes:

• Thinking getItem deletes or updates data
• Assuming syntax error due to async/await
• Confusing Key with Item in parameters

4. You wrote this DynamoDB update code but it throws an error:

const params = {
  TableName: 'Users',
  Key: { 'UserId': { S: 'abc123' } },
  UpdateExpression: 'set Age = :age',
  ExpressionAttributeValues: { ':age': 30 }
};
await dynamodb.updateItem(params).promise();

What is the likely cause of the error?

medium

A. ExpressionAttributeValues must use DynamoDB types like { ':age': { N: '30' } }

B. UpdateExpression should be 'update Age = :age'

C. Key should be inside Item property

D. TableName is missing

Solution

1. Step 1: Check ExpressionAttributeValues format

   DynamoDB expects attribute values to be typed, e.g., numbers as { N: '30' }.

2. Step 2: Identify the error cause

   The code uses a plain number 30 instead of the typed format, causing a validation error.

3. Final Answer:

   ExpressionAttributeValues must use DynamoDB types like { ':age': { N: '30' } } -> Option A

4. Quick Check:

   Use typed values in ExpressionAttributeValues [OK]

Hint: Always wrap values with DynamoDB types in updates [OK]

Common Mistakes:

• Using raw JS values instead of typed DynamoDB values
• Wrong UpdateExpression syntax
• Misplacing Key inside Item

5. You want to delete a user from a DynamoDB table only if their account is inactive. Which approach correctly combines CRUD operations to achieve this safely?

hard

A. Use putItem to overwrite the user with an empty item

B. Use updateItem to set AccountStatus to 'deleted' without conditions

C. Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive'

D. Use getItem to read then deleteItem without conditions

Solution

1. Step 1: Understand safe deletion with conditions

   To delete only if a condition is met, use deleteItem with a ConditionExpression.

2. Step 2: Evaluate options for correctness

   Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive' uses deleteItem with a condition to delete only inactive accounts, which is safe and efficient.

3. Final Answer:

   Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive' -> Option C

4. Quick Check:

   Conditional delete = deleteItem + ConditionExpression [OK]

Hint: Use ConditionExpression to safely delete items [OK]

Common Mistakes:

• Deleting without checking account status
• Using updateItem to delete data
• Overwriting with putItem instead of deleting