Pivot and Unpivot Functions in BigQuery For Better Data Manipulation
Pivot is a very simple function in BigQuery that can be very useful when you need to rotate rows into columns. It uses an aggregate function on rows and converts…
SQL joins and Unions
Complete Explanation on SQL Joins and Unions With Examples in PostgreSQL
This article will be a comprehensive guide for SQL unions and joins. A lot of time databases are designed in a way that joins and unions are essential. For convenience,…
SQL queries and clauses
An Overview of the SQL Query Clauses and Functions
SQL is probably the most widely used tool in the world of Data Science, Analysis, or Engineering. In most job postings SQL is one of the common requirements. There are…
Handling NULL values in SQL
Today’s topic is missing values in a database. It is very common to get databases with some or lots of missing data in them. Missing data may make data retrieval…
Built-in Functions in SQL with Examples
In previous article on SQL, I focused only on some basic queries. This article will talk about the built-in-functions. Built-in-functions are used in the SQL statement to speed up the…
SQL Basics and Data Retrieving Techniques with Examples
SQL – stands for Structured Query Language is used to communicate with database. It is very commonly used for relational database management systems. What is relational database? Data can be…