About Learn SQL for MySQL
App for students and professionals who need to learn or review SQL (MySQL) Learn and practice through examples (In the App) DML & DDL instructions with syntax and rules Will you start learning SQL in MySQL? D
App for students and professionals who need to learn or review SQL (MySQL)
Learn and practice through examples (In the App)
DML & DDL instructions with syntax and rules
Will you start learning SQL in MySQL?
Did you forget the statements many times?
Do you no longer remember the syntax and the result of an statement?
Developed to easily learn SQL Programming for MySQL
. . . . . . . . . . . . . . . . . . . . .
This App acts as a reference for the SQL language
Learn DML & DDL statements with description, syntax, notes and examples
For each statement is presented:
Detailed description of the statement/command purpose
Syntax of the statement with various options
Two examples executed from a real table (Automobile Table)
Provides:
. . . . . . . . . . . . . . . . . . . . .
1. GENERAL
1.1 - Comments
1.2 - Data Types
2. (DML) Data Manipulation Language
2.1 – SELECT
- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Limit, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union (Any & All)
- Subqueries
- Joins (Inner, Right, Left)
- Select Into
2.2 - INSERT
- With Columns names
- Without Column names
- Rules
- Insert Into ... Select
2.3 - DELETE
- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity
2.4 - UPDATE
- Update All Rows
- Update ... Where
- Rules
3. (DDL) DATA DEFINITION LANGUAGE
3.1 - CREATE
- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN)
3.2 - ALTER
- Alter Columns
- Add Constraints
- Drop Constrains
3.3 - DROP
- Drop Table
- Drop Database
- Drop Index
3.4 - TUNCATE
- Delete Versus Truncate
Dec 10, 2021
Version 2.1
Supports devices with dark mode enabled
Previous Versions
Here you can find the changelog of Learn SQL for MySQL since it was posted on our website on 2020-09-22 11:54:14.
The latest version is 2.1 and it was updated on 2024-04-19 17:48:00. See below the changes in each version.
Learn SQL for MySQL version 2.1
Updated At: 2021-12-10
Changes: Dec 10, 2021 Version 2.1
Supports devices with dark mode enabled
Learn SQL for MySQL version -
Updated At: 2021-07-18
Learn SQL for MySQL version 2.0
Updated At: 2021-07-18
Changes: Jul 18, 2021 Version 2.0
** Possibility to implement SQL programming directly in the App **
(no internet connection required)
Bug fixes and performance improvements
Learn SQL for MySQL version 1.3
Updated At: 2021-03-07
Changes: Mar 7, 2021 Version 1.3
Minor fixes
App design changes
Introduction of new languages: Portuguese (PT), Portuguese (BR), Spanish and Chinese (Simplified)
Disclaimer
Official App Store Link
We do not host Learn SQL for MySQL on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by Apple and passed their terms and conditions to be listed there. We recommend caution when installing it.
The App Store link for Learn SQL for MySQL is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.
