Creating & Using Managed SQL Databases with RDS & EC2 | AWS in Action

RDS (Relational Database Service) is an AWS service that allows customers to create managed SQL database servers (e.g., MySQL).
In this video, an example MySQL database server is created and used by a web application running on an EC2 instance.
AWS in Action Playlist: • Bootstrapping EC2 Inst...
Demo project code: github.com/academind/aws-demos
Demo userdata script: github.com/academind/aws-demo...
AWS Cloud Practitioner course: acad.link/aws-cp
Join our Academind Community on Discord: academind.com/community
Check out all our other courses: academind.com/courses
00:00 Introduction
01:03 The demo project
01:50 Database server options (self-managed vs managed)
03:21 Creating a new RDS instance
08:47 Putting database servers into private subnets
11:43 Finishing RDS instance configuration
14:46 Managing security groups (for RDS & EC2)
18:37 Launching & connecting a new EC2 instance
23:15 Testing the website
24:00 Cleanup
----------
• Go to www.academind.com and subscribe to our newsletter to stay updated and to get exclusive content & discounts
• Follow @maxedapps and @academind_real on Twitter
• Follow @academind_real on Instagram: / academind_real
• Join our Facebook community on / academindchannel
See you in the videos!
----------
Academind is your source for online education in the areas of web development, frontend web development, backend web development, programming, coding and data science! No matter if you are looking for a tutorial, a course, a crash course, an introduction, an online tutorial or any related video, we try our best to offer you the content you are looking for. Our topics include Angular, React, Vue, Html, CSS, JavaScript, TypeScript, Redux, Nuxt.js, RxJs, Bootstrap, Laravel, Node.js, Progressive Web Apps (PWA), Ionic, React Native, Regular Expressions (RegEx), Stencil, Power BI, Amazon Web Services (AWS), Firebase or other topics, make sure to have a look at this channel or at academind.com to find the learning resource of your choice!

[@marcy1339]

Honestly, you explained well, i got to learn a lot from this video even though i had to create my database on AWS exact opposite way but your explanation of each step was really helpful.

[@saivashistdasyapu4374]

Thank you Max🤩

[@erikalmadrid4779]

Nice video, Question, when you stop the instance. Does the SQL data get deleted as well? If I were to restart the instances, would my data still be present in there or not? Thanks

[@hasanmougharbel8030]

Hello there, god bless your efforts.
I have a simple enquiry as a newbie sql learner.
I have installed sql management studio on my own pc, but i am still afraid to connect to the sql instance of a server machine.
Is there any possible connection issues that i may face while connecting to the instance? What are the security measures that should be held
and how to ensure that the server database would not be accidentally damaged when connecting to the server?

[@Euquila]

Simply connecting Management Studio to a database will not cause any harm. SELECT statements will not cause any harm. However, DELETE & UPDATE can! I would also ensure that security is enabled when connecting to a remote DB so that the traffic is encrypted. Do do this, go into the "Connection Properties" and check off "Encrypt connection"

[@M-ABDULLAH-AZIZ]

doesn't rds cost alot in the longer run?