價格：免費
更新日期：2017-01-12
檔案大小：5.5M
目前版本：1.0.0
版本需求：Android 4.3 以上版本
官方網站：http://datamate.ws
Email：juaslamplaystore@gmail.com
聯絡地址：Dhaka, Bangladesh.
Becoming fluent in SQL takes practice. Reading up, studying the theory or simply knowing the syntax will take you so far; but only regular practice on the full range of the language will make you fluent.
10s Query should also be hassle-free and (yes!) fun. With Knowledify, you will play the role of a freshly hired employee. Through a series of assignments more and more complex around the new database system that you new employer has deployed, you will move up within the company and become masterful in the art of SQL.
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
Features
• Database Basics
• Key SQL Statements
• Retrieving, Updating, and Filtering Data
• Functions and Subqueries
• Creating, Updating, and Deleting Tables
• Joining Multiple Tables
• Creating Custom Views