DATABASE

ORDER BY and OFFSET Clause | Database

Introduction ORDER BY clause is used in a SELECT statement to sort results either in ascending or descending order. By default ORDER BY sorts the data in ascending order. Use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order. OFFSET [...]

2020-03-14T20:34:10+05:30Categories: Programming|Tags: , |

SELECT Statement | Database

Introduction SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. SQL commands are not case sensitive. Syntax General syntax of SELECT is SELECT column_list FROM table_name [...]

2020-03-14T20:34:10+05:30Categories: Programming|Tags: , |

Structured Query Language | Database

Introduction SQL is a language that enables you to work with a database. Using SQL, you can insert records, update records, and delete records. You can also create new database objects such as databases and tables. And you can drop (delete) them. SQL is not case sensitive. It is divided [...]

2020-03-14T20:34:10+05:30Categories: Programming|Tags: , |

Normalization | Database

Introduction Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form, removing duplicated data from the [...]

2020-03-14T20:34:10+05:30Categories: Programming|Tags: , |

Elements of Relational Database

Introduction Data is a collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc. A database is an organized collection of data, so that it can be easily accessed and managed. It can organize data into tables, [...]

2020-09-30T11:32:19+05:30Categories: Programming|Tags: , |
Go to Top