Select Operation (s) in Python
The Select operation selects tuples that satisfy a given predicate. Let’s understand this operation with few examples:Consider the following relation (R1)
The Relational Algebra in Python
The relational algebra is a ‘procedural query language’. It consists of a set of operations that accept one or two
Triggers
The ‘trigger’ is a statement that the DBMS system executes automatically as a side effect of a modification made to
Procedures
SQL also supports procedures, which return multiple values.The dept_count function could instead be written as a procedure. Example-1 : Following is a
Functions
Functions and procedures can be defined using SQL procedural extensions that allow iteration and conditional statements. Example: Following is a function developed,
Authorization
There are several forms of authorizations on parts of the database. Authorizations on data include : Authorization to read data
SQL Data Types
Date and Time Types in SQL : Date : A calendar date containing a four-digit year, month and day of the
Referential Integrity
Referential Integrity Let there be two relations R1 and R2. If a value of a set of attributes (A) in relation
File handling methods in Python
Files are named locations which store information. We can permanently store data using files in a non-volatile memory like a
Generators in Python
Generator-Function: A generator-function is a special type of function which is defined like a normal function, but it returns or