Fact U Ever Wanted to Know!

Tuesday, 26 July 2016

UPDATE OPERATIONS ON RELATIONS

›
There are three basic update operations on relations. They are ; 1.Insert Operation 2.Delete Operation 3.Modify Opera...

Assertions and Triggers

›
Assertion An assertion is a predicate expressing a condition we wish the database to always satisfy. Domain constraints, functional...
Saturday, 23 July 2016

Tables

›
All data in relational database is stored in tables. Every tables has a table name and a set of columns and rows in which the data is st...

Views (virtual Tables) in SQL

›
Views (virtual Tables) in SQL : The SQL DDL includes commands for defining views.A views is customized presentation of the data from one...

SQL Data Manipulation Language(DML)

›
SQL (Structured Query Language) is a syntax for executing  queries  . But the SQL language also includes a syntax to update,insert and...

SQL Data Definition Language (DDL)

›
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), sp...

FEATURES OF SQL

›
SQL is the set of commands that programs and users may use to access data within the database that supports it.  Application programs an...
›
Home
View web version
Powered by Blogger.