Author: Marian Dziubiak

Junior Technical Writer @ Vertabelo

Opening the Door to SQL Window Functions

window functions,
When you want to analyze data in a database, you need SQL window functions. What are they? How do they work? Read on to find out. There are two ways people use databases. One way is for the creation, modification and deletion of data. The other is analyzing the data, which means getting answers to specific questions. The more precise the questions you ask, the more tools you’ll need to answer them efficiently.

Using Transactions to Prevent Database Errors

What happens when a database receives commands from two different users? We look at the problems that can arise and how to avoid them. Every time you execute a statement in your database, you change the database’s state. When working in a multi-user environment with asynchronous database access, it will sometimes happen that two users are trying to change the same record at the same time. If both of their statements is an operation that changes the database’s state, this can create erroneous results.