SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
Introduction In this article, we will use the LAG function in BigQuery to analyze commission… Read More »SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
SQL
[BigQuery] Mastering SQL for JSON Data Handling: A Practical Guide
Introduction: The Significance of JSON in Data Analysis In today’s digital age, JSON (JavaScript Object… Read More »[BigQuery] Mastering SQL for JSON Data Handling: A Practical Guide
How to use SQL SET/DECLARE Statements (with example)
In this post, we’ll explore how to declare and assign variables using the SET and… Read More »How to use SQL SET/DECLARE Statements (with example)
SQL date functions with examples
In this article, we’ll learn how to handle dates using SQL. We’ll take a closer… Read More »SQL date functions with examples
SQL (5) GROUP BY and HAVING
Let’s move further in the aggregations functions that covered in the last article. In this… Read More »SQL (5) GROUP BY and HAVING
SQL (4) Filtering (BETWEEN, IN, OR, NOT)
In the last article, we’ve talked about the basics of SELECT and WHERE clauses. In… Read More »SQL (4) Filtering (BETWEEN, IN, OR, NOT)
SQL (3) Creating a table
Let’s learn how to create a simple table. ■ CREATE TABLE CREATE TABLE clause create… Read More »SQL (3) Creating a table
SQL SELECT – Let’s look up data
Let’s look at some of the most basic questionnaires with examples. We will use SQLite… Read More »SQL SELECT – Let’s look up data
SQL (1) SQLite Studio installation and practice DB download
Now that we have a basic knowledge of database systems, let’s take a closer look… Read More »SQL (1) SQLite Studio installation and practice DB download
Database101 (4) logical data modeling and relational model
In the last article, we drew blueprints of approximate data with ERD. Now, it is… Read More »Database101 (4) logical data modeling and relational model