Installing and configuring MariaDB

In this blog, we will get a brief idea on MariaDB, how to install and configure it on a Windows environment. MariaDB is one of the open source databases that is widely used within industries.  MariaDB was invented by Michel Monty Widenius a.k.a “Monty”.  Monty invented three major databases product. MySQL MaxDB MariaDB All three databases […]
Read More »

OLE DB connection error while connecting Oracle database using SSIS

In this blog, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services. SQL Server Integration Service (SSIS) is a Microsoft product which is mainly used for automating importing and exporting data or Extract, transform and load i.e. ETL.  Here is the […]
Read More »

Introduction to Rank Function in Oracle

In this blog, we will see how to use the RANK analytical function in an Oracle database and how it helps us in an analysis. What is the RANK function? The RANK function is an Oracle analytical function which calculates the rank of values which are retrieved, or against a set of rows. The same […]
Read More »

Partition By Clause in Oracle

An introductory discussion about how to use Partition by Clause in Oracle. What is a “partition by” clause in Oracle? It is used to break the data into small partitions and is been separated by a boundary or in simple dividing the input into logical groups. The analytical functions are performed within this partitions.  So […]
Read More »

Installing Oracle 18c on Windows Operating system

In this article, we will see how to install Oracle 18c on the Windows operating system.  To install 18c first we need to download the setup from Oracle.com. In my case, I have already downloaded and extracted locally on my windows machine. The below file will show the step by step guide on how to […]
Read More »

Tuples in Python

In this article, we will see what are Tuple and how we use them in Python programming. Tuples:   Tuples are one of the built-in types of sequences out of six and just like lists. There is another article published on how to use Lists in Python. We want to store the values for the rest of our […]
Read More »

Logical Operators in Python

In this article, we will see what is the logical operator and how we use them in Python programming. Logical Operators: There are basically three types of logical operators as below: And Or Not There above operators semantics or meaning is the same as their meaning in English.  To demonstrate we can take one simple […]
Read More »

Boolean in Python

In this article, we will see how to use Boolean in Python where it can be used to take any decisions if it is true or false, yes or no,  1 or 0. What is Boolean? It is just an integer that can have 1, 0,-1 or floats like 0.32, 3.32 etc. The output of the […]
Read More »

Using Break condition in Python

This article will show a step by step guide on how use Break in Python In many use cases, or due to certain business rules, we need to exit a loop in any programming language. Or, we need to stop a particular loop and continue with the rest of the code. This article will help […]
Read More »

Analytic Functions in Oracle

An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows. Analytic functions are used to calculate or compute aggregate values based on a group of rows, it is also called as a Window. This determines the range of rows used to perform the […]
Read More »