Learn All Concepts of SQL, Master SQL language for Database
A Visual Designer App to teach you SQL. All Concepts of basic and advanced SQL are included in the app. Lot of examples, elegant design and real time scenarios described in the app take you slowly through all concepts of SQL and make you a SQL Master in 20 days.
Topics included in the app
-------------------------------------
Basics
SQL Keywords
Select, Insert, Update, Delete, Alter, Create, Drop
Joins - Inner, Outer, Left, Right
SQL Date Functions
SQL Time Functions
SQL Aggregate Functions - AVG(), COUNT(), FIRST(), FORMAT(), SUM(), ROUND(), UCASE(), SPACE(), REPLACE(), NOW(), MIN(), MAX(), LAST(), LCASE(), etc.
Group By - Having
SQL Indexes
SQL Constraints - UNIQUE, NOT NULL
Between
Switch Case in SQL
Data Types
Dates
PK and FK
SQL Functions
LIKE
UNION
SQL Views
Wild Cards
Advanced SQL Topics