Learn SQL [OFFLINE] icon

Learn SQL [OFFLINE]

★★★★★
★★★★★
(0.00/5)

1Free5 years ago

Download Learn SQL [OFFLINE] APK latest version Free for Android

Version 1
Update
Size 4.85 MB (5,090,313 bytes)
Developer codingfrenzy
Category Apps, Books & Reference
Package Name learn.codingfrenzy.learnsql
OS 4.0.3 and up

Learn SQL [OFFLINE] APPLICATION description

this application is a php programming tutorial application.
this application is very easy dihugunakan, does not require internet connection, and also the material discussed about php very much. the subject matter is dalah as follows:
-Chapter One - Basics
-Introduction
-Get Started
-And & Or
-Delete
-Distinct
-Insert
-Order By
-Select
-SQL Syntax
-Update
-Where
-Chapter Two - SQL Dates
-CURDATE() : MySql
-CURTIME() : MySql
-DATE() : MySql
-DATEDIFF() : MySql
-DATE_ADD() : MySql
-DATE_FORMAT() : MySql
-DATE_SUB() : MySql
-EXTRACT() : MySql
-NOW() : MySql
-CONVERT() : SqlServer
-DATEADD() : SqlServer
-DATEDIFF() : SqlServer
-DATEPART() : SqlServer
-GETDATE() : SqlServer
-Chapter Three - Functions
-AVG()
-COUNT()
-FIRST()
-FORMAT()
-Functions
-GROUP BY()
-HAVING
-LAST()
-LCASE()
-LEN()
-MAX()
-MID()
-MIN()
-NOW()
-REPLACE()
-ROUND()
-SPACE()
-SUBSTRING()
-SUM()
-UCASE()
-Chapter Four - Advance Topics
-ALIAS
-ALTER
-BETWEEN
-CASE
-CHECK
-CONSTRAINTS
-CREATE DATABASE
-CREATE INDEX
-CREATE TABLE
-DATA TYPES
-DATES
-DEFAULT
-DROP
-FOREIGN KEY
-FULL JOIN
-IN
-INCREMENT
-INNER JOIN
-ISNULL()
-JOINS
-LEFT JOIN
-LIKE
-NOT NULL
-NULLS
-PRIMARY KEY
-RIGHT JOIN
-SELECT INTO
-TOP
-UNION
-UNIQUE
-VIEWS
-WILDCARDS
-Chapter Five - Concepts
-SQL QUERY SET
-Database Keys
-Codd`s Rule
-Database Model
-SQL Constraints
-Normalization of DB
-E-R Diagram
-DBMS Terminology
↓ Read more
Learn SQL [OFFLINE] screen 1 Learn SQL [OFFLINE] screen 2 Learn SQL [OFFLINE] screen 3 Learn SQL [OFFLINE] screen 4