Create a sample database and tables, load data and run SQL queries in Redshift
- [Narrator] Next up we're going to work with Redshift…which is the managed due to warehouse so we're going to work…with our Redshift client.…We're going to make sure that it connects properly…then we're going to run a script to create and…load a database and write and execute ANSI SQL queries…that are designed for data warehousing type workloads.…And the underlying database that we're using here is modeled…in a star schemer, so a center fact table with outside…dimension tables and this is structurally what is…recommended for Redshift.…
Please consult the documentation when you're…working with Redshift.…It really matters how you set up the structure of the…underlying database.…SO here's our cluster and you can see that it's healthy…and available and if I click into it here's the end point.…And you can see that this tells us about our…security connectivity.…It's really important that you set up the appropriate…security group roles because even if you set Redshift to be…available publicly by default you still have to make one…
- 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.