A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

kinds of SQL joints

Different Types of SQL JOINs

Here are the different types of the JOINs in SQL:

  • LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
  • RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
  • FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table


What is Pandas?

If you wonder where the name comes from, unfortunately, it is not because the creators liked pandas as a species so much — it is a combination of panel data which has roots in econometry and Python data analysis.

Data analysis was always important, especially for scientists. However, data collection and analysis plays a significant role in business as well. Today we are going to talk about Pandas, which is a Python library with pre-built methods for many applications. Pandas seems to be quite useful for data science operations and additionally, easy to use which means time and effort efficient


NumPy. This library has become fundamental, it is hard to imagine a world of research and data science without it, or before its birth. NumPy has been around since 2005, and if you ever worked with data in Python, you must have used it, one way or the other.

What is NumPy?

So what is NumPy? According to the official website, NumPy is the fundamental package for scientific computing in Python. It is a Python library that provides a multidimensional array object, various derived objects (such as masked arrays and matrices), and an assortment of routines for fast operations on arrays, including mathematical…


The world of data is constantly changing and evolving every second. This in turn has created a completely new dimension of growth and challenges for companies around the globe. By accurately recording data, storing, updating and tracking them on an efficient and regular basis, companies can address their challenges on one hand and make use of the immense potentials offered by this sector on the other hand.

A database management system stores, organizes and manages a large amount of information within a single software application. The use of this system increases efficiency of business operations and reduces overall costs.

In…


If you are working in a large software application where they process a large number of data, then we cannot expect those data to be stored in a variable as the variables are volatile in nature. Hence when are you about to handle such situations, the role of files will come into the picture.

As files are non-volatile in nature, the data will be stored permanently in a secondary device like Hard Disk and using python we will handle these files in our applications.

Are you thinking about how python will handle files?

Let’s take an Example of how normal people will handle the files. If we want to…


This blog provides details on most frequently asked interview questions and answers on Python.

Enlisted below are the most commonly asked interview questions and answers on Python programming language.

  1. Which is faster in python — Searching in a list or a dictionary. And why?
  2. How can we get the code of a python object?
  3. What are the ways to make python code work faster?
  4. What is exec function and how we can use it?
  5. What are metaclasses and dataclasses in python?
  6. what is __call__ method in python?


Python is a popular, versatile and easy-to-learn language. It’s the go-to language for AI, Machine Learning and Data Science. Some say it’s also the easiest programming language to get started with.If this sounds like a programming language you want to learn, keep reading!

We’ll cover some of the important concept of Python in this blogs and the topics covered are as follows :

  1. Modules
  2. List Comprehensions
  3. Iterators
  4. Generators
  5. Classes and objects
  6. Descriptors

Function

Wasim Alam

Passionate about ML

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store