SQL Learning:

	Introduction
SQL Managing Databases
	SQL Database Content
	SQL Create Database
	SQL Listing Databases
	SQL Use Database
	SQL Alter Database
	SQL Drop Database
SQL Managing Tables
	SQL Tables Content
	SQL Create Table
	SQL Table Column Types
	SQL Table Primary Key
	SQL Auto Increment
	SQL Unique Columns
	SQL Table Constraints
	SQL Drop Table
	SQL Alter Table with ADD
	SQL Alter Table with MODIFY
	SQL Alter Table with DEFAULT
	SQL Alter Table with DROP
SQL Managing Indexes
	SQL Why Table Indexes
	SQL Create Table with Indexes
	SQL Create Index on Table
	SQL Alter Table Indexes
	SQL Drop Table Indexes
	SQL Rename Table Index
SQL Data Modification
	SQL Insert Table Data
	SQL Update Table Data
	SQL Delete Table Data
SQL SELECT
	SQL SELECT Overview
	SQL Column Selection & Design
	SQL Column Computation
	SQL FROM tables
SQL WHERE
	SQL WHERE Statement
	SQL Where Comparison
	SQL AND, OR, NOT
	SQL BETWEEN, NOT BETWEEN
	SQL IN, NOT IN
	SQL LIKE, NOT LIKE
	SQL NULL values & COALESCE
	SQL Operator Precedence
SQL Sorting and grouping
	SQL ORDER BY
	SQL DISTINCT
	SQL GROUP BY
	SQL HAVING
SQL Functions
	SQL Aggregate Functions
	SQL String Functions
	SQL Date and Time Functions
	SQL Numeric Functions
SQL JOIN Tables
	SQL JOIN Basics
	SQL JOIN with FROM/WHERE
	SQL INNER JOIN
	SQL CROSS JOIN
	SQL NATURAL JOIN
	SQL LEFT JOIN
	SQL RIGHT JOIN
	SQL FULL JOIN
	SQL JOIN with USING
	SQL JOIN ON/WHERE Operators
	SQL JOIN Multiple Tables
	SQL UNION
	SQL INTERSECT
	SQL MINUS
	SQL VIEW

SQL Why Table Indexes.

Where, What and Why Index?

In a relational database management system, an index is a mechanism for boosting performance.
This is true for the selecting of data from tables, but not for the updates, it may be slow down the performance.
Create a unique index on the column or columns included in the PRIMARY KEY of a table as the PRIMARY KEY is often used in connection with other tables.
A column that appears often in sorted order should be indexed so that the system can take advantage of an indexed sort.
Columns that are regularly used in joins should be indexed because the database management system performs the join faster.
Columns, which is used to search for upper or lower limits can be a good choice for indexing.

This site aims to provide FREE programming training and technics.

Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.

The risk of using this web-site pages or any program codes from this website is entirely at the individual user.

Needed Tools for SQL