SQL – STRUCTURED QUERY LANGUAGE

SQL is a Standard Programming Language for retrieving and manipulating the relational database. It stands for Structured Query Language and sometimes pronounced as “See-Quel.” It used for managing data held in the Microsoft SQL Server, IBM DB2, Oracle, MySQL, Relational Database Management System (RDBMS) and Microsoft Access.

SQL has two advantages over the old APIs like ISAM or VSAM. First, you can easily access many records by a single command, and second, it has dropped the need to stipulate how to reach a file with or without an index.

In 1986 and 1987, SQL became a standard of the American National Standards Institute (ANSI), and of the International Organization for Standardization (ISO).

Although SQL became standard of ANSI/ISO, yet different versions of the SQL language are available. For example, a set of extensions offered by Microsoft called Transact-SQL (T-SQL), while PL/SQL is Oracle’s extended version. Though, they all support at least the main commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in the same way.

What can SQL Do?

  • SQL can execute queries against a database.
  • SQL can insert, change or update records in a database.
  • SQL can remove or retrieve records from a database.
  • SQL can create new databases or can add a new table in an existing database.
  • SQL can create stored procedures and opinions in a database.
  • SQL can set permissions on tables, procedures, and views.

SQL COMMANDS:

SQL uses specific commands to carry out the required tasks those guidelines are mainly characterized into four classes as explained under:

DDL (Data Definition Language): 

DDL or Data Definition Language consists of the Agile Scrum that deal with descriptions of the database schema and is used to create and change the structure of the database.

  • CREATE is used to create the database or its objects.
  • DROP is used to remove objects from the database.
  • ALTER is used to change the structure of the database.
  • TRUNCAT is used to remove all records from a table.
  • COMMENT is used to add comments in the data dictionary.
  • RENAME is used to rename objects in the database.

TCL (Transaction Control Language): 

TCL instructions deal with any transaction within the database.

  • COMMIT commits a Transaction.
  • ROLLBACK rollbacks a transaction in case of an error occurs.
  • SAVEPOINT sets a savepoint within a transaction.
  • SET TRANSACTION specifies characteristics for the transaction.

DML (Data Manipulation Language): 

These commands deal with the manipulation of data present in the database.

  • SELECT is used to retrieve data from the database.
  • INSERT is used to enter data into a table.
  • UPDATE is used to update existing data within a table.
  • DELETE is used to remove records from a database table.

DCL (Data Control Language): 

DCL includes commands deals with Azure DevOps, permissions and other controls of the database system.

  • GRANT gives user access privileges to the database.
  • REVOKE withdraw user access privileges.

13 Replies

  1. g one Reply

    Hey! Someone in my Myspace group shared this website
    with us so I came to give it a look. I’m definitely
    enjoying the information. I’m book-marking and
    will be tweeting this to my followers! Wonderful blog and brilliant style
    and design.

  2. more g Reply

    What’s Taking place i’m new to this, I stumbled
    upon this I have found It positively helpful and it has helped me out
    loads. I’m hoping to contribute & assist other customers like its aided me.

    Great job.

  3. g I Reply

    Your style is so unique in comparison to other folks I’ve read stuff from.
    Many thanks for posting when you’ve got the opportunity, Guess I will just book mark this blog.

  4. ginwednesday.com Reply

    Wonderful goods from you, man. I have understand your stuff previous to and you’re just too magnificent.

    I actually like what you’ve acquired here, really like what you’re saying and
    the way in which you say it. You make it entertaining and you still care
    for to keep it wise. I cant wait to read far
    more from you. This is actually a terrific website.

  5. Hello i am kavin, its my first time to commenting anyplace, when i read this article i thought i could also make
    comment due to this brilliant article.

  6. I’m gone to convey my little brother, that he should also pay a visit this web site on regular
    basis to obtain updated from most recent information.

  7. cbd oil that works 2020 Reply

    I have read some good stuff here. Definitely worth bookmarking for revisiting.
    I surprise how much effort you set to create one of these wonderful informative web site.

  8. cbd oil that works 2020 Reply

    I don’t even know how I ended up here, but I thought this post was great.
    I do not know who you are but definitely you are going to a famous
    blogger if you aren’t already 😉 Cheers!

  9. cbd oil that works 2020 Reply

    Hi there, i read your blog from time to time and i own a similar one
    and i was just wondering if you get a lot
    of spam comments? If so how do you reduce it, any plugin or
    anything you can recommend? I get so much lately it’s driving me mad so any assistance is very much
    appreciated.

  10. cbd oil that works 2020 Reply

    Ahaa, its fastidious dialogue concerning this article here at this website, I have read all that, so at this time
    me also commenting here.

  11. cbd oil that works 2020 Reply

    Hey there would you mind letting me know which webhost you’re using?
    I’ve loaded your blog in 3 different web browsers and I must say this blog loads a lot quicker then most.
    Can you recommend a good web hosting provider
    at a honest price? Kudos, I appreciate it!

  12. cbd oil that works 2020 Reply

    This design is spectacular! You most certainly know how to keep a reader
    entertained. Between your wit and your videos,
    I was almost moved to start my own blog (well, almost…HaHa!) Wonderful job.
    I really loved what you had to say, and more than that, how you presented it.
    Too cool!

Reply