Learn T-SQL, PL-SQL and MySQL [iPad]

Learn T-SQL, PL-SQL and MySQL

Paulo Narra ￥700 iPhone / iPad対応開発ツール教育 64bit

Trend

AppStoreでチェック！

【3本セット】「Learn SQL for MySQL」「Learn & Validate SQL」「Learn PL-SQL Programming」

「Learn T-SQL, PL-SQL and MySQL」は、Paulo Narraの開発ツールアプリ「Learn SQL for MySQL」、「Learn & Validate SQL」、「Learn PL-SQL Programming」の3本をセットにしたバンドルパックです。

通常の単体合計価格1600円のところ、セット価格700円と、お得に購入することが出来ます。

開発ツール教育

使い方や遊び方

APP CREATED FOR LEARNING SQL LANGUAGE IN MYSQL SERVER

. . . . . . . . . . . . . . . . . . . . .

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)

SQL REFERENCE
__________________________________

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