Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

SQL # 1 - Introduction to SQL

Introduction to SQL-
What is SQL?
  • SQL stands for Structured Query Language.
  • It is designed for managing data in a relational database management system (RDBMS).
  • SQL is a database language, it is used for database creation, deletion, fetching rows and modifying rows etc.
  • SQL has reduced the need for lengthy programming to access data.
  • The SQL user does not need to know how data is stored. The query language (SQL) takes care of retrieving, replacing, adding, and deleting data.
  • A procedural programming language needs every specification about data. SQL is simpler in operation than procedural languages like C/C++ for database management.
  • DBMS like MySQL, Oracle, MS Access, Sybase, Informix, Postgres and SQL Server use SQL as standard database language.
Why SQL is required?

SQL is required:

  • To create and drop databases and tables.
  • To create and drop databases and tables.
  • To update records in a database.
  • To delete records from a database.
  • To retrieve data from a database.
  • To set permissions on tables, procedures and views.
  • To define the data in a database and manipulate that data.
  • To access data in the relational database management systems.
  • To create view, stored procedure,functions in a database.








This post first appeared on OnlineTutorialHub, please read the originial post: here

Share the post

SQL # 1 - Introduction to SQL

×

Subscribe to Onlinetutorialhub

Get updates delivered right to your inbox!

Thank you for your subscription

×