SQL Where Clause with Multiple Conditions
public
–
3 min read
Databases are a significant building block of modern applications. However, databases store a tremendous amount of data. Hence, we need…
With Clause in SQL (CTE)
public
–
3 min read
In this tutorial we explore the workings of Common Table Expressions using the WITH clause and supported functionality.
SQL XOR Operator
public
–
2 min read
Let us explore what the XOR operator in SQL does and how we can use it. For demonstration purposes, we will use MySQL as the base database system.
Weaviate Database CLI Tool
public
–
2 min read
n this tutorial, we will walk you through installing and using the Weaviate CLI on your machine.
Oracle to_date() Function
public
–
3 min read
This tutorial aims to show you how to use the to_date() function in Oracle to perform that.
SQLite Create Database & Insert Data
public
–
5 min read
This tutorial will cover how to use SQLite shell to create databases, create tables, and insert data.
Oracle DB Unique Index
public
–
2 min read
In this tutorial, you are going to learn how to work with unique indexes in Oracle databases to prevent the availability of duplicate values in an indexed column.
Using MySQL dense_rank Function
public
–
2 min read
This tutorial shall delve deeper into how the MySQL dense function works and how we can use it in various database operations.
MySQL SUM Aggregate Function
public
–
2 min read
In this tutorial, we shall learn about one of the popular choices of the aggregate functions: sum.
MySQL LAG() Function
public
–
2 min read
MySQL version 8.0 introduced the MySQL window functions, allowing you to perform queries in an easier and organized method,…
Unlock Locked Oracle DB Account
public
–
1 min read
In this post, we will learn how to use the Oracle ALTER USER ACCOUNT UNLOCK statement.
Java Milvus getMetrics()
public
–
4 min read
Milvus is an open-source vector database that facilitates similarity search and AI applications.
If you are not familiar with vector…