Learn SQL [OFFLINE]

this application is a php programming tutorial application.

this application is very easy dihugunakan, does not require internet connection, and also the material discussed about php very much. the subject matter is dalah as follows:

-Chapter One - Basics

-Introduction

-Get Started

-And & Or

-Delete

-Distinct

-Insert

-Order By

-Select

-SQL Syntax

-Update

-Where

-Chapter Two - SQL Dates

-CURDATE() : MySql

-CURTIME() : MySql

-DATE() : MySql

-DATEDIFF() : MySql

-DATE_ADD() : MySql

-DATE_FORMAT() : MySql

-DATE_SUB() : MySql

-EXTRACT() : MySql

-NOW() : MySql

-CONVERT() : SqlServer

-DATEADD() : SqlServer

-DATEDIFF() : SqlServer

-DATEPART() : SqlServer

-GETDATE() : SqlServer

-Chapter Three - Functions

-AVG()

-COUNT()

-FIRST()

-FORMAT()

-Functions

-GROUP BY()

-HAVING

-LAST()

-LCASE()

-LEN()

-MAX()

-MID()

-MIN()

-NOW()

-REPLACE()

-ROUND()

-SPACE()

-SUBSTRING()

-SUM()

-UCASE()

-Chapter Four - Advance Topics

-ALIAS

-ALTER

-BETWEEN

-CASE

-CHECK

-CONSTRAINTS

-CREATE DATABASE

-CREATE INDEX

-CREATE TABLE

-DATA TYPES

-DATES

-DEFAULT

-DROP

-FOREIGN KEY

-FULL JOIN

-IN

-INCREMENT

-INNER JOIN

-ISNULL()

-JOINS

-LEFT JOIN

-LIKE

-NOT NULL

-NULLS

-PRIMARY KEY

-RIGHT JOIN

-SELECT INTO

-TOP

-UNION

-UNIQUE

-VIEWS

-WILDCARDS

-Chapter Five - Concepts

-SQL QUERY SET

-Database Keys

-Codd`s Rule

-Database Model

-SQL Constraints

-Normalization of DB

-E-R Diagram

-DBMS Terminology