Create a sample database and tables, load data and run SQL queries in RDS.
- [Narrator] Now that we have set up…an RDS relational database MySQL cluster,…we're going to work with data in it.…In order to do that, we need to set up…and test an RDS client,…then we need to create and load a database,…and finally we need to write…and execute ANSI SQL queries.…So here we are in the console,…and we can see that we've got one RDS DB instance.…We don't have a cluster because we're just using…a dev instance, so if we click on instance,…the name is demo, and we scroll down,…we can see we have the connection information here.…
I'm going to copy the end point,…and I've installed a trial version of a premium client.…There's many different clients you can use.…I just find this client, which is called NaviCat,…to be really useful with Amazon, because as you'll see…when I add a connection, it's native for not only Amazon,…but the other clouds and you can have…multiple types of database systems here.…So, we're working with RDS for MySQL.…So, let's call this demo RDS.…
And let's paste in the connection information.…
- Explain the difference between files and databases.
- Identify examples of batching, micro-batching, and streaming.
- Prepare helpful data visualizations with QuickSight.
- Recognize the different types of analytics available in AWS.
- Demonstrate how to set up AWS CLI.
- Describe common analytics architecture patterns.
Skill Level Intermediate
Amazon Web Services for Data Sciencewith Lynn Langit3h 56m Intermediate
1. Analytics on AWS
2. Analytic Services
3. AWS Code Tools for Analytics
4. Advanced Analytics
Next steps1m 20s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.