Before diving into the concept of Generators in python, let's take make ourselves familiar with the Iterators. Iterators are python objects that can be iterated upon, meaning that we can...
In this article, we will discuss different methods (find, split and regular expression module) to find the second occurrence of a substring in a given string.
Sometimes in the dataset, you have some columns that are not of your use but when you run a query it will also get executed that leads to you increase...
Closure in python is the function that remembers values in enclosing scopes even if they are not present in memory. In this article, we will discuss about python closure in...
A pass statement in Python is a null statement that act as a placeholder for future code. In this article, we will briefly discuss how to use pass statement with...
In SQL you can apply conditions on the cell based on other cells using CASE statement. In this article we will discuss how to use a case statement in sql...
In the previous articles, we have discussed LIKE and IN operator. In this article we will discuss BETWEEN operator in SQL that is also a logical operator.
Logical Operators in SQL are used to connect two or more expressions. In this article, we will discuss one of the logical operators i.e. LIKE operator in detail about how...
SQL JOINS are used to combine more than two or more tables together to extract the useful data from all the tables. In this article, we will discuss INNER JOIN...