Hands-on with AWS Databases
Learn AWS Data Warehouse - Build with Redshift and QuickSight, Hands-on with AWS DynamoDB, and Hands-on with RDS
You will learn three courses:
- AWS Data Warehouse - Build with Redshift and QuickSight covers all of the main concepts you need to know about Data Warehouse and Redshift. This course assumes you have no experience on Redshift but are eager to learn AWS solution on Data Warehouse. This course has seven hands-on labs from launching Redshift cluster, loading data, managing cluster, monitoring performance to visualizing data on QuickSight. The advanced experimental bonus sections focus on the latest Redshift features. You will learn Redshift essentials, QuickSight visualization, and Machine Learning prediction. You will also get the basic knowledge of other associated AWS services (e.g. S3, IAM, VPC, CloudWatch, and CloudTrial) during this step-by-step deploying and analytical processing. Plus the advanced knowledge of Redshift usage on data streaming and machine learning. Once you have completed this course, you should be able to deploy your data warehouse on Redshift, operate and maintain data, analyze and visualize data on Quicksight, and set up security for Redshift.
- Hands-on with AWS DynamoDB covers AWS NoSQL Database Solution DynamoDB. This course assumes you have no experience of NoSQL database and DynamoDB but are eager to learn AWS solution on NoSQL. This course has twelve hands-on labs such as create DynamoDB Tables, load data, process data operations, enable DynamoDB Streams with TTL to manage modification, replicate table with Global Tables, setup Triggers with Lambda function, build the Serverless Web Application and setup web identity federation. You will also get the basic knowledge on other associated AWS services (e.g. S3, IAM, Lambda, CloudWatch, and CloudTrial). Once you have completed this course, you should be able to deploy your NoSQL database on DynamoDB, operate and maintain data, monitor and secure the database.
- Hands-on with AWS RDS covers all of the main concepts you need to know about Amazon Relational Database Service. This course assumes you have no experience on AWS RDS but are eager to learn AWS solution on Relational Database. This course has many hands-on labs such as launching AWS RDS DB Instance, web application with RDS database or Aurora serverless in VPC, Multi-AZ deployments for failover, monitoring performance and encryption on RDS. You will learn AWS RDS essentials, Aurora serverless, RDS operations and RDS maintenance. You will also get the basic knowledge of other associated AWS services (e.g. S3, IAM, VPC, CloudWatch, and Trusted Advisor) through hands-on labs. Once you have completed this course, you should be able to deploy your relational database on AWS RDS, operate databases, maintain databases, and set up security on AWS RDS
Liya Peng is an IT consultant, certified business mentor and blogger. With 20 years of experience in the financial service industry, Ms. Peng focused on various multi-million dollar projects to support global financial transactions; the technical infrastructure refresh to enhance overall performance and functionalities; project management and team building/mentoring to ensure a successful consistency of on-time and under budget result; and software products’ tactical and strategic planning to support business expansion.
Earlier in Ms. Peng's career, as a proficient software engineer and a pioneer in the database management system, she designed and developed lots of applications for bank and insurance systems. Such as the real-time dynamic operation data storage systems, the leading fraud detection/prevention system, the customized ATM management applications, and various security modules.
Ms. Peng holds several IT certifications such as SCEA (SUN Certified Enterprise Architect), PMP (Project Management Professional), and ACSAA (AWS Certified Solutions Architect Associate) and she would like to help you shorten your learning curve on information technology.