Learn SQL Programming- simpleNeasyBook

by WAGmob

★ ★ ★ ★ ★ WAGmob: Over One million paying customer ★ ★ ★ ★ ★

WAGmob brings you Simple 'n Easy, on-the-go learning book for "Learn SQL Programming".

The book provides:

Snack sized chapters for easy learning.

Designed for both students and adults.

This book provides a quick summary of essential concepts in SQL Programming by following snack sized chapters:

Introduction to SQL,
•Introduction to SQL.
•History of SQL.
•How it works.
•RDBMS.
•Relational model.

Basic Data Type,
•Basic Data Type.
•Character String Data Type.
•Binary Data Type.
•Numerical Data Type.
•Date/Time Data Type.
•Relational Keys.

SQL Statements,
•SQL Statement.
•Data Query Language Statement.
•Data Definition Language Statement.
•Data Manipulation Language Statement.
•Transactional Control Language Statement.
•Data Control Language Statement.

SQL Operators,
•SQL Operators.
•Unary Operators.
•Binary Operators.
•Arithmetic Operators.
•Character Operator.
•Comparison Operators.
•Logical Operator.
•Set Operators.

Functions,
•Functions in SQL.
•Grouping Function.
•Numeric Function.
•String Function.
•Date Function.
•Conversion Function.
•General Functions.

Join,
•Join.
•SQL Equi Joins.
•Left Outer Join.
•Full Outer Join.
•Self Join.
•Non – Equi Join.
•Natural Join.
•Cross Join.

SQL Constraints,
•SQL Constraints.
•NOT NULL Constraint.
•UNIQUE Constraint.
•PRIMARY KEY Constraint.
•CHECK Constraint.
•FOREIGN KEY Constraint.
•DROP Constraint.

Subqueries,
•Subqueries.
•Subqueries with the Select Statement.
•Subqueries with the Insert Statement.
•Subqueries with the Update Statement.
•Subqueries with the Delete Statement.

Views,
•Views.
•Updatable View.
•Insert Rows into a View.
•Deleting Rows from a View.
•Dropping View.
•Inline View.

Synonyms,
•Synonyms.
•Public Synonym.
•Private Synonym.
•Drop Synonym.

Index.
•Index.
•Unique Index.
•Dropping Index.
•Index Constraint.
•Drop Index Constraint.
•How are Indexes Created.
•When Should Indexes be avoided?

Sequences and DUAL Table,
•Sequences.
•Attributes of Sequences.
•Dropping a Sequences.
•Alter Sequences.
•Introduction to DUAL.
•Selecting from DUAL.
•DUAL Examples.

About WAGmob books:
1) A companion book for on-the-go, bite-sized learning.
2) Offers value for money (a lifetime of free updates).
3) Over One million paying customers from 175+ countries.

WAGmob Vision : Simple 'n easy books for a lifetime of on-the-go learning.

Visit us : www.wagmob.

289 pages, Kindle Edition

First published July 15, 2013