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.
g one
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.
more g
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.
g I
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.
ginwednesday.com
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.
customer.florencewarehouse.com
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.
http://tinyurl.com/ybvd37wv
Thanks designed for sharing such a pleasant thinking, post is pleasant, thats why i have
read it completely
thelearnandburnconnection.com
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.
cbd oil that works 2020
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.
cbd oil that works 2020
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!
cbd oil that works 2020
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.
cbd oil that works 2020
Ahaa, its fastidious dialogue concerning this article here at this website, I have read all that, so at this time
me also commenting here.
cbd oil that works 2020
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!
cbd oil that works 2020
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!