https://plsql-tutorial.com
SQL Tutorial
SQL (Structured Query Language) is used to modify and access data or information from a storage area called database. This beginner sql tutorial website teaches you the basics of SQL and how to write SQL queries. I will be sharing my knowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can be applied to most of database systems. The syntax used to explain the concepts is similar to the one used in Oracle database.
SQL Introduction
SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. It is a query language used for accessing and modifying information in the database. IBM first developed SQL in 1970s. Also it is an ANSI/ISO standard. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it's feature and making it a powerful tool. Few of the sql commands used in sql programming are SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, ORDER Clause, Joins, Views, GROUP Functions, Indexes etc.
In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:
» modify data
» retrieve data
» modify data
» delete data
» create tables and other database objects
» delete data
You can send your feedback, suggestions on how to improve the site to this email id:
feedback@beginner-sql-tutorial.com
Link to this SQL page (copy/paste into your own website or blog):
SQL Tutorial Topics
1. SQL Statements
» SQL INSERT
» SQL UPDATE
» SQL DELETE
» SQL CREATE TABLE
» SQL ALTER TABLE
» SQL RENAME
» SQL TRUNCATE
» SQL DROP
2. SQL Clauses
3. SQL Operators
4. SQL Integrity Constraints
» Foreign Key Constraint
» Not Null Constraint
» Unique Key Constraint
» Check Constraint
5. SQL Other Topics
» SQL Aliases
» SQL Group Functions
» SQL JOINS
» SQL VIEWS
» SQL Subquery
» SQL Index
» SQL GRANT, REVOKESQL Subquery