2022-05-16

SQL Window Functions explained with example

32 mins read All database users know about regular aggregate functions which operate on an entire table and are used with a GROUP […]
2022-02-14

Understanding GROUP BY, GROUPING SET, ROLL UP, and CUBE in SQL

18 mins read GROUP BY A table in a database has columns of information in it. Each column in a table represents an […]
2022-02-11

A tutorial on Apache Cassandra data modeling – RowKeys, Columns, Keyspaces, Tables, and Keys

24 mins read In this post, I will discuss the basic concepts of data modeling in Apache Cassandra. It is important to understand […]
2022-02-11

Understanding Cassandra Partition Key, Composite Key, and Clustering Key

13 mins read 1. Overview Data distribution and data modeling in the Cassandra NoSQL database are different from those in a traditional relational […]
2022-02-04

Connect to Cassandra Cluster with Dbeaver Community edition

2 mins read DataStax offers the JDBC driver from Magnitude (formerly Simba) to users at no cost so you should be able to […]