Events  Deals  Jobs  NFT NYC 2024 
    Sign in  
 
 
Thu, Dec 12, 2019 @ 09:30 AM   FREE   Amazon AWS Loft, 350 W Broadway
 
     
 
 
              

      
 
Sign up for our awesome New York
Tech Events weekly email newsletter.
   
EVENT DETAILS
Redshift Day at the AWS Loft is an opportunity for you to learn about the most popular & fastest growing cloud-based data warehouse. Amazon Redshift is a fast, fully managed, & cost-effective data warehouse that gives you petabyte scale data warehousing & exabyte scale data lake analytics together in one service. On Redshift Day, we explain the fundamentals, best practices, & take a technical deep dive into Amazon Redshift data warehouse. We cover the integration with Amazon Data Lake through Amazon Redshift Spectrum, & a few other AWS Analytics services including AWS Glue & Amazon Athena.



Prerequisites:

- A laptop & active AWS account

- Basic knowledge of AWS & its services



Session levels range from 200-300. More information on session levels here.

Who should attend

Developers, engineers, architects, Database Administrators, Data Architects, Data Engineers, & systems administrators who are interested in learning about cloud-based Data Warehouse.


Attend if you're technical & looking to evolve your skills to build a cloud-based Data Warehouse solution based on Amazon Redshift that will enable modern analytics use cases. You'll learn the best practices on how to design tables with the proper distribution style, load data into Redshift, & how to fully integrate with Data Lake using Amazon Redshift Spectrum. With Amazon Redshift Spectrum customers can easily query their data in Amazon S3 & extend Data Warehousing out to exabytes with no loading required.

SCHEDULE

Welcome & introductory presentations

9:30AM-10:00AM

Check-In

Sign in, grab a badge, & take your seat.

10:00AM-10:15AM

Introduction to the AWS Loft & Redshift Day



10:15AM-11:15AM

Modernize Your Data Warehouse with Amazon Redshift

Enterprises across the globe are looking to migrate their data warehouse to the cloud. Amazon Redshift is a petabyte scale, highly rated, fully managed cloud data warehouse service. It is used by tens of thousands of customers to get ten times faster performance at one tenth pricing. In this session, you will learn about Amazon Redshift's features & functionalities that will help you build a high-performance data warehouse in cloud.

Level: 200

11:15AM-1:30PM

Workshop: Build a Data Warehouse with Amazon Redshift

Enjoy lunch courtesy of AWS.

Amazon Redshift is a cloud-based modern data warehouse designed to deliver fast query performance at lowest cost possible. In this session, you will deploy a Redshift Cluster from scratch, create the table schemas using the proper distribution style so that queries can take advantage of Massive Parallel processing using multiple nodes & slices. Additionally you will load data stored in the data lake based on Amazon S3.

Level: 200

1:30PM-2:30PM

Redshift Deep Dive & Best Practices

In this session, we will dive deep into Amazon Redshift & walk you through some of the tuning options to get the most of performance for your queries. You will learn how to use the proper distribution style to maximize data distribution, use of sort keys for query predicates & joins, Workload Management for maximum query throughput & concurrency. Additionally, you will learn the newest features available in Amazon Redshift for automatic tuning & increased query throughput during query execution spikes.

Level: 300

2:30PM-4:30PM

Workshop: Analyze Data in Your Amazon Redshift Data Warehouse & Amazon S3 Data Lake Using Amazon Redshift Spectrum

Not all of your data is always loaded into your data warehouse, & yet sometimes analysts need access to it quickly, without waiting on an ETL job to load. Amazon Redshift is a fast, simple, cost-effective data warehouse service that can extend queries to your data lake using your existing business intelligence tools. This session takes a hands-on approach to show you how to mine your Amazon S3 data lake using open data formats with Redshift Spectrum, a feature of Redshift, without the need for unnecessary data movement. This enables you to analyze data across your data warehouse & data lake, together, with a single service.

Level: 300

4:30PM-4:45PM

Redshift Day Closing
 
 
 
 
© 2024 GarysGuide      About    Feedback    Press    Terms