Demo of Learn SQL Programming on Android Tablet

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

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

The app provides:

1. Snack sized chapters for easy learning.
2. Bite sized flashcards to memorize key concepts.


Designed for both students and adults.

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

(Each chapter has corresponding flashcards)

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 apps:

1) A companion app 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 apps for a lifetime of on-the-go learning

Visit us : www.wagmob.com

Please write to us at [email protected]. We would love to improve this app.