SQL Tutorial

Getting Started SQL tutorial, We use command line examples to know about executing speed of SQL. It's take very bit of time for executing and retrieving result.

SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server and so many things about website Development. This SQL tutorial covers all. You will learn how to write SQL query like a Pro. Learn SQL with Way2tutorial.com to execute transactions or queries.

Every SQL tutorial lesson explain step by step with sample SQL Query examples. You can try that query at your end.

Oracle SQL is a very powerful and diverse database language use to storing data into databases. SQL is loosely typed language so you can learn easily.

SQL stands for Structured Query Language use for storing, manipulating and retrieving relational database data. Learn SQL tutorial, references, example.

SQL Introduction

SQL Process Flow
Rules of Semicolon(;) or Forward Slash(/)

Type of SQL Statements (DDL, DML, DCL, TCS, SCS)
SQL Data Types

Number Datatypes
Character Datatypes
LONG and ROW Datatypes
ROWID Datatypes
Date/Time Datatypes
Large Object Datatypes (LOB types)

SQL Syntax
SQL Create/SHOW/USE/DROP Table

SQL CREATE DATABASE
SQL SHOW DATABASE
SQL USE DATABASE
SQL DROP DATABASE

SQL CREATE TABLE

SQL DROP TABLE
SQL TRUNCATE TABLE

SQL DESCRIBE Statement

Basic SQL

SQL Insert

INSERT INTO Statement
INSERT ALL Statement
INSERT INTO SELECT Statement

SQL Update
SQL Delete
SQL Select
SQL Distinct
SQL Alter

Table Rename
Add New Column
Modify Existing Column
Rename Column
Drop Existing Column

SQL Where
SQL AND/OR
SQL Between
SQL IN/NOT IN
SQL LIKE (Wildcards)

SQL Constraints

SQL Constraints
SQL Primary Key

Add Primary Key (Alter Table)
Drop Primary Key (Alter Table)

SQL Foreign Key

Add Foreign Key (Alter Table)
Drop Foreign Key (Alter Table)

SQL NOT NULL Constraint

Add NOT NULL Constraint (Alter Table)
Drop NOT NULL Constraint (Alter Table)

SQL UNIQUE Constraint

Add UNIQUE Constraint (Alter Table)
Drop UNIQUE Constraint (Alter Table)

SQL CHECK Constraint

Add CHECK Constraint (Alter Table)
Drop CHECK Constraint (Alter Table)

SQL DEFAULT Constraint

Add DEFAULT Constraint (Alter Table)
Drop DEFAULT Constraint (Alter Table)

Advance SQL

SQL GROUP BY
SQL Having
SQL Order By
SQL TOP clause (LIMIT)
SQL Alias
SQL Transaction

SQL Commit
SQL Savepoint
SQL Rollback

SQL Truncate

Different Between Delete and Truncate

SQL Index

SQL Index Types
Rename Index
Drop Index

SQL Joins

Join Example Table

SQL INNER Join

SQL Equi Join
SQL Natural Join

SQL Outer Join

SQL LEFT Outer Join
SQL RIGHT Outer Join
SQL FULL Outer Join

SQL SELF Join
SQL Cross Join
SQL UNION Clause

SQL UNION vs UNION ALL

SQL Function

SQL Numeric Functions

ABS
AVG
BITEND
BIN_TO_NUM
CEIL
COUNT
FLOOR
LN
LOG
MAX
MIN
MOD
NANVL POWER
RANDOM
REMAINDER
ROUND
SIGN
SQRT
SUM
TRUNC

SQL String Functions

ASCII
CHR
CONCAT
INITCAP
INSTR
LENGTH
LOWER
LTRIM
NCHR
RTRIM
REPLACE
REGEXP_REPLACE
REGEXP_SUBSTR
REGEXP_LIKE
SUBSTR
TRANSLATE
TRIM
UPPER