SQL Challenge: Derivatives in SQL? Today I bring you a challenge! Just a fun little exercise to train your SQL…Eloi Sanchezapril 7, 2023
AcademySnowflake Tips for the SnowPro Core Certification Exam If you are currently in the data field, or you are considering going into it,…Eloi Sanchezapril 7, 2023
SQL Intro to SQL Joins: Understanding Join Types SQL Joins are a fundamental concept in SQL programming, used to combine data from two…Dimitris Lampriadismaart 23, 2023
DataData GenerationData LoadMock DataSQL Mockaroo: fake realistic data In writing previous blogs, I found myself having to search for old tables in which…Niccolo Racioppimaart 23, 2023
Data LoadDatabaseSnowflakeSQL Snowflake File Formats In the previous chapters of this series, we have seen how to load through staging…Mario Calisemaart 23, 2023
Uncategorized Stored Procedures Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can…Can Hobekmaart 22, 2023
DataData GenerationDatabaseSnowflake Unload data from your Snowflake account We have previously seen how to load data from foreign sources to your Snowflake account…Mario Calisemaart 22, 2023
Uncategorized User-Defined Functions User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can…Can Hobekmaart 21, 2023
Snowflake Snowflake’s Data Marketplace: A Game Changer for Data Monetization As we have discussed in previous posts, Snowflake is a data-cloud platform that provides professionals…Dimitris Lampriadismaart 21, 2023
Data LoadDatabaseSnowflake Snowflake Stages: a brief explanation Data storage is a critical component of any database system. When dealing with large amounts…Mario Calisemaart 21, 2023