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