SQL commands are easy to understand until you reach some websites and see the same complex diagrams and jargon. Now you have reached a point after which you don’t need those! So before we deep dive into things, we map the things. I will tell you my story of

Database Normalization, aka Normalization, in simple words, is the efficient Architecture of a database. Efficient Architecture is the Keyword here. It is a process of organizing your database in the most efficient form. Normalization starts with understanding the data. Once you have understood your data, you implement a certain set

In this article, we will learn about the basics of SQL (SELECT, FROM & WHERE) with exciting visuals, and the bonus is my personal story of learning SQL. I tell you, it is no less than Moneyball. You all must have used Excel in your life to do something, and in

Like numbers datatype, we can also do some operations on String datatype. These operations include addition, multiplication, and type conversion. Let’s see some examples to understand more about these operations. Arithmetic Operation on String We all have done arithmetic operations on numeric data. The question is, do these arithmetic

In this blog, you will learn very important and widely used datatype, i.e., “string.” The string is a simple sequence of characters enclosed in delimiters. We will learn what kinds of delimiters are used in Python. There are many ways to represent strings with different delimiters. E.g., “Python”

Lists are one of the most used data types in Python. The very first thing we will learn in Python Data structure is List. Data structures are like “containers” that hold and organize a group of data according to type. Data structures are the collection of data on which tasks

Dictionary is one of the advanced datatypes in Python which help us tackle lists’ limitations. A list is known as a sequence datatype, while Dictionaries are mapping datatypes. Let me tell you one story first! A guy named “Weird” was living in a country that had a population of 100

Dictionary is used to store key: value pairs, and it is one of the essential datatypes. We will explore the built-in methods for dictionaries to optimize dictionary use. Multiple built-in functions exist for adding and removing different kinds of data in the dictionary. First, let’s see how to add

Like Lists, We can perform several operations on a dictionary just as adding and accessing elements. In this blog, we will explore such operations with easy examples. First, let us start with adding the elements to any dictionary! Adding elements to a Dictionary In Python Dictionary, the Addition of elements

We know how powerful list datatype is. Some methods can help us work with Lists faster, and we will explore all of those in the next examples. These methods can update, delete, sort, and remove elements from the lists. Let’s first start by adding new elements to the list.

We have been dealing with numbers for a very long time, and numbers are essential to any kind of data. Number data types store numeric values. In Python, Numbers are immutable data types, which means that changing the value of a number data type results in a newly allocated object.

Strings are one of the most important data types in Python. We are going to find ourselves dealing with strings very frequently. So far, we know how to create a string in Python. Now we are going to take a leap and learn how to access string characters, index in

We all have been using Arithmetic operators for a very long time and these works the same way in programming languages as well. Let’s learn about these operators and try with some examples.   Addition Operator (+) Addition operators are used to adding two values. Simple maths, right? Let’s try

Comparison is a fundamental part of our lives to make decisions. For e.g, if you get 2 apples at 5 or you can get 3 apples at 5.25! What would you buy? 3 apples, right? We make decisions the same way, right? This is just an example. We

Operators are fundamental in programming. There are times when we tell computers to perform certain tasks when some conditions are met. Logical operators are key elements in that flow. Logical operators are used to combining conditional statements. For eg., if we have to process some job applications and the primary

Developers often make use of the comment system as, without the use of it, things can get confusing real fast. Comments are helpful information that the developers provide to make the reader understand the source code. It explains the logic or a part of it used in the code. Comments

The most baby step while learning a programming language is to learn about the input and output statements. Output is not just for the functioning of our programs. It is essential for checking at various steps if our code is running fine. Also, it is used in debugging as well.

We know how each word in our language has some meaning and when used with the correct grammar, we communicate. Same way, we use keywords and syntax to communicate with the machine. Python Keywords are predefined reserved words used in Python codes. These are also known as Python-reserved words. These

Python indentation is space before the line of code in your program. Indentation is a way to tell the python interpreters that this is a block of code. Block of code is packaged code that is executed according to our specified condition so it is our moral responsibility that we

What is a Variable? Programming languages are used mainly to convert our ideas into the logic that machines can follow. Let’s understand this with one of the best examples! Think of vending machines that we all are aware of. Let’s say you need to buy cola and chips,

Instruction that a Python interpreter can execute is a statement. Difficult to grasp? Let’s get to bottom of it! Remember a few Python codes we went through in the previous blogs? Let me help you remind those. We started learning Python by printing this “Hello World” code. print("Hello