Co-Learning Lounge

Database Normalization

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

The E of ETL: Extract

Today, DATA is everywhere! From the simplest spreadsheets containing the monthly budget calculations to the enormous amounts of large-sized videos — everything is DATA! Data has an origin, is categorized into numerous types, can be added, modified, deleted, reside in manifold places, and most importantly, has meaning. It accentuates the purpose

The T of ETL: Transform

Data has always been the hero! I say not just the heroine, but everything revolves around data. Agree? Data has been generated from time immemorial. Storing it is also not something ancient. Data is stored in books, receipts, papers, ledgers, databases, data warehouses, and many other storage devices and forms.

The L of ETL: Load

Imagine you have bought a new wardrobe, It is a huge one that can fit in your clothes, cosmetics, accessories and also has space for decor. Your first step could be to bring in all the things from your existing wardrobes that you want to arrange in one place (Extract)

Measures of Central Tendency

Now that you know how to visualize raw data with the help of frequency distribution tables, it is time to solve another problem! For easy understanding, we will take the same COVID-19 data set we considered while learning frequency distributions. Let’s first understand this brand-new concept of central tendency.

How to Download and Install SQL Server Management Studio(SSMS) for Windows 11 (FREE) [Updated]

What is SQL Server Management Studio? SQL Server Management Studio (SSMS) is a unified management environment for any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS includes tools for configuring, monitoring, and administering SQL server and database instances. SSMS can be used to deploy, monitor, and upgrade the

SQL Basics - SELECT, FROM, & WHERE

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

Python

Operations on List Datatype in Python

The list is a very powerful datatype, and it is vital to understand its features and powers to optimize our codes. Lists can contain different data types, and we will use lists very frequently as this is the most used data type. We will try to access size, value replacing,

Operations on Strings in Python

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

Introduction to Strings in Python

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”

Introduction to List Datatype in 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

Introduction to Dictionary in Python

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 Functions in Python

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

Operations on Dictionary Datatype in Python

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

List Functions in Python

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.

Numbers datatype and Arithmetic operations in Python

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.

Working with Strings in Python

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

Arithmetic Operators in Python

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

Python Comparison Operators

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

Logical Operators in Python

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

Types of Comments in Python

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

Print Function in Python

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.

Keywords in Python

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

What is Indentation in Python?

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

Variables and Identifiers in Python

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,