Blog tagged as SQL Programming

Introduction Beginner's Guide to SQL

This is Beginner's Guide to SQL, Databases and their management systems have for some time now been an essential means of storing data. Pick up any software application that comes to the top of your head - be it a simple login page or a payment gateway portal. All...

Transaction Control Language

SQL stands for structured query language which is used to create, modify, retrieve, and store the data in the relational database.

Introduction to Transaction Control Language

Transaction Control Language(TCL) commands are manage transactions in the database. These are mana...

Introduction to View in SQL

In SQL, a view is a virtual table based on the outcome-set of an statement.

A view contains rows and columns, just like an original table. The entries in a view are entries from one or more original tables in the database.

You can add functions, WHERE, and JOIN statements to...

Introduction to Outer Join in SQL

Outer Join in SQL is used when you want to retrieve some uncommon data from multiple tables. The Outer join is used to retrieve the information which is not common between two tables.

There are three types of outer join:-

• Left Outer join
• Right, Outer Join. 
• Full Out...

Introduction to Multi-Row FunctionIn SQL

The multi-row function in SQL is used to retrieve data per set of rows at the time when we work on the group by clause we use the Multi-Row Function.

Types of Multi-Row Functions are

• Maximum(Max)
• Minimum(MIN)
• Average(Avg)
• Sum 
• Count

MAX ( ) Function in SQL:-

Retu...

Introduction to Inner Join In SQL

The most valuable and commonly used of the joins is the Inner Join In SQL. 

They are also referred to as an EQUIJOIN.

The Inner Join In SQL creates a new result table by joining column values of two tables (table1 and table2) based upon the join-word. 

The que...

Introduction to Data Manipulation Languagein SQL

Data manipulation language is used to retrieve information from the table and modify the data which is present in the table this language in SQL is widely used to retrieve data from multiple tables.

commands of DML in SQL. 

• SELECT – retrieve data fr...

Introduction to Data Definition Language in SQL

Data definition language in SQL is abbreviated as DDL. It is also called as data descriptive languages. Now the question arises what is DDL?

DDL statements are used to create and modify database objects such as tables, indexes, and users.

So the commands ...

Introduction to Single Row Function in SQL

Single row function in SQL are the ones who work on a single row and return one output per row.

Single row function in SQL can be character, numeric, date, and conversion functions. these functions are used to modify data items. These functions need one or mo...