AWS Database Cookbook

Welcome to the AWS Database Cookbook! By the end of this guide, you'll take away working applications and the knowledge needed to build your own solutions on AWS. You'll gain hands-on experience with essential AWS services, including AWS infrastructure fundamentals, networking fundamentals, serverless architectures, database management, and Generative AI implementations.

• Why This Cookbook?
• What You'll Achieve
• Who Should Read This Cookbook
• The Ways You Can Use This Cookbook

While AWS offers powerful services and solutions, getting started can feel overwhelming. That's why we've created this practical, hands-on guide that:

• Provides working applications you can deploy immediately using AWS CloudFormation templates
• Builds core concepts through real applications you can take away and modify
• Builds your knowledge progressively from fundamentals to advanced topics

Tenets of the cookbook:

1. AWS journey alignment: Follows the customer's experience with AWS, from building MVPs and PoCs to scalability and performance tuning, incorporating purpose-built databases and services tailored to startup growth stages. Includes integrated troubleshooting guides and common pitfall warnings to streamline the development experience.
2. End-to-end solution focus: Demonstrates complete solutions that span from database design to application architecture, API integration, and modern GenAI services, enhancing your knowledge of how these elements work together cohesively in real-world scenarios.
3. Vertical-specific guidance: Presents explicit industry-specific architectural examples and implementations.
4. Opinionated best practices: Provides clear recommendations rather than overwhelming users with all possible options. Simplifies complex concepts with clear, jargon-free explanations, focusing on just sufficient knowledge needed for implementation.
5. Integrated cost management: Emphasizes cost estimation and optimization throughout the process, including interactive tools and tips.
6. Practical, hands-on approach: Focuses on actionable steps and real-world scenarios rather than theoretical concepts. Provides pre-built templates and scripts in Jupyter Notebooks to reduce setup time and enhance learning.

By the end of this cookbook, you'll have:

1. A fully functional solution for common use cases in:

   • Serverless Retail Web Application
     • A single region deployment powered by highly performant and scalable Amazon Aurora PostgreSQL
     • A multi-region active-active deployment powered by a serverless distributed SQL database Amazon Aurora DSQL
   • Financial Services/Fintech (Life Insurance Agent Powered by GenAI)
   • Healthcare and Life Sciences (Healthcare database system natural language search)

2. Practical knowledge of:

   • AWS best practices and architectural patterns
   • Infrastructure deployment and management
   • Security and compliance considerations
   • Cost optimization strategies

3. Access to:

   • Complete source code in GitHub
   • Step-by-step tutorials with visual diagrams
   • Interactive Jupyter Notebooks
   • CloudFormation templates for automated deployment

This cookbook is designed for technology professionals who are looking to build, deploy, and manage applications on AWS. Whether you're starting your cloud journey or expanding your existing skills, this guide provides practical, hands-on guidance for implementing AWS solutions effectively.

• Technical Startup Founders building their first cloud applications and needing to understand infrastructure practices
• Software Developers and Engineers transitioning from traditional development to cloud-native applications
• Database Developers moving from on-premises systems to AWS managed database services
• DevOps Engineers implementing and automating database infrastructure in the cloud
• Full-stack Developers creating modern web applications using AWS services and best practices
• Students studying cloud computing, database design, AI applications, and software architecture

This cookbook is designed to cater to various learning preferences and experience levels, offering flexibility in how you approach AWS learning and implementation. Whether you're building your first AWS application or optimizing existing infrastructure, you'll find the guidance you need to succeed.

Dive straight into building working applications:

1. Serverless Retail Web Application: Deploy a fully functional e-commerce application using AWS Amplify, Amazon API Gateway, Amazon Cognito, AWS Lambda, Amazon Aurora PostgreSQL, Amazon Aurora DSQL, and Amazon S3.

   • A single region deployment powered by highly performant and scalable Amazon Aurora PostgreSQL
   • A multi-region active-active deployment powered by a serverless distributed SQL database Amazon Aurora DSQL

2. Life Insurance Agent Powered by GenAI: Build an AI-powered system that manages life insurance policies, processes premium payments, and provides policy information using generative AI. This solution leverages Amazon Bedrock, Amazon Bedrock Knowledge Base, Amazon Bedrock Agent, Anthropic Claude models, Aurora PostgreSQL, AWS Lambda, and Amazon S3.

3. Healthcare database system natural language search: Implement an application that enables users to interact with healthcare databases using natural language. You will implement a natural language to SQL conversion using large language models and translate users' questions into clear actionable insights.

The application includes:

• Ready-to-deploy CloudFormation templates for quick setup and experimentation.
• Detailed architecture diagrams and explanations.
• Interactive Jupyter Notebooks for hands-on learning and code exploration.

If you're looking to solve specific challenges, use this table of contents to jump directly to relevant sections:

This approach allows for rapid implementation while providing the depth of information needed for customization and troubleshooting.

For those who prefer a structured approach:

1. Start with AWS Fundamentals
2. Progress through each section sequentially
3. Complete hands-on exercises in Jupyter Notebooks
4. Build your knowledge from basic concepts to advanced implementations

This path ensures a thorough understanding of AWS services and best practices.

Let's begin with understanding how to get started with your AWS journey.

Once you've completed the cookbook sections, visit our Conclusion and Next Steps to:

• Review what you've accomplished
• Discover advanced learning paths
• Find resources for continued growth
• Connect with the AWS community

• AWS Cloud Databases - High-performance, secure, and reliable foundation to power generative AI solutions and data-driven applications at any scale
• AWS Database Blog - Insights and Solutions for Data Architecture
• Fuel innovation with data and AI - Make more informed decisions, improve operations, and differentiate with generative AI