AWS for Developers: RDS MySQL Database with Lambdas

54mAdvanced2019-07-19

Authors

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

0. Introduction

01 - Lambda access to RDS MySQL
02 - What you should know

1. AWS RDS MySQL Database

03 - AWS account and console
04 - RDS and costs
05 - Creating a MySQL database
06 - Accessing the database
07 - Creating a database table

2. Node.js Project

08 - Initialize a Node.js project
09 - Adding MySQL
10 - Using a separate config file
11 - Creating a DB connection
12 - Running a query locally

3. Lambda

13 - Lambda basics
14 - Converting code to Lambda
15 - Uploading the Lambda
16 - Testing the Lambda
17 - Promisify to clean up

4. SQL Queries

18 - Query rows
19 - Insert rows
20 - Delete rows
21 - Update rows
22 - Passing in data
23 - Calling Lambdas

Conclusion

24 - Next steps