Share Description
In this course, you will:
- Learn about Snowflake, a cloud-based data warehouse with a unique architecture.
- Discuss its primary features, use cases, architecture, and how it compares to the competition. You will also learn the basics of SnowflakeSQL, including its syntax and parallels to PostgreSQL.
- embark on a trip through Snowflake SQL. You'll start by learning about different ways to connect and interact with Snowflake. As you explore deeper, you'll understand the relevance of Snowflake Staging.
- Navigate the wide landscapes of Snowflake's databases using basic commands, and deepen your grasp of its data types by learning how to convert them and making analogies to Postgres. Finish your exploration by learning Snowflake's functions and practicing data sorting and grouping procedures.
- Begin by investigating various join methods and creating complex queries using subqueries and CTEs. We will focus on query optimization, showing you how to improve the speed and efficiency of your SQL activities. Finally, we'll look at how to handle semi-structured data, such as JSON.
Syllabus:
- Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL
- Snowflake SQL and key concepts
- Advance Snowflake SQL Concepts
