SQL Tutorial

SQL Stands for "Structure Query Language" and Standard Relational Data Base Language. The SQL supports the all Database products like Oracle SQL,SQL Server, My SQL, DB2, Teradata etc .This tutorial teaches the How to write the queries,Trobleshoot and Optimize the SQL.

In This Tutorial You will Learn from Basics of SQL to Advanced Topics of Database Products like Oracle products, Sql Server product, My sql product and Teradata product.

With this "SQLVisitors" Tutorial , You should becoming one of the top Proficient in writing SQL Queries, Trobleshooting, Executing the Queries and Optimizing The Queries.

 In this SQL Tutorial  first you will learn the basics of  SQL concepts of Oracle

   

Sub Languages	1) DDL (Data Definition Language )                                      2) DML (Data Manupulation Language ) ,                    3) DQL (Data Query Language)                      4) DCL (Data Control Language)                      5) TCL (Transaction Control Language)                      6) SYSL (System Control Language )                      7) SCL (Session Control Language )
Data Types	1) CHAR                      2) VARCHAR2                      3) NUMBER                      4) DATE                     5) TIMESTAMP
Constrains	1) NOT NULL                     2) UNIQUE                     3) PRIMARY KEY                     4) CHECK                     5) REFERENCE                     6) DEFAULT
Functions	1) Single Row Functions,                                                 2)Multiple Row Functions
Joins	1) Inner Join/Simple Join/Equi Join                    2) Non Equi Join                    3) Cross Join                    4) Self Join,                    5) Outer Join                            a) Left Outer Join                            b) Right Outer Join                            c) Full Outer Join
Sub Queries	1) Single Row Query                   2) Multiple Row Query                   3) InLine Query
Clauses	1) DISTINCT Clause                   2) FROM Clause                   3) WHERE Clause                   4) ORDER BY Clause                   5) GROUP BY Clause                   6) HAVING Clause
Aggregate Functions	1) COUNT Function                   2) SUM Function                   3)  AVG Function                  4) MAX Function                  5) MIN Function
Conditions	1) And Condition                2) OR Condition                3) Like Condition                4) IN Condition                5) NOT Condition                6) IS NULL Condition                7) IS NOT NULL Condition               8) BETWEEN Condition               9) EXIST Condition              10) AND OR