SQL Tutorial

Introduction -

Data is distinct useful information. It can be used in a variety of forms like text, numbers, media, bytes, file, pdf etc. generally it is raw and unprocessed. It can be stored in pieces of paper or electronic memory. Word 'Data' is originated from the word 'datum' that means 'single piece of information'. It is plural of the word datum. Data is interchangeable.

Audiences & Objective -

In this tutorial, all the topics are covered with in-depth information and can understandable by anyone. The tutorial is intended for the readers who are interested to learn the SQL as a beginner or the reader and want to increase the level of expertise in SQL.

Prerequisites -

Readers who are from computater background can understand the concepts a bit easily. Reader who are not from computater background may need to go through the topic more than once to understand clearly.

SQL Tutorial
- Basics
  - Introduction
  - Features
  - DBMS
  - Install SQL Server
  - Syntax
  - Data Types
  - Comments
  - Operators
  - Commands
- Database
  - Database Overview
  - CREATE
  - DROP
  - RENAME
  - SELECT DATABASE or USE DATABASE
  - Backup
- Table
  - What is Table
  - CREATE TABLE
  - CREATE TABLE AS
  - DROP Table
  - DELETE Table
  - RENAME Table
  - TRUNCATE Table
  - COPY Table
  - ALTER Table
  - GLOBAL TEMP Table
  - LOCAL TEMP Table
  - SELECT FROM
- Index
  - What is Index
  - CREATE INDEX
  - ADD INDEX
  - DROP INDEX
- View
  - What s View
  - CREATE VIEW
  - ALTER VIEW
  - DROP VIEW
- Keys
  - Primary Key
  - Foreign Key
  - Composite Key
  - Unique Key
  - Alternate Key
- Constraints
  - Add Constraint
  - Drop Constraint
  - NOT NULL Constraint
  - DEFAULT Constraint
  - UNIQUE Constraint
  - CHECK Constraint
- SELECT Statement
  - SELECT Statement
  - SELECT UNIQUE
  - SELECT DISTINCT
  - SELECT COUNT
  - SELECT TOP
  - SELECT FIRST
  - SELECT LAST
  - SELECT RANDOM
  - SELECT AS
  - SELECT IN
  - SELECT Multiple
  - SELECT DATE
  - SELECT SUM
  - SELECT NULL
  - SELECT LIMIT
  - SELECT Wildcard
- Clauses
  - WHERE Clause
  - DISTINCT Clause
  - FROM Clause
  - ORDER BY Clause
  - GROUP BY Clause
  - HAVING Clause
- Comparison Operators
  - Comparison Operators
- Conditions
  - AND Condition
  - OR Condition
  - AS Condition
  - LIKE Condition
  - IN Condition
  - NOT Condition
  - IS NULL Condition
  - IS NOT NULL Condition
  - BETWEEN Condition
  - EXISTS Condition
- Order By
  - ORDER BY Clause
  - ORDER BY ASC
  - ORDER BY DESC
  - ORDER BY RANDOM
  - ORDER BY LIMIT
  - ORDER BY Multiple Cols
- INSERT Statement
  - INSERT Statement
  - INSERT INTO Values
  - INSERT INTO SELECT
  - INSERT IGNORE
  - INSERT Multiple Rows
- UPDATE Statement
  - UPDATE Statement
  - UPDATE JOIN
  - UPDATE DATE
- DELETE Statement
  - DELETE Statement
  - DELETE TABLE
  - DELETE ROW
  - DELETE All Rows
  - DELETE Duplicate Rows
  - DELETE DATABASE
  - DELETE VIEW
  - DELETE JOIN
- Joining Tables
  - JOIN
  - Inner Join
  - Outer Join or Full Join
  - Left Outer Join
  - Right Outer Join
  - Self Join
  - Cross Join
- Aliases
  - ALIASES
- NULL Functions
  - ISNULL Function
  - IFNULL Function
  - NVL Function
  - Coalesce Function
  - NULLIF Function
- Advanced
  - UNION Operator
  - UNION ALL Operator
  - INTERSECT Operator
  - MINUS Operator
  - EXCEPT Operator
  - MERGE Statement
  - Subquery
  - CASE
  - DECODE
  - AUTO INCREMENT
  - IDENTITY
  - SEQUENCE & NEXTVAL
  - Stored Procedures
  - Handling Duplicates
  - Transactions
  - Inline View
  - Triggers
  - CTE
- SQL Functions
  - Mathematical Functions
  - Conversion Functions
  - General Functions
  - Conditional Expressions
  - Character Functions
  - Date Functions
  - Aggregate Functions
  - Scalar Functions
  - Advanced Functions
- NoSQL
  - NoSQL
  - SQL vs NoSQL
- SQL Injection
  - Injection
- References
  - Keywords
  - Operators
  - Data Types
  - MySQL Functions
  - SQL Server Functions
  - MS Access Functions