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 Database Content.

What is a Database?

In multi-user RDBMSs, each database are controlled and owned by specified users.
Rights and responsibilities vary widely among database management systems, but they often include:
- Set up permissions for other users within the database.
- Make backup copies of the database on a regular basis and running the recovery procedures in case of system failure.
- Enlarge the database if more space becomes necessary.
- Owns most of all production database objects.
- Understand the kind of data that is in the database and how it is used.
Many existing RDBMS has not fully implemented SQL ANSI standard, but some RDBMS has their own solution for some special tasks. You will also find RDBMS with their own SQL options.
However, all the RDBMS support at least the major commands, (such as CREATE, ALTER, DROP, SELECT, UPDATE, DELETE, INSERT, JOIN ...).

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