The WHERE clause is used to filter the records. It helps to extract only those records which satisfy a given condition. For example in the student table, to display the list of students of age18 and above in alphabetical order of their names, the command is given as below:
SELECT * FROM Student WHERE Age>=18 ORDER BY Name;

Oracle, MySQL, MS SQL Server, IBM DB2 and Microsoft Access are RDBMS packages.

Box plot: The box plot is a standardized way of displaying the distribution of data based on the five number summary: minimum, first quartile, median, third quartile, and maximum.

(i) A cursor in SQL and databases is a control structure to traverse over the records in a database. So it's used for the fetching of the results.
(ii) The cursor object is created by calling the cursor( ) method of connection. The cursor is used to traverse the records from the result set.

The "cd"command refers to changes directory and absolute path refers to the complete path where Python is installed.

In Python, a class is defined by using the keyword class. Every class has a unique name followed by a colon (:).
Syntax:
class class_name:
statement_1
statement_2
.................
.................
statement_n

Making some changes in the data of the existing file or adding more data is called modification.

# Program to join two tuples
Tup1 = (2,4,6,8,10)
Tup2 = (1,3,5,7,9)
Tup3 = Tup1 + Tup2
print(Tup3)
Output:
(2, 4, 6, 8, 10, 1, 3, 5, 7, 9)

(i) "Init" is a special function begin an end with double underscore in Python act as a Constructor .
(ii) Constructor function will automatically executed when an object is created.
General format of __init__ method
                                    (Constructor function)
def __init__ (self, [args........])
<statements>

Syntax:
# Tuple with n number elements
Tuple_Name (E1, E2, E3.......En)
# Elements of a tuple without parenthesis
Tuple_Name = El, E2, E3 ................. En

Python enables reverse or negative indexing for the list elements. Thus, python lists index in opposite order. The python sets -1 as the index value for the last element in list and -2 for the preceding element and so on. This is called as Reverse Indexing.

Python will not allow deleting a particular character in a string. Whereas you can remove entire string variable using del command.
Example :
>>> strl="How about you"
>>> print (str1)
        How about you
>>> del str1
>>> print (str1)
Traceback (most recent call last):
         File "", line 1, in
                 print (strl)
NameError : name 'str1' is not defined

A variable with global scope can be used anywhere in the program. It can be created by defining a variable outside the scope of any function.

Scope of variable refers to the part of the program, where it is accessible, i.e., area where the variables can refer (use) it. The scope holds the current set of variables and their values. The two types of scopes - local scope and global scope.

The break statement terminates the loop containing it. Control of the program flows to the statement immediately after the body of the loop.

A searching algorithm is the step-by step procedure used to locate specific data among a collection of data. There are two types of searching are.
(i) Linear Search
(ii) Binary Search

Pseudo code is an informal way of Programming language syntax.

An Exponent data contains decimal digit part, decimal point, exponent part followed by one or more digits.

The process of binding a variable name with an object is called mapping = (equal to sign) is used in programming languages to map the variable and object.

List is constructed by placing expressions within square brackets separated by commas. List can store multiple values.
Example:
1st := [10, 20]
x, y:= 1st
In the above example x will become 10 and y will become 20.

A function is a unit of code that is often defined within a greater code structure. Specifically, a function contains a set of code that works on many kinds of inputs, like variables, expressions and produces a concrete output.