Latest blog on category "Database"

WHAT ARE TRIGGERS?

A trigger is a set of SQL statements stored in the database structure. A Trigger is a database object that is attached with the table in SQL.A SQL trigger is fired whenever an event or function associated with a table occurs .......

 919 View(s)

What is Normalization In Database?

The structuring of Database is normalization, Normalization is the process of restructuring tables to eliminate design problems. This process removes redundant data, makes it possible to access data more easily....

 1120 View(s)

Databases To Learn In 2017

PostgreSQL releases its two versions 9.5 and 9.6, this year. They launched the UPSERT functionality after a long time that we know from MySQL (aka ON DUPLICATE KEY UPDATE), better full text search and speed improvements....

 1141 View(s)

Cursor in Sql server database

The Cursor is database object use for getting data and manipulating particular row at a time. It is associated with select query it processes each row returned by select query....

 1153 View(s)

User Define function in Sql Server

User Defined Functions play a major role in SQL. User Defined functions can be used to perform a complicated logic, can accept parameters and return data. Many a times we have to write complex logic which cannot be written using a single query....

 1245 View(s)

SQL View

In this blog describe the concept of sql view in sql server. SQL view is a virtual table. Here we give simple example of view. A View is a Virtual Ta...

 2690 View(s)

CURSOR in SQL Server

In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors....

 5020 View(s)

Locks in SQL Server

In this article, I’m explaining the locks in sql server and its types. Locking helps in providing concurrency within the database. Without locking, S...

 2953 View(s)

Views in SQL Server

In this blog, I’m trying to explain the views in sql server and how to create it. A view can be thought of as either a virtual table or a stored quer...

 2819 View(s)

Rules in SQL Server

In this blog, I’m explaining the rules in sql server and how to create it.Rules enforce domain integrity by providing sophisticated checking of the va...

 3012 View(s)

Keys in SQL

In this blog, I’m explaining the keys in sql and how to create it.Primary KeyA Primary Key is a column which has unique values in the column. A primar...

 2629 View(s)