AWS for Developers: RDS MySQL Database with Lambdas

AWS for Developers: RDS MySQL Database with Lambdas

54mAdvanced2019-07-19

Authors

Bear Cahill

Bear Cahill

Mobile Application Developer

Course details

The demands of online resources, especially databases, is growing for app development. AWS puts the power of relational databases (RDS) in the hands of developers with Lambdas, but without the difficulty of server configuration and maintenance. AWS provides the power of the server without the needs of configuration, development, and maintenance. In this course, learn how to leverage a RDS MySQL Database, a relational database that can be accessed from an app via Lambdas. Bear Cahill covers AWS account setup, creating a MySQL database, initializing a Node.js project, converting code to Lambda, testing, using SQL queries to work with rows of data, and more.

Learning objectives
Managing an AWS account
Accessing a MySQL database
Creating a Node.js project
Adding MySQL
Using a separate config file
Creating a database connection
Running a query locally
Uploading and testing the Lambda
Using Promisify to clean up
Inserting, deleting, and updating rows
Passing in data
Calling Lambdas

Skills covered

Cloud DevelopmentDatabase DevelopmentAmazon Web Services (AWS)AmazonDatabase ManagementCloud PlatformsCloud ComputingSoftware DevelopmentDeep Dive (X:Y)

Concepts

Introduction

  • Lambda access to RDS MySQL
  • What you should know

AWS RDS MySQL Database

  • AWS account and console
  • RDS and costs
  • Creating a MySQL database
  • Accessing the database
  • Creating a database table

Node.js Project

  • Initialize a Node.js project
  • Adding MySQL
  • Using a separate config file
  • Creating a DB connection
  • Running a query locally

Lambda

  • Lambda basics
  • Converting code to Lambda
  • Uploading the Lambda
  • Testing the Lambda
  • Promisify to clean up

SQL Queries

  • Query rows
  • Insert rows
  • Delete rows
  • Update rows
  • Passing in data
  • Calling Lambdas

Conclusion

  • Next steps
40,000 Toman