SQL Introduction, SQL Tutorial, Global Guide Line Technology.
Forum | Blog |


Basic SQL Guide.           
SQL Introduction.
 What is Table?                  
 SQL Create Table.            
 SQL Insert Statement.      
 SQL Select Keyword.        
 SQL Order by clause.        
 SQL Count Statement.      
 SQL Group By Clause.      
 SQL Having Clause.          
 SQL Alias Tables.             
 SQL Join Tables.              
 SQL Outer Join.               
 SQL Update Statement.   
 SQL Delete Statement.    
 SQL Distinct Keyword.      
 SQL Where Keyword.       
 SQL And Or Keyword.      
 SQL In Keyword.              
 SQL Between Keyword.   
 SQL Like Keyword.          
 SQL Functions.                
 SQL Concatenate.           
 SQL Substrings.               
 SQL Trim Function.         
 SQL Constraints.              
 SQL Primary Key.            
 SQL Foreign Key.            
 SQL Create Views.           
 SQL Create Index.           
 SQL Alter Table.             
 SQL Drop Table.             
 SQL Truncate Table.      
 SQL Summary.                

SQL Tutorial >> SQL Introduction.

     Back             Next     

SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, update, delete) and database creation.

Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use SQL as standard database language. Now a word of warning here, although all those RDBMS use SQL, they use different SQL dialects. For example MS SQL Server specific version of the SQL is called T-SQL, Oracle version of SQL is called PL/SQL, MS Access version of SQL is called JET SQL, etc.

Our SQL tutorial will teach you how to use commonly used SQL commands and you will be able to apply most of the knowledge gathered from this SQL tutorial to any of the databases above.

This SQL tutorial site lists commonly-used SQL statements, and it covers the following sections:

         1- SQL Data Manipulation Language (DML)
         2- SQL Data Definition Language (DDL)

In Structured Query Language we use syntax for executing queries. And the SQL language also covers a syntax to Select, Update, Insert, and Delete records in a database and these points of interacting with database is called DML.
In Select section we will learn how to extract data from the database.
In Update we will learn how to update data stored in database.
in Insert section we will see how can we insert our own records in database.
And in Delete section we will learn how to remove an existing record from database.

DDL covers how to Create Delete and Alter a Table or an Index.  In this section we will also cover the RDBMS, (Relational Database Management System). It means the relations of the database tables and indexes and impose constraints between database tables.
For each command, the SQL syntax we will first be presented and explained, followed by an example. At the end of this tutorial, you should have a good general understanding of the SQL syntax, and be able to write SQL queries using the correct syntax. Our experience is that understanding the basics of SQL is much easier than mastering all the particulars of this database language, and We are sure that you will reach the same conclusion as well.  SQL is quite easy to learn and you will really enjoy during learning with GGL.

Now come to learn SQL and we offer to use our link for the convenience of the viewers to reach SQL Tutorial.

Note: If you like this site, you are welcome to link here from your own website. Below is a sample code of GGL you can use it.

<a href=https://www.globalguideline.com/sql/>SQL Tutorial</a>

     Back             Next     

[ About ] [ Contact ] [ Home ]
[ Links ] [ Site Map ] [ Services ] [ Privacy ]

Copyright 2005 -  2022 www.globalguideline.com All rights reserved. (Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher) 282 visitors are online now