All Basic Articles

PostgreSQL – Introduction to Stored Procedures

PostgreSQL allows the users to extend the database functionality with the help of user-defined functions and stored procedures through various procedural language elements, which are… Read More

postgreSQL-stored-procedures

PostgreSQL

Difference between Conservative and Strict 2PL

Prerequisites – Two Phase Locking Protocol and Types of Two Phase Locking Protocols 1. Conservative 2-PL : It is also known as Static 2-PL. This… Read More

DBMS

GATE

Difference between Kimball and Inmon

Designing a Data Warehouse is an essential part of business development. For designing, there are two most common architectures named Kimball and Inmon but the… Read More

data mining

DBMS

Difference Between

Vectorized Operations in NumPy

Numpy arrays are homogeneous in nature means it is an array that contains data of a single type only. Python’s lists and tuples are unrestricted… Read More

Python-numpy

Python

Append Operation on Vectors in R Programming

In this article, let us discuss different methods to concatenate/append values to a vector in R Programming Language. Append method in R Vectors in the… Read More

Picked

R-Vectors

R Language

JavaScript TypeError – Reduce of empty array with no initial value

This JavaScript exception reduce of empty array with no initial value occurs if a reduce function is used with the empty array. Message: TypeError: reduce… Read More

JavaScript-Errors

JavaScript

Web Technologies

Making a simple PWA under 5 minutes

Progressive Web Apps, that is PWAs, are a type of application that is developed using web technologies and can be installed on any device like… Read More

HTML-Misc

JavaScript-Misc

HTML

JavaScript

Web Technologies

PostgreSQL – List Indexes

In PostgreSQL, we use the pr_indexes view to list the indexes of a database. PostgreSQL does not provide a command like SHOW INDEXES to list… Read More

postgreSQL-indexes

PostgreSQL

Plotting Various Sounds on Graphs using Python and Matplotlib

In this article, we will explore the way of visualizing sounds waves using Python and Matplotlib. Modules Needed 1. Matplotlib: Install Matplotlib using the below… Read More

Data Visualization

Python-matplotlib

Python

Joining of Dataframes in R Programming

rreIn R Language, dataframes are generic data objects which are used to store the tabular data. Dataframes are considered to be the most popular data… Read More

Picked

R-DataFrame

R Language

PostgreSQL – ROW_NUMBER Function

In PostgreSQL, the ROW_NUMBER() function is used to assign a unique integer to every row that is returned by a query. Syntax: ROW_NUMBER() OVER( [PARTITION… Read More

PostgreSQL-function

PostgreSQL-Window-function

PostgreSQL

Introduction of Blackberry Technology

Blackberry is communication device that was developed in the year 1999 by Research in Motion (RIM) company. Blackberry Technology contains games, contacts, clock, reminders and… Read More

Computer Networks

Python – seaborn.regplot() method

Seaborn is a Python data visualization library based on matplotlib. It provides a high-level interface for drawing attractive and informative statistical graphics. Seaborn helps resolve… Read More

Python-Seaborn

Python

Python – seaborn.pointplot() method

Seaborn is an amazing visualization library for statistical graphics plotting in Python. It provides beautiful default styles and color palettes to make statistical plots more… Read More

Python-Seaborn

Python

turtle.circle() method in Python

The Turtle module provides turtle graphics primitives, in both object-oriented and procedure-oriented ways. Because it uses Tkinter for the underlying graphics, it needs a version… Read More

Python

Draw Spiraling Star using Turtle in Python

Prerequisite: Python Turtle Basics Turtle is an inbuilt module of python. It enables us to draw any drawing by a turtle and methods defined in… Read More

Python-projects

Python-turtle

Python

How to print spaces in Python3?

In this article, we will learn about how to print space or multiple spaces in the Python programming language. Spacing in Python language is quite… Read More

python-basics

python-io

Python

Types of HDLC Frames

High-Level Data Link Control (HDLC) generally provides flexibility to simply support all options that are possible in various data transfer modes and configurations. To provide… Read More

Data Link Layer

Computer Networks

Constructions in LaTeX

Constructions in LaTeX are used to construct various parts of an equation such as fraction, vector, integration, square root, etc. Use of LaTeX codes is… Read More

Engineering Mathematics

Difference between Android Toast and SnackBar

1. Toast : It is an Android UI component that is used to show message or notification that does not require any user action. It is… Read More

Difference Between