下载 APKPure App
可在安卓获取Learn SQL Query的历史版本
了解SQL的所有概念,硕士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