What is SQL

What is SQL

What is SQL?

sql SQL is a Structure Query Language. SQL lets us access the database as well as manipulates. 

SQL is a standard language for accessing database manipulation.

We kept the data in large files on paper. But we are gradually storing it online in the databases.

What is Data?

In simple words, the idea of ​​data can be facts related to anything. For example, your name, age, height, weight, etc. Some details about you. Image, image, file, PDF, etc., can also be considered as data.

What is Database?

sql database A database is a systematic collection of information. They have support for electronic storage and manipulation of data. How easy database management data.

The Facebook. It should store, manipulate and present data members, actions of friends, messages, documents, and more. We can give examples and use countless databases.

Types of DBMS

Following figure shows the Evolution of DBMS

How can we easily draw the data we need to look at?

That's what SQL is for. It's a language that communicates with databases. 

Welcome back to MANteck. Your easy insights into MANteck's big data and artificial intelligence. 

SQL stands for structured query language. People call it SQL or Sequel. In short, SQL is the name for a language that is used to communicate with databases. Databases that store your data. If you want to draw, edit, add information to the database, you can use the SQL language to do that.

But how does SQL work? 

Think of a database like a warehouse. Data tables like filing cabinets and data like files. This warehouse or database stores data. 

The warehouse database was built using coding languages like C++ or C or Java. Now imagine regular people need to access the files. 

How do they do that? 

Option one. 

You could have a storefront built to the warehouse so that customers can ask for files, add files, delete files, but eventually this means you are building something that takes a lot of time, money. 

In the real world, this is the equivalent of building a whole app just to access the files in the database as to all comes in, which is the second option, SQL. This is like you hiring a specialized delivery-translator.

Use SQL for your Website

If you want to build the web site that shows the data from database then you need -

• RDBMS database program (eg MS Access, SQL Server, MySQL)
• Use a server scripting language, such as PHP or ASP
• To use SQL to get the data you need
• To use HTML / CSS to form the page

Now you have a question that,

What is RDBMS?

RDBMS is Relational Database Management System.

RDBMS is the basis for SQL and all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL and Microsoft Access.

In RDBMS the data is stored in a database object called a table. A table is a collection of related data items and consists of columns and rows.

SQL Statements

Most actions that use SQL statements need to be performed in the database.

Example:

SELECT * FROM MANteck;

The above SQL statement selects all the records in a "MANteck" table.

Lets see,

Some of The Most Important SQL Commands:

Select - Extracts data from a database.

Update - Updates data in a database.

DELETE - Deletes data from a database.

Creation Database - Creates a new database.

INSERT INTO - New data is inserted into database. 

In addition to DATABASE - modifies a database.

Create Table - Creates a new table.

Other table - Modifies a table.

Drop Table - Removes a table.

Create Index - Creates an index (search key).

DROP INDEX - Removes an index.

Hope you understand SQL and the basics of SQL.