English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 61 lectures (3h 27m) | 2.66 GB
Unlock the Full Potential of AWS DynamoDB for High-Performance NoSQL Database Management
Are you ready to become a DynamoDB expert? Dive deep into the world of AWS DynamoDB with our comprehensive course designed for both beginners and advanced users. Whether you’re new to NoSQL databases or looking to optimize your existing DynamoDB setup, this course has everything you need to master this powerful AWS service.
What You’ll Learn:
- Fundamentals of DynamoDB: Gain a solid understanding of what DynamoDB is and how it differs from traditional SQL databases.
- Creating and Interacting with DynamoDB Tables: Learn step-by-step how to create, manage, and interact with DynamoDB tables using both AWS CLI and AWS SDK.
- Key Concepts and Components: Explore the essential concepts of DynamoDB, including partitions, primary keys, sort keys, and composite keys.
- Global Secondary Indexes: Understand how to create and use Global Secondary Indexes (GSI) to enhance query flexibility and performance.
- Sparse Index: Discover the benefits of sparse indexing and how to implement it for efficient data retrieval.
- Index Optimization: Learn strategies for optimizing your indexes to ensure fast and cost-effective database operations.
- Partition Key Design: Master the art of designing effective partition keys to distribute your data evenly and avoid performance bottlenecks.
- Optimizing Sort Keys: Delve into techniques for optimizing sort keys to support efficient querying and data organization.
- Structuring Secondary Indexes for Efficiency: Understand the best practices for structuring secondary indexes to maximize their efficiency.
- Design and Access Considerations: Explore real-world use cases and learn how to design your DynamoDB setup to meet various access patterns and business needs.
Table of Contents
Introduction
1 Introduction & Course Prerequisites
2 Course Structure
Course Code and Resources
3 Code and resources
Development Environment Setup
4 Dev Environment setup – Instructions
5 Install VS Code – Optional
AWS Account Creation & Setting up AWS CLI
6 Create an AWS Account
7 Creating an IAM User
8 AWS CLI – Introduction and Installation
9 Configure AWS CLI
AWS DynamoDB Fundamentals Deep Dive
10 Create a DynamoDB Table using the AWS Management Console – Hands-on
11 AWS DynamoDB Deep Dive – Definition and Key Features
12 NoSQL vs SQL Databases and Key Differences
13 DynamoDB Components and How They Work
14 DynamoDB Pricing
15 Summary
Tools for Interacting with AWS DynamoDB – AWS CLI and AWS SDK – AWS CLI Hands-on
16 Checkin
17 Tools for Interacting with DynamoDB Deep Dive – Overview
18 Hands-on – Code Structure and Creating a Table using AWS CLI
19 Verify the Table with the Describe-table Command
20 Adding Two Books with the CLI Commands
21 AWS CLI – Command Breakdown
22 Get an Item
23 Scan for Items
24 Update an Item
25 Delete an Item
26 Delete the Table
27 DynamoDB Data Types and Section Summary
Interacting with DynamoDB Table with AWS SDK
28 Interacting with DynamoDB with AWS SDK – Tools for Interacting with DynamoDB
29 The Programmatic Interfaces of the AWS SDK – Full Overview
30 AWS SDKs and Tools for Interacting with AWS DynamoDB – Overview
31 Create a Table with SDK Python
32 Add a Book to the Table with SDK
33 Loading Books from a JSON File with the SDK
34 Delete a Book by Its ISBN or Title
35 Scan the Table
36 Querying the Table
37 Update a Book
38 Delete an Item
39 NOTE – Using the CLI to Interact with Our Table
40 Summary
AWS DynamoDB Indexes – Deep Dive
41 Introduction to Indexes – Full Overview
42 Scan and Filter – Differences and Capacity Considerations
43 Global Secondary Indexes – LSI and GSI – Overview
44 Hands-on – Create a Secondary Index in the Console
45 Things to Consider when Creating GSIs
46 Hands-on – Create an LSI with a New Book Table – Restructuring
47 Loading Restructured Books
48 Hands-on – Querying our LSI
49 Hands-on – Querying LSI using AWS CLI
50 Hands-on – Hands-on – Create a GSI Through Update Command
51 Hands-on – GSI Query
52 Sparse Index
53 Summary
Optimizing Indexes for Efficiency
54 Optimizing Indexes & Key Strategies and Considerations Access Patterns Use case
55 Partition Key Design and Design Keys Considerations
56 Optimizing Sort Keys
57 Structuring Secondary Indexes for Efficiency
58 Use Cases – Design Considerations – Business Decisions
59 Summary
Wrap up
60 Clean up
61 Congratulations & Next Steps
Resolve the captcha to access the links!