Sql

One of the advanced SQL functions you need to know is CTE. During my daily study hour, I came across a task that I had to resolve using CTE popularly known as the Common Table Expressions. …

Supercharge your BigQuery experience with these 6 best practices — Google BigQuery, a powerful serverless data warehouse, has become a cornerstone of data analysis and machine learning pipelines for many organizations. To harness its full potential and ensure an efficient, cost-effective experience, it’s crucial to follow some best practices. …

Introduction Hey everyone, it’s Gabe here, and today I want to dive into the world of database management and share some essential SQL queries that I believe every data analyst should know. With over a decade of experience in data analysis and visualization, I’ve come to appreciate the power of SQL…

In this article, we will learn how SQL queries are executed by the database engine and how we can use this knowledge to optimize our queries for better performance and accuracy. We will also learn about some common techniques and best practices for writing efficient and SARGABLE queries. What is SQL Execution Order? 🤔 SQL execution…

SQLBoiler is a tool to generate a Go ORM tailored to your database schema. It is a “database-first” ORM as opposed to “code-first” (like…

I am super excited to announce that I am going to start an 8-week SQL challenge from 8weeksqlchallenge.com! SQL is a powerful and widely used language for data analytics, and I want to master it as much as possible. …

We are used to working with databases through SQL. It has been this way for decades. Time has shown that in the enterprise world, we mostly keep and manage data in relational databases and use object-oriented practices in our software since most enterprise programming languages are object-oriented, including Java. Although…

Window functions are not always easy to learn, but here I’ll introduce you to a convenient way to not only understand how offset functions work but to also build interactive queries in Snowflake without typing one line of SQL code. The Offset Functions The standard SQL window functions in Snowflake that return a…

In this series of articles, we will study how to convert SQL statements into R data frame syntax. We are using Kaggle notebook to access to the SQLite database file stored in cloud Drive and to run the R scripts.