Databases 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… Sep 9, 2024 Captain Salem
Databases 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. Sep 9, 2024 Captain Salem
Databases 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. Sep 9, 2024 Captain Salem
Development Databases 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. Sep 3, 2024 Captain Salem
Databases 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. Sep 2, 2024 Captain Salem
Databases 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. Sep 1, 2024 Captain Salem
Databases 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. Sep 1, 2024 Captain Salem
Databases 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. Aug 26, 2024 Captain Salem
Databases 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. Aug 26, 2024 Captain Salem
Databases 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,… Aug 26, 2024 Captain Salem
Databases 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. Aug 26, 2024 Captain Salem
Java Databases 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… Aug 26, 2024 Captain Salem