SQL

Advertisements

SQL Introduction What is RDBMS

What is SQL

SQL (Structure Query Language) is a non-procedural language. SQL are used for access and manipulate data in databases. SQL is an ANSI (American National Standards Institute) standard language.

sql

Why need of SQL

SQL is required for perform following operation on database

  • To create new databases, tables.
  • To insert any records in database
  • To update records in database
  • To delete records from database
  • To retrieve data from database

Features of SQL

  • SQL is not a case sensitive language.
  • Every commands in SQL should ends with semicolon(;).
  • SQL can also called as sequel (SEQUEL).
  • It is an ANSI (American National Standards Institute) standard language.

Limitation of SQL

  • SQL does not support looping and condition statements etc.
  • In SQL you can not execute more than one statement at a time, so it increase the network traffic.
  • SQL always gives system defined error message, when user perform any wrong transaction.
  • SQL does not support the code re-usability, it means you need to write insert, delete, update, select command each and every time.
  • SQL does not support procedure language features such as code re-usability and molecularity and some other features of oops.

To Overcome all these above limitation we use PL/SQL.


SQL Introduction What is RDBMS

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements