SnowFlake SnowPro Core Certification Course.
SnowFlake SnowPro Core Certification Course.

Hello everyone. I have decided to launch this course to help everyone who is trying to study for the SnowFlake SnowPro Core Certification Exam, or everybody who is trying to learn how to use SnowFlake and discover all its power. This course is going to be divided into chapters, every…


Hello everyone. I have decided to launch this course to help everyone who is trying to study for the AWS Solutions Architect — Associate exam, with detailed content on each service, cheatsheets, diagrams, and more. It is recommended to have passed the AWS Cloud Practitioner, although it is not mandatory…


AWS Solutions Architect Associate Complete Course: Other AWS Databases
AWS Solutions Architect Associate Complete Course: Other AWS Databases

In addition to Amazon RDS, which is the Relational database as we saw in the last chapter, AWS supports other databases. Apart from Amazon DynamoDB, which is the NoSQL database and we will see it a few chapters later, Amazon Web Services also supports other databases like cache databases (Amazon…


Chapter 13 of the SnowFlake SnowPro Course. Storage Features (Time Travel, Fail-Safe & Zero Copy Cloning).
Chapter 13 of the SnowFlake SnowPro Course. Storage Features (Time Travel, Fail-Safe & Zero Copy Cloning).

So far we have seen many features of SnowFlake that make it an interesting service, but the features that we are going to see in this chapter make SnowFlake unique! …


AWS Solutions Architect Associate Complete Course: Amazon RDS & Aurora Exam Questions
AWS Solutions Architect Associate Complete Course: Amazon RDS & Aurora Exam Questions

The last chapter on Amazon RDS and Aurora was quite extensive as we need to know a lot of their features for the AWS Solutions Architect Associate exam. Let’s see the typical questions we are usually asked to see if we have finished understanding it!

  1. Questions
  2. Answers

Remember that all…


Chapter 12: SnowFlake Cache and Query Performance.
Chapter 12: SnowFlake Cache and Query Performance.

To improve the speed of our queries in SnowFlake, and to optimize costs, one of the most important concepts is the cache. In this chapter, we will study the existing ones (Metadata, Query Result, and Warehouse cache), as well as some tips to improve SnowFlake’s performance.

  1. Metadata Cache
  2. Query Result…


Chapter 11 of the SnowPro Core Course. Resource Monitors.
Chapter 11 of the SnowPro Core Course. Resource Monitors.

In all the cloud services, there must be something to control the price we spend. In SnowFlake, it is controlled by Resource Monitors. Let’s study them in depth to be prepared for the SnowPro Core certification!

  1. Intro to Resource Monitors
  2. Resource Monitors Assignment
  3. Resource Monitors Parameters
  4. Typical Exam Questions on…


AWS Solutions Architect Associate Complete Course: Amazon RDS & Aurora
AWS Solutions Architect Associate Complete Course: Amazon RDS & Aurora

After several chapters understanding the AWS foundation, we are going to study how to store data in AWS using Amazon RDS, Amazon Aurora and the AWS Database Migration Service in this chapter. Let’s get to it!

  1. RDS Introduction
  2. Read Replicas
  3. Multi-AZ
  4. RDS Encryption
  5. AWS Database Migration Service
  6. AWS Aurora
  7. AWS…


Chapter 10 of the SnowFlake SnowPro Core Certification Course. Data Warehouses.
Chapter 10 of the SnowFlake SnowPro Core Certification Course. Data Warehouses.

Data warehouses in SnowFlake are one of the most important parts of this technology, and as we discussed in previous chapters, they will allow us to compute. In this chapter, we are going to see them in more detail:

  1. Warehouses in SnowFlake
  2. Properties from the warehouses
  3. Typical certification questions about…


Ninth Chapter of the SnowFlake SnowPro Core Certification Complete Course.
Ninth Chapter of the SnowFlake SnowPro Core Certification Complete Course.

The first step to load data into SnowFlake tables is to send it to the Stages. In this chapter, we are going to understand how to do that. …

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead @ThePowerMBA 🖥️. Data enthusiast 📊. Uploading the summaries of the courses and certifications that I do.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store