Introduction to SQL

Introduction to SQL and An Introduction to Database Systems

SQL is a standardized query language using for the purpose of Database. with the help of SQL, we can be requested from a  database. SQL using Manipulating, Shorting and retrieving data in databases.

Our Tutorial Scan introduces to you about Introduction of SQL and How to use SQL in SQL Server, MYSQL, MS Access, Informix, Postgres, Oracle, Sybase, and other database systems.

The original version of SQL called SEQUEL, its stand for structured English query language which designed by an IBM research center since 1974 and 1975.
Introduction to SQL and An Introduction to Database Systems image

Advantages of SQL:-

  • With help of SQL, we can execute queries against a database and also can retrieve data from a database
  • insert records into a database
  • Update records in a database
  • Delete records from a database
  • Create new databases
  • Create new tables in a database
  • create stored procedures in a database
  • Create views in a database
  • SQL can set permissions on procedures, tables, and views

Therefore Develop Website Using SQL

When you developed your websites you will need –

  • We need of an RDBMS database program (i.e. MS Access, SQL Server, MySQL)
  • A server-side scripting language, likewise PHP or ASP
  • SQL to get the data you want
  • therefore HTML / CSS to style the page

 

Resource
w3school