Friday, 12 February 2016

Websites for execute SQL Online

SQL Editor is a coding editor that lets you work on your SQL code, either locally or by connecting directly to your online database.It helps to let you immediately execute your SQL statements and view the output.

Websites for execute SQL Online:

        This online SQL editor, you can edit the SQL statements, and click on a button to view the result.

        Use this panel to setup your database problem and execute the sql queries.











3) Tutorials Point

        This helps to execute our SQL statements and get the output for that queries.













4) Online SQL interpreter

        Online SQL interpreter. Enter some SQL queries and execute.






Thursday, 11 February 2016

Basics of SQL

  • SQL first appeared in 1974 and the initial release in 1986.
  • It is designed by Donald D.Chamberlin and Raymond F.Boyce.
  • The filename extension in sql is .sql.
  • Sql is developed by ISO/IEC and the standard is ISO/IEC 9075.
  • SQL Versions: SQL-86,89,92,1999,2003,2006,2008,2011.
  • SQL initially called SEQUEL(Structured English QUEry Language).
  • It is became a standard of the ANSI in 1986 and the ISO in 1987.
  • Transact-SQL (T-SQL) is an extension of SQL that is used in SQL Server.
  • The origins of the SQL take us back to the 1970s, when in the IBM laboratories, new database software was created - System R.
  • various open-source SQL database solutions such as MySQL, PostgreSQL, SQLite, Firebird, etc are there.
Definition of SQL:
  • SQL is responsible for querying and editing information stored in a certain database management system.
  • Structured Query Language (SQL) is a language used to view or change data in databases.
  • SQL, which stands for Structured Query Language, is a programming language that is used to communicate with and manipulate databases.
Advantages of SQL:
  • SQL runs on Windows,Linux, and Unix as well as Mac OS X.
  • It is easy to use.To hide data complexity.
  • It is a free and Open source.
  • Interactive language.
  • No coding required.
  • It is used to protect the data.
  • Portable.
  • High Speed.
  • Easy to learn and understand.
  • Restrict the access of a table so that nobody can insert the rows into the table. 
  • Client/Server language.
  • Dynamic.
  • Join two or more tables and show it as one object to user.
Disadvantages of SQL:
  • Interfacing is more complex in an SQL database.
  • It Suffers From Relatively Poor Performance Scaling.