Posts tagged "SQL Tutorial "

Tag Archives: SQL Tutorial

SQL Alias Syntax

Let’s see, SQL Alias Syntax. In SQL, Alias is used to provide the temporary name to the Database table or column of any table while writing the SQL query.   Basically, aliases are created to make column names more readable. The concept of aliasing is quite useful in case of large or complex queries. SQL Syntax … Continue reading SQL Alias Syntax

NUll Value in SQL

In SQL, Null value in SQL is unassigned, inaccessible and undefined value. NULL represents missing or unknown data. By default, table column holds the NULL value. If a column in a table is optional, we can insert a new record or update an existing record without adding a value to this column. This means that … Continue reading NUll Value in SQL

SQL Arithmetic Operators

Let’s understand What is SQL Arithmetic Operators? In SQL, We can perform the Arithmetic operations on Table data. To perform the operations we need column names, numeric numbers, and arithmetic operators. Arithmetic operations can be performed only on those columns whose data type is Number or Date type.   SQL Syntax SELECT <Expression>[arithmetic operator]<expression>… FROM [table_name] … Continue reading SQL Arithmetic Operators

SQL Select Statement

The SQL SELECT statement is used to retrieve records from one or more tables in your SQL database.   The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set.   SQL Select Statement’s  Syntax SELECT column_name,column_name FROM table_name; SELECT identifies the columns to be displayed. FROM … Continue reading SQL Select Statement

Types of SQL Statements

First, Let’s understand what is SQL? SQL stands for Structured Query Language. SQL is used to query or manage the RDBMS. SQL is a database language, it is used for database creation, deletion, fetching rows and modifying rows etc.   All DBMS like MySQL, Oracle, MS Access, Sybase, Informix, Postgres and SQL Server use SQL … Continue reading Types of SQL Statements

What is RDBMS

First, Let’s understand what is RDBMS ? A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most RDBMS’s use the Structured Query Language (SQL) to access the database.   In RDBMS data is structured in database tables, fields, and records. Each RDBMS table consists of database table … Continue reading What is RDBMS