Thursday, 14 February 2013
SQL: What is SQL
Do you like this Article?
SQL (Structured Query Language) is a type of programming language, which uses to communicate with database. It’s also known as “sequel”. It provides some syntax which helps you to interact with a database. These syntax are very similar to normal English language, so it’s easy to remember and use. Now a day, all major RDBMS (Relational Database Management System) like MySQL, Oracle, postgres, MS Access and SQL Server uses SQL to maintain data.
SQL helps to store, manipulate, read and delete data from data base. It helps to performs the CRUD(Create, Read, Update & Delete) operations in RDBMS.
Create: It helps to create database, schema, table and view, along with there properties.
Read: It helps to select all information from single or multiple records from one or many table or view.
Update: It also helps us to manipulates existing data in a database.
Delete: It can also delete information or structure of database or table.
SQL helps to store, manipulate, read and delete data from data base. It helps to performs the CRUD(Create, Read, Update & Delete) operations in RDBMS.
Create: It helps to create database, schema, table and view, along with there properties.
Read: It helps to select all information from single or multiple records from one or many table or view.
Update: It also helps us to manipulates existing data in a database.
Delete: It can also delete information or structure of database or table.
Subscribe to:
Post Comments
(
Atom
)
Popular Posts
-
public - public means everyone can access it.That means it's in global scope. As, main method is called by JVM [ Java Virtual Machine...
-
throw is used to throw an exception in a program, explicitly . Whereas, throws is included in the method's declaration part, wi...
-
Singleton in one of the most popular yet controversial design pattern, in the world of object oriented programming. It's one of t...
-
Web Container / Servlet Container / Servlet Engine : In J2EE Architecture , a web container (also known as servlet container or ser...
-
Program compiles. But at runtime throws an error “NoSuchMethodError”.
-
Vector : It's synchronized. It's slower than ArrayList. It's generally used in ...
-
doGet(): protected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, java.io.IOException – is a met...
-
In Java Programming Language , we must declare a variable name and type, before using it. The data type of a variable defines the th...
4 Responses to “ SQL: What is SQL ”
14 February 2013 at 23:49
nice!....
thanks a lot! :)
19 August 2019 at 17:42 This comment has been removed by the author.
19 August 2019 at 17:49
The Question and Answered shared by you is very informative, to the point. This will be helpful for students who preparing for DBMS- SQL interview.
Regards
ACL IT Academy – SQL and DBMS course in Kolkata
31 January 2023 at 17:36
First of all, I would like to thank you for sharing this great piece of content.
Math is one of the most important subjects for any student in any class. Mathematics is a subject that includes topics such as knowledge of numbers, shapes, spaces, volume, distance etc. It is seen that some students find math interesting, on the other hand some students find math as difficult. This is because most of the students take Maths Online Tuition classes from the starting of their session so that they can score good grades.
The Ultimate Guide to Stars and the Milky Way
Post a Comment