Amazon Redshift is a low-cost cloud data platform that can scale from gigabytes to petabytes on a high performance column-oriented SQL engine. Join data pro Russ Thomas on a demo-heavy dive into Redshift and build your first data warehouse on AWS.
Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing. In Building Your First Amazon Redshift Data Warehouse, you will explore this low cost, cloud based storage that can be scaled up or down to meet your true size and performance needs. First, you will learn to stand up and configure a sample data warehouse. Next, you will explore the internal workings and architecture of Redshift and what makes it so fast. Finally, you will get hands on experience connecting, querying, and building BI and data viz products as well as learn how to secure, maintain, and administer your new platform. By the end of this course, you will be able to scale from gigabytes to petabytes on this high performance column-oriented SQL engine.
Currently an IT leader in Denver Colorado's financial sector Russ has focused on
database development, modelling, administration, and BI since 1997 across the Microsoft
stack. Russ is a passionate trainer and SQL community volunteer presenting regularly
at PASS SQL Saturday events and local user groups around the US.
Course Overview Imagine scaling a data warehouse from a handful of gigabytes to petabytes in a few clicks, and not just file fragments spread across mounds of servers. I'm talking actual structed data that you can leverage complex analytical SQL queries against. Column-oriented, OLAP-optimized, relational data, meaning it's fast and being built on a scale-out, cloud-based architecture keeps it fast, even at massive scale. Amazon Redshift is an excited cloud-based data warehousing platform, perfect for folks already familiar with SQL-based databases and languages. Join me, Russ Thomas, in a dive into Redshift. You'll build your own data warehouse, get familiar with the architecture, learn how to query, load, secure, and manage your own cluster in a demo-heavy, fast-paced course. And if you have a background with SQL Server, PostgreSQL, or MySQL, you're going to be amazed at how familiar it all feels. Either way, I don't like spending a lot of time lecturing, so if you want to actually get hands on, get hands on you will. Whether you've been using the cloud, AWS, or this is your first experience with any of this, come join me in this course, and add some legitimate Redshift experience onto your resume.