SQL Basic

基本和高级SQL编程的所有概念

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