If you have been dealing with databases, it must feel like you are handling a bunch of pieces. You need to somehow make sure that they fit together perfectly, and that is where transaction management comes into the picture. And for that, the most important data handling operations are AUTOCOMMIT, COMMIT, and ROLLBACK. In this …
If you have been dealing with numerous databases, I am pretty sure that you may encounter tables where the datetime column contains both date and time. But what if you only want to extract the year? How are you going to retrieve that specific part of the data from the database? In this tutorial, we …
How to Extract the Year from a Datetime Column in MySQL Read More »
When it comes to PostgreSQL, the pivot table becomes a means of forming a structured data image of which the previous role has become a column. The rich function of these pivot tables is basically to run the summarizing, aggregating, and analyzing operations on the data sets. These steps will constitute the project structure which will help to arrange the data in an easy-to-read format. Here, …
Creating Pivot Tables in PostgreSQL Using the crosstab() Function Read More »
Hierarchical data in SQL is data represented in a tree-like structure. The hierarchical data is a parent-child structure where each child has one parent. Each node can have one, more, or zero child nodes. The hierarchical type of data is very common among file systems, product categories, etc. This article is based on the methods to handle the hierarchical …
PostgreSQL plays a very important role if you want to manage data and majorly when you want to manipulate the data according to your requirements. It provides a large variety of statements, functions and JOINs to reduce the complicated structure of the different models. Have you ever heard of VIEW in PostgreSQL? VIEW allows users …
PostgreSQL Standard View vs Materialized View (with Syntax and Example) Read More »
While writing SQL queries, there’s a good chance that you must have encountered the WHERE 1=1 statement in a SELECT query. When we look at it for once, it may seem redundant and unnecessary because isn’t it obvious that one is equal to one? What is the need to include a seemingly true statement in …
You must encounter many occasions in your daily life where you must count on things, and counting things is rather simple, right? However, what would happen if you wanted to count something that’s not even there? That’s when the exciting part starts. When you are using the COUNT() method in databases, there are situations in …
A lot of SQL programming involves doing things again and using specific methods again and over. These recurrent techniques are known as “SQL patterns,” and knowing more about them is essential for database management. SQL developers frequently encounter scenarios where matching Null values becomes imperative. In this tutorial, we will learn the significance of matching …
Matching Nulls by Masking Nulls: A Detailed Guide Read More »
Imagine that you have a bunch of files which contain information about the customers, their orders and the products they have bought. Views help us to see that data in a way that’s easier to understand and use. In this tutorial, we will learn about simple and complex views with the help of practical examples. …
Difference Between Simple and Complex View in SQL Read More »
SQL auto-increment is a specific technique to create some unique numbers as a value to be stored in the tables. Database records, as a result, need specific primary keys while adding new rows to the database. It can also be done without any manual override with the help of the auto-increment feature. This article gives a detailed definition of auto-increment or key uniqueness. To keep it simple, we will …