
Explore how Snowflake architecture blends shared disk and shared nothing designs. Learn the three layers: data storage, compute with virtual warehouses, and cloud services, offering simplicity, performance, and scalable processing.
Explore Snowflake's three table types—permanent, temporary, and transient—and learn how persistent storage, session-based data, and time- or row-limited tables support staging and intermediate data.
Learn how to ingest CSV data from S3 into Snowflake by creating a schema, table, file format, and stage, then copy data and verify 1473 rows.
Learn to build standard streams for a staging table, ingest data into production, monitor stream activity, update records, and merge changes into the production table.
Get ready for Cloud Data Warehousing with Snowflake and AWS complete course. Gain familiarity with the course details and topics designed to help you succeed.
This comprehensive course is designed to take you on a journey through the powerful combination of Snowflake and Amazon Web Services (AWS), two industry-leading solutions that together offer a cutting-edge cloud data warehousing platform. Snowflake is renowned for its performance, simplicity, and versatility, while AWS provides a robust and secure cloud infrastructure that supports an array of services.
Learn about Snowflake on AWS with Hands-On Labs
The Cloud Data Warehousing with Snowflake and AWS is a hands-on practice course designed to familiarize you with the core functionality of Snowflake by connecting it with AWS. Through hands-on exercises, you'll gain a thorough understanding of Snowflake's architecture and how it revolutionizes data warehousing in the cloud. You'll explore the seamless integration of Snowflake with AWS services, such as Amazon S3 and Glue, unlocking a world of possibilities for managing and analyzing your data.
The course comprises approximately 20 labs starting from the basics and moving to high levels in terms of complexity.
Who should take this course?
The course is intended for Data engineers responsible for designing, building, and maintaining data pipelines and data warehouses in the cloud. They will learn how to leverage Snowflake and AWS to create scalable and performant data warehousing solutions. Data analysts seeking to enhance their data manipulation and analytics skills using cloud-based tools will find value in this course. They will learn how to work with Snowflake and AWS services to query, transform, and analyze data effectively. IT professionals and cloud architects interested in understanding cloud data warehousing principles, architecture, and implementation using Snowflake and AWS will find this course beneficial.
Requirements
Basic knowledge of SQL or writing queries in any language
Scripting in Python (or any language )
Willingness to explore, learn and put in the extra effort to succeed
An active AWS Account & know-how of basic cloud fundamentals
Who this course is for:
Software engineers, aspiring data engineers, or data analysts & data scientists
Also good for programmers and database administrators with experience in writing SQL queries
What you’ll learn
Everything needed for Snowpro Advanced Data Engineering certification
Snowflake as a data-warehouse & automated pipeline within Snowflake ecosystem
Use AWS Cloud with Snowflake as a data-warehouse
Integrating real-time streaming data with Kafka and Snowflake
Are there any course requirements or prerequisites?
Prior programming experience in SQL and Python is a must.
Prior basic experience or understanding of cloud services like AWS is important
Who this course is for:
Software engineers, aspiring data engineers, or data analysts & data scientists
Also good for programmers and database administrators with experience in writing SQL queries