APP DEVELOPED TO EASILY TEACH SQL LANGUAGE (T-SQL) FOR SQL SERVER

__________________________________

This App acts as a reference for the SQL language (Learn DML & DDL statements). For each statement is presented:

1) Detailed description of the statement/command purpose
2) Syntax of the statement with the various options
3) Two examples executed from a real table (Automobile Table)

*** AVAILABLE CATEGORIES AND STATEMENTS ***
__________________________________

1. GENERAL

1.1 - Comments
1.2 - Data Types
1.3 - Data Types (Numeric)
1.4 - Data Types (Text)
1.5 - Data Types (Dates)

2. (DML) Data Manipulation Language

2.1 – SELECT

- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Rownum, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union, Intersect, Except (Any & All)
- Subqueries
- Joins (Inner, Full, Right, Left)
- Select Into

2.2 - INSERT

- With Columns names
- Without Column names
- Rules
- Insert Into ... Select

2.3 - DELETE

- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity

2.4 - UPDATE

- Update All Rows
- Update ... Where
- Rules


3. (DDL) DATA DEFINITION LANGUAGE

3.1 - CREATE

- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN, IX)

3.2 - ALTER

- Alter Columns
- Add Constraints
- Drop Constrains

3.3 - DROP

- Drop Table
- Drop Database
- Drop Index

3.4 - TUNCATE

- Delete Versus Truncate