Welcome to the session on ‘Redshift Development’.
In the previous segment, you learnt about the intricacies of deploying a Redshift cluster. In this session, let’s get hands-on practice for Amazon Redshift. In the next video, let’s see how our expert, Kamlesh, plans to teach this session.
This session will cover the following topics:
- How to connect and query a Redshift cluster.
- How to create objects (database, schema, table) in Redshift.
- What best practices do you need to follow while designing a table?
- How to load data into Redshift.
- How to analyse data within Redshift.
- What are stored procedures and UDFs?
- Basics of how to tune Redshift queries.
Important Note:
Amazon Redshift is a costly service of AWS. Hence, to avoid burning up your monthly AWS budget, please make sure to Pause your Redshift cluster during the module week(when you’re learning/practising Redshift. However, you can also choose to terminate it if there is any kind of break while you are going through the module). And make sure to terminate it once you are done with the module.
Please note that clicking on the Stop button in AWS Academy dashboard does not affect the Redshift cluster and therefore, the cluster has to be terminated from inside the AWS management console page.
People you will hear from in this session
Kamlesh Gallani
Strategy and Architecture Consultant, ZS
Kamlesh is database administrator (DBA) with extensive experience in designing, coding, testing and supporting next-generation database solutions in various database management systems, such as MySQL, Informix, Netezza, PostgreSQL and Amazon Redshift. He is proficient in different technologies, including AWS, MS SQL Server, PHP, Shell Scripting, Perl Scripting, Excel VBA, C++, Linux and Windows.