Discounted courses from just $13.99 USD and save an extra 20% with code RELAMPAGO20SEP | Ends today at 11:59 PM!
LIGHTNING20SEP

Master Snowflake Cloud Data Warehouse Solutions

Are you ready to take your data warehouse and data management strategy skills to the next level so you can work with Snowflake at a professional level? This Snowflake course is your chance to master one of the leading cloud platforms and significantly improve your capabilities in a data-driven world.

By Ivan Pinar Dominguez | Master in Project Management from ESDEN Business School, PMP & Scrum Master Certificate (PSM I) / Master Project Management Business Executive Internet of Things - MIOTI

👥 9.143
(10)
$15.99 USD $74.99 USD

15 day refund guarantee

This course includes:

▪️ 3h 43m duration on demand

▪️ 54 lessons

▪️ 43 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

✦ Bonus: Downloadable Guide Set

⚑ Certificate of completion

What you will learn

🟧 Snowflake's architecture to understand why it is the most popular cloud data management and storage platform.

🟧 How to load data into Snowflake from different types of sources, both structured and unstructured.

🟧 How to perform and configure data uploads in bulk or real-time with Snowpipe.

🟧 How to get uploads from cloud platforms like AWS, Azure or GCP.

🟧 How to protect our data in Snowflake and share it securely ensuring a reliable data lifecycle.

🟧 Automate ingestion, transformation, and loading processes by defining tasks and streams in Snowflake.

🟧 How to connect Snowflake with data-consuming analytics platforms like Power BI or Python.

🟧 Manage the appropriate roles and permissions to ensure the security of our data.

Course content
U1:Introduction to Snowflake Architecture
  • Introduction to Data Warehouses
  • Snowflake Structure and Benefits
  • Snowflake Editions and Cost Comparison
  • How to Sign Up and Get Started with Snowflake
  • Creation of Warehouses with Interface or SQL in Snowflake
  • Navigating Databases and Tables in Snowflake
  • Monitoring and Analyzing Usage in Snowflake
U2: Loading structured data into Snowflake
  • Data Ingestion into Snowflake: Using Stages
  • Importing Data from Local Files into Snowflake
  • Process to Create a Stage in Snowflake
  • Using the COPY Command to Load Data
  • Data Processing and Transformation in Snowflake
  • Error Handling in COPY: Using "ON_ERROR"
  • Using File Formats for Reusing Configurations
  • Data Validation and Error Handling in Snowflake
U3: Loading unstructured data into Snowflake
  • Introduction to Unstructured Data
  • Setting up Stages and JSON Files in Snowflake
  • Parsing and Processing Unstructured JSON Files
  • Managing Nested Data and Arrays in JSON
  • Flattening and Hierarchies in JSON Files
  • Integrating JSON into Structured Tables
U4: Loading data from cloud platforms (AWS, Azure, GCP)
  • Procedures for Uploading Data from the Cloud
  • Setting Up Buckets and Cloud File Transfer
  • Defining Roles and Policies in Cloud Platforms
  • Setting Up Cloud Integrations in Snowflake
  • Transferring Data to Tables in Snowflake
U5: Snowpipe for real-time data ingestion
  • Snowpipe: Introduction and Creation of Pipes
  • How to Set Up Stages for Snowpipe
  • Procedure for Creating Pipes in Snowflake
  • Tuning Pipes and Notifications in Snowflake
  • Pipe Management and Maintenance
  • Migration of SQL Databases to Snowflake
U6: Data Lifecycle Management, Protection, and Sharing in Snowflake
  • Classifying and Using Table Types in Snowflake
  • Using Time Travel and Fail Safe in Snowflake
  • Sharing Data Between Snowflake Accounts
  • How to connect Snowflake and Power BI?
  • How to connect Snowflake with Python?
U7: Task Automation and Stream Creation in Snowflake
  • Introduction to Tasks in Snowflake
  • Procedure for Creating Tasks in Snowflake
  • Flexible Task Scheduling with CRON
  • Task Tree Management and History
  • Basic Concepts of Streams in Snowflake
  • How to Create Streams and Implement INSERT
  • Using Streams to Run Updates
  • Implementing DELETEs with Streams
  • Managing Data Changes with Streams
  • Integrating Tasks and Streams in Snowflake
U8: Roles and Permissions in Snowflake
  • Access Control Principles in Snowflake
  • ACCOUNT ADMIN Role Responsibilities
  • SECURITY ADMIN Role Functions
  • SYS ADMIN Role Activities
  • USER ADMIN Role Tasks
  • Using PUBLIC and Custom Roles
U9: Conclusions
  • Summary and conclusions

Course evaluation

  • This course contains a final exam
G-Tools: For Students
  • Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Downloadable resources:

📎 Downloadable Materials Set:

▸ Master Snowflake Data Warehouse IPD - protected
▸ Data Loading File Set
▸ Unstructured data load file set
▸ Cloud data upload file set
▸ Snowpipe File Set
▸ Lifecycle and Sharing File Set
▸ Task and stream creation file set
▸ Access Management File Set

Description

✔️ Are you ready to take your Data Warehouse and Data Management strategy skills to the next level so you can work with Snowflake at a professional level?

✅ This Snowflake course is your chance to master one of the leading cloud platforms and significantly improve your capabilities in a data-driven world.

You have surely faced the problem of having to unify and manage large volumes of data from different types of sources to store them in a Data Warehouse. All of this is usually a very tedious task and defining a data strategy is not easy, having to perform manual ingestion, deal with high data volumes, platform performance, cybersecurity, etc.

Don't worry, you've come to the right place, since we can do this in a totally efficient way with the Snowflake platform, as it allows the management and storage of data in a comprehensive and secure way, managing to solve the problems of scalability, maintenance and availability that usually exist with traditional Data Warehouse platforms.

✅ In this course you will learn best practices with Snowflake for data ingestion, data transformation and cleansing, as well as advanced modeling and analysis techniques, therefore, this is the course that covers everything you need to become a Snowflake master.

Throughout the course, you will work through practical exercises and real-life case studies, giving you the confidence and experience to apply your skills in professional settings.

You will have at your disposal extensive reference material and all the scripts explained during this course in such a way that it will be very easy for you to reuse them for your specific use case. My goal is that when you finish the course you will be able to apply Snowflake solutions immediately and establish the best data management strategy for your particular situation.

If you want to take advantage from scratch of all the possibilities offered by the Snowflake platform, which is the most popular in data storage and management, this course is for you.

We guarantee that at the end of the course you will be able to work in Snowflake at a professional level.

Companies from all industries invest in the development of their teams with this course from G-Talent and Ivan Pinar Dominguez

Customer Reviews

Based on 10 reviews
60%
(6)
40%
(4)
0%
(0)
0%
(0)
0%
(0)
O
Oriana Landaeta
El aprendizaje es divertido

La comunidad de estudiantes es muy activa y colaborativa. Siempre hay alguien dispuesto a ayudar y compartir sus conocimientos

A
Arianna Corso
¡Excelente inversión!

Este curso fue mi guía perfecta.

G
Genesis Amundaray
Invertir en este curso

una de las mejores decisiones que he tomado para mi carrera profesional. Snowflake es una herramienta poderosa y este curso me dio las herramientas para dominarla.

Ver más reseñas

Ivan Pinar Dominguez

Master in Project Management from ESDEN Business School, PMP & Scrum Master Certificate (PSM I) / Master Project Management Business Executive Internet of Things - MIOTI

About Ivan Pinar Dominguez

Master in Project Management from ESDEN Business School, PMP & Scrum Master Certificate (PSM I) / Master Project Management Business Executive Internet of Things - MIOTI

Ivan Pinar is a leading telecommunications engineer originally from Spain with an insatiable passion for technology, project management, and teaching. His dynamic and engaging approach to instruction ensures that each student gains the maximum value in knowledge for every minute invested in his classes.

With vast experience in the telecommunications industry, Ivan stays at the forefront of the latest technologies and trends. His ability to break down complex concepts into clear and concise explanations makes him an ideal instructor for students of all levels, from beginners to advanced.

What makes Ivan different?

Top-Level Technical Expertise: Ivan has worked on numerous innovative projects, acquiring deep practical and theoretical knowledge in advanced technologies. His industry experience allows him to offer real-world examples and practical applications that enrich his students’ learning.

Master in Project Management: Beyond his technical expertise, Ivan is an expert in project management. He has successfully led complex and multifaceted projects, imparting to his students the best practices and essential principles to manage projects effectively in any environment.

Student-Centered Approach: Ivan firmly believes that everyone has the potential to learn and achieve their goals. His student-centered teaching method creates a positive and motivating environment, where students feel comfortable to ask questions, experiment, and explore new ideas.

Passion for Teaching: Ivan’s dedication to education is palpable in every class he teaches. His enthusiasm and commitment ensure that each student not only learns, but is also inspired to continue developing and reaching new horizons.

If you are looking for an instructor who combines passion, experience and a deep commitment to your success, Iván Pinar is the perfect choice. Join his classes and discover how you can transform your knowledge and skills into real tools for success in the world of technology and project management.

Sign up now and learn from one of the best!

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

View all

Explore other courses from Ivan Pinar Dominguez

Discover other courses and learn something new today. Learn from the best!

Best Selling Courses in Personal Development

What to expect from G-Talent courses?

  • Study at your own pace

    Get video courses, taught by top instructors, to study at your own pace

  • Learn from the best

    Provides high quality courses developed by carefully selected experts

  • Quality guaranteed

    Not sure? All our courses offer a 15-day success guarantee

  • Permanent accompaniment

    Learn at your own pace, with lifelong updates, access and support.

  • Personalized certificate

    Get a world-class certificate, with international validity and a unique encrypted QR code

  • G-Tools: For Students

    Find all the tools you need for your employability in one place.