NEW: To learn PL/SQL programming visit our new site http://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 online training sql tutorial website teaches you the basics of SQL code and train you how to write & program SQL queries. I will be sharing my database knowledge on SQL and help you learn programming SQL better. The concepts discussed in this SQL tutorial can be applied to most of database systems. The SQL syntax used to explain the tutorial concepts is similar to the one used in Oracle database.

SQL Intro: What is SQL?

What is SQL? SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. Defined, SQL is a query language used for accessing and modifying information in 1 or more data tables and rows of a database.

SQL Database Design

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.

SQL Database Table

SQL database is constructed of a number of tables. In a business, SQL tables would be used to divide and simplify the different areas of the operation: Table for Customers, one for Vendors, Employees and so on.

Each SQL table is made up of a number of columns, referred to as fields and run along the top of the table. Sql columns or fields have their content (object/data/info) defined into character types; such as text, date, numeric, integer, length to name a few.

Each SQL table row, referred to a record, will contain a string of data containing info matching up to each column field across the top. So, in a "Customer table" each customer record would consist of one row with a customer ID number, customer name, address, phone ...and so on.

SQL Commands: Few SQL Coding Statements?

Few of the sql commands used in sql code programming are: SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, Subquery Clauses, Joins, Views, GROUP Functions, Indexes etc.

My SQL DataBase

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 SQL functions of are:

  • store data
  • modify data
  • retrieve data
  • modify data
  • delete data
  • create tables and other database objects
  • delete data

Beginner SQL Reference

Link to this Beginner-SQL-Tutorial.com SQL Home page (copy/paste into your own website or blog):

BookMark This Page

You can send your feedback, suggestions on how to improve the SQL Tutorial site to this email id: feedback@beginner-sql-tutorial.com

SQL Tutorial Topics

    SQL Statements

    SQL Clauses

    SQL Operators

    SQL Integrity Constraints

    SQL Other Topics




EnglishFrenchGermanItalianPortugueseRussianSpanish