Engineering

Lecture on Structured Query Language for Database

Lecture on Structured Query Language for Database

Basic purpose of this lecture is to present Structured Query Language for Database. Structured Query Language (SQL) is usually a widely-used programming language for using the services of relational databases. Scope of SQL contains data insert, dilemma, update and delete, schema creation and also modification, and facts access control. Although SQL is normally described as, in order to a great magnitude is, a declarative vocabulary (4GL), it furthermore includes procedural components. Here briefly explain SQL elements: Basic Structure, Set Operations, Aggregate Functions, Null Values, Nested Subqueries, Derived Relations, Modification of the Database, Joined Relations and Data Definition Language etc.