SQL data types

SQL data types

Data types are used to represent a kind of data that can be stored in the database. The data type is the set of representable values. It is also known as an attribute which specifies a data type of the object. Each column, variable and expression has the associated data type in the SQL code when the table was created.

Read more
Introduction to SQL

Introduction to SQL

SQL is a language for operating databases; it includes creating, deleting, extracting lines, modifying lines, etc. databases. SQL is an American National Standards Institute (ANSI) standard language

Read more
Creation and deletion of a database

Creation and deletion of a database

The CREATE DATABASE statement is used to create a new SQL database. The DROP DATABASE statement is used to drop an existing database from an SQL schema. When you have several databases in your SQL schema, before starting your operation, you must select a database on which all the operations will be performed.

Read more
SQL Operators

SQL Operators

An operator is a reserved word or character used primarily in the WHERE clause of an SQL statement to perform operations, such as comparisons and arithmetic operations. These operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.

Read more
Structure of a relational database

Structure of a relational database

A table is a set of data relating to the same entity. It is structured in the form of a table. A table can also be called a relation (it contains the data which are in relation to a given object)

Read more