Summary, 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 Tutorial Summary.

     Back             Home     

Congratulations - you've reached the end of our SQL Tutorial!

Thanks for reading the SQL Tutorial at Global Guide Line
This SQL tutorial has provided you with a quick and easy way to learn SQL and here we make it easiest and hope you have really enjoyed.

We began by learning that SQL stands for Structured Query Language, and is an ANSI standard. We then learned the basic SQL syntax, before continuing on to the SELECT statement - probably the most commonly used statement.

We learned that there are various keywords and aggregate functions that can be included into SQL statements such as WHERE, COUNT, DISTINCT etc. These are all part of the DML (Data Manipulation Language).

Then, after covering the INSERT, UPDATE, and DELETE statements, we learned that there are various commands for performing administration tasks against a database. For example, there are commands for creating database objects (CREATE TABLE, CREATE INDEX, CRATE VIEW etc), and there are commands for modifying (or altering) database objects (ALTER INDEX, ALTER TABLE etc). These commands are part of the DDL (Data Definition Language). Where to Next?

If you're keen to get into SQL programming, you should download a database management system (if you haven't already) and practice SQL statements against it. You should also read your database system's documentation for any proprietary commands, functions or features. For example, does your database system have an automatic scheduler? Are you able to link your database server to a database on another server? How do you perform backups on your database system?

And lastly, if you're new to web development, check out one of the other tutorials on Quack it - for example, the HTML Tutorial, CSS Tutorial, JavaScript Tutorial, XML Tutorial and others.

     Back             Home     

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

Copyright 2005 -  2021 All rights reserved. (Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher) 389 visitors are online now